ayuda con xbrowse

Post Reply
User avatar
nageswaragunupudi
Posts: 10721
Joined: Sun Nov 19, 2006 5:22 am
Location: India
Been thanked: 8 times
Contact:

Re: ayuda con xbrowse

Post by nageswaragunupudi »

There is no change between 12.04 and 17.09 with regards to AUTOSORT.
If it works in 12.04 it should work with 17.09 also.

But as we can see from your code, autosort should not work either with 12.04 or 17.09.
Even assuming the DBF is indexed on all fields, how do you expect XBrowse to know which Index is to be used for which columnn?

In the above code, we should add the clause

Code: Select all | Expand


SORT <ordTag1>, <ordTag2>,........, <ordTagN> ;
 

to inform XBrowse to which index tag for which column.


We keep advising in the forums not to use FIELDS clause but use COLUMNS clause. That allows XBrowse to know which index is to be used for which column.

Recommended way to define XBrowse:

Code: Select all | Expand

REDEFINE XBROWSE olbx ID 181 OF odlg ;
   DATASOURCE cAlias ;
   COLUMNS "Numero","Nombre","Domic","copo","loca",     "tele",   "tipodoc","vendedor","Lista","con_iva","CUIT","conpago" ;
   HEADERS nil,      nil,    nil,"C.Postal","Localidad","TelFono","T.Doc",  "Vend.",  , nil,   "IVA",    nil,   "Condician de pago" ;
   PICTURES "999999999",nil, nil,     nil,   nil,        nil,      nil,     "99",       "99",  "99" ;
   AUTOSORT CELL LINES NOBORDER FONT ofont1
 


Now, XBrowse knows the field-names used for each column. From the field-names, xbrowse will check to see if an index exists for the column and uses that index for autosort.
Regards

G. N. Rao.
Hyderabad, India
Post Reply