ADS sorting

Xbase++ 2.0 Build 554 or later
Post Reply
Message
Author
Janko
Posts: 111
Joined: Sat Mar 20, 2010 8:36 am
Location: Cerklje

ADS sorting

#1 Post by 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

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: ADS sorting

#2 Post by 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.
The eXpress train is coming - and it has more cars.

Janko
Posts: 111
Joined: Sat Mar 20, 2010 8:36 am
Location: Cerklje

Re: ADS sorting

#3 Post by 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

Post Reply