ADS sorting

[Janko]

Dear Roger,

in a browser I use following code:

Code: Select all

DCBROWSECOL FIELD DOG->PARTNER ;
  HEADER "SIF PART" PARENT oBrowse FOOTER '2' SORT {||DOG->(ordSetFocus('partner')) }

If ADS is off, SORT (clicking header) is working as desired, when ADS is on only first index (first of eight) is used for sort.

Do you maybe have a suggestion how to mend the erratic behaviour?

Any idea appreciated.

Best regards
Janko

[rdonnay]

I have not seen this behavior with ADS.
What I have seen is the browse does not behave correctly because the index is not ADS compatible.

I am guessing that you use DBFCDX or FOXCDX when you are not using ADS.

Is this correct?

If so, then you need to make sure that your .CDX files are compatible with ADS.

In your DBESYS (where you load your DBEs) do the following:

Code: Select all

dbeSetDefault('FOXCDX')

or 

dbeSetDefault('DBFCDX')

DbeInfo( COMPONENT_ORDER, CDXDBE_MODE, CDXDBE_FOXPRO2X ) // works with ADS

You will then need to create your .CDX files again.

Alternatively, make sure that you create your .CDX files with ADS.
This will make them also work with DBFCDX or FOXCDX.

[Janko]

Roger,

you are right, during development I am using mixed DBEs, FOXCDX, DBFCDX and SQL without ADS. I am obviously not careful enaugh while creating tables.

Thank you for guidelines.

BR Janko