Search found 10 matches: lname

Return to advanced search

Re: ADO & SQL INSERT Statement

... 4GL code fragment shows the declaration of an insert cursor: DEFINE the_company LIKE customer.company, the_fname LIKE customer.fname, the_lname LIKE customer.lname DECLARE new_custs CURSOR FOR INSERT INTO customer (company, fname, lname) VALUES (the_company, the_fname, the_lname) When ...
by avista
Thu Jul 31, 2014 7:28 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO & SQL INSERT Statement
Replies: 9
Views: 2216

Re: xBrowse array and move to a specific row

... .. Please do not fret on this as I have decided that 5k employee records just takes too long to load and build an array. I decided to leave the Lname field un-encrypted on my table .. everything else is all encrypted. It was just easier to manage .. don't know if this will be acceptable to the ...
by Rick Lipkin
Thu Feb 28, 2013 9:31 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xBrowse array and move to a specific row
Replies: 5
Views: 1320

Re: Sorting xBrowse on an encrypted ADO table

1. Please check if the Encrypted values are also in the same sort order as the Decrypted values. If so, you can use oCol:cSortOrder := "LNAME,FNAME,MNAME" 2. (a) It is possible to assign a codeblock to oCol:cSortOrder Example: oCol:cSortOrder := { |oCol| MySortFunc( oCol ) } Inside ...
by nageswaragunupudi
Wed Feb 27, 2013 3:24 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Sorting xBrowse on an encrypted ADO table
Replies: 2
Views: 847

Re: Xbrowse Autosort disabled when inserting a column in code

Rao

I noticed if I just selected the Sort "LNAME" ( instead of "LNAME,FNAME") everything worked as you suggested!

Thanks
Rick Lipkin
by Rick Lipkin
Fri Mar 30, 2012 3:23 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Xbrowse Autosort disabled when inserting a column in code
Replies: 5
Views: 1634

Re: Xbrowse Autosort disabled when inserting a column in code

We have to add SORT <uOrder> clause to the ADD TO oBrw command. In your example, please try adding SORT "LNAME,FNAME"  to the ADD TO oBrw command. Because this is a browse of recordset, the expression oRs:Sort := "LNAME,FNAME" will be used by xbrowse for ...
by nageswaragunupudi
Thu Mar 29, 2012 1:48 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Xbrowse Autosort disabled when inserting a column in code
Replies: 5
Views: 1634

Re: Incremental Search

... suggestions .. what I was hoping to achieve here using an Access recordset was something like this: Select * from Customer oRs:Filter := "lname = 'bogus'" // gives me a eof recordset so the listbox is empty Then as the user types I was hoping to modify the filter condition cLname ...
by Rick Lipkin
Sat Mar 03, 2012 11:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Incremental Search
Replies: 8
Views: 3044

... .. consider this code : oRs:Sort := "fname" oRs:MoveFirst() oRs:Find("fname = '"+cFIND+"'" ) oLBX:ReFresh() SysReFresh() .. or oRs:Sort := "lname" oRs:MoveFirst() oRs:Find("lname = '"+cFIND+"'" ) oLBX:ReFresh() SysReFresh() .. Rick Lipkin
by Rick Lipkin
Sat Mar 01, 2008 4:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO Sql and Requery
Replies: 2
Views: 836

... .. many times I have a 'find' routine that I need to re-order the same information .. to do this I have used my origional order by query ( lname ) and if I needed to find a group of records matching a like % on fname ...I used the oRs:Filter .. but the filter is a bit clumsy and you have ...
by Rick Lipkin
Sat Feb 09, 2008 3:16 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Another for MDB recorset
Replies: 41
Views: 9381

question ... on a related note .. consider this query : Select lname,fname from Customer order by lname ... ... lets say I want to re-order my existing recordset created by the above query .. are you saying I can oRs:Sort := 'fname' to reorder ?? or do ...
by Rick Lipkin
Sat Feb 09, 2008 2:53 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Another for MDB recorset
Replies: 41
Views: 9381

... over 45 days old that must be "+chr(10) SAYING += "RESOLVED "+DTOC(P_TRIPS->DATE)+" "+P_TRIPS->VNUMBER+chr(10) SAYING += " "+P_TRIPS->LNAME+chr(10) MsgInfo( SAYING ) ENDIF dDATE1 := DATE()-45 ELSE dDATE1 := P_TRIPS->DATE ENDIF IF dDATE1 > DATE() dDATE1 := DATE() ENDIF dDATE2 ...
by Rick Lipkin
Mon Aug 27, 2007 4:34 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Help hotel Planning
Replies: 2
Views: 937

Return to advanced search