Re: ayuda con xbrowse
Posted: Fri Oct 29, 2021 6:50 pm
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
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:
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.
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.