DBT memos with ADSDBE

[rdonnay]

The Alaska documentation states that ADSDBE is compatible with DBT memo files, however there are no examples of how to enable this feature.

Has anyone successfully used ADSDBE with DBT memos and CDX Indexes?

[SlavkoDam]

This is from Alaska documentation how it works and how to change it.

In its default configuration, the ADSDBE uses Clipper compatible file formats for memo (DBT) and index (NTX) files, compatible record locking schemes and checks file access rights defined for a user on the file server. These default settings can be overridden using DbeInfo().

ADSDBE_TBL_MODE

There are two constants defined in ADSDBE.CH that allow for selecting the file formats used by the ADS:

A) DbeInfo( COMPONENT_DATA , ADSDBE_TBL_MODE, ADSDBE_NTX )
DbeInfo( COMPONENT_ORDER, ADSDBE_TBL_MODE, ADSDBE_NTX )

B) DbeInfo( COMPONENT_DATA , ADSDBE_TBL_MODE, ADSDBE_CDX )
DbeInfo( COMPONENT_ORDER, ADSDBE_TBL_MODE, ADSDBE_CDX )

C) DbeInfo( COMPONENT_DATA , ADSDBE_TBL_MODE, ADSDBE_ADT )
DbeInfo( COMPONENT_ORDER, ADSDBE_TBL_MODE, ADSDBE_ADT )

The first (variant A) is the default setting and selects the Clipper compatible file formats for index (NTX) and memo (DBT) files. This complies with the file specifications for the Xbase++ Database Engines DBFDBE and NTXDBE.

The second (variant B) selects FoxPro compatible file formats. The ADS uses CDX index files and FPT memo files in this case. They are compliant with the file specifications for the CDXDBE and FOXDBE of Xbase++.

The third (variant C) selects Advantage properitary file formats. The ADS uses ADI index files and ADM memo files in this case. For more information please be referred to the Advantage Database Server documentation.

[rdonnay]

I read all of that, but dbeInfo() doesn't allow using that because it is Read Only.

#define ADSDBE_MEMOFILE_EXT (DBE_USER+1) // RO

[SlavkoDam]

Yes, ADSDBE_MEMOFILE_EXT is RO. But, it has to be used ADSDBE_TBL_MODE which is RW.

[rdonnay]

Yes, ADSDBE_MEMOFILE_EXT is RO. But, it has to be used ADSDBE_TBL_MODE which is RW.

ADS_DBE_TABLEMODE can only be NTX, CDX or ADT.

[SlavkoDam]

What exactly do you want to specify and achieve?

[rdonnay]

I have a customer with an application that uses DBFCDX files with DBT memos.

I want to use ADSDBE so can can do SQL queries against their data.

I have been doing this for years with FOXCDX and FPT memos.

The ADSDBE documentation implies that this should be possible but there is no example on how to configure the ADSDBE and the documentation is vague.

I sent a support request to Alaska Software.

[Wolfgang Ciriack]

Hello Roger,
CDX and DBT does not work with ADS, that was the reason i changed to FOXCDX and FPT some years ago.