Page 1 of 1

DBT memos with ADSDBE

Posted: Sat Apr 29, 2023 9:43 am
by 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?

Re: DBT memos with ADSDBE

Posted: Sat Apr 29, 2023 11:01 am
by 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.

Re: DBT memos with ADSDBE

Posted: Sat Apr 29, 2023 11:13 am
by 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

Re: DBT memos with ADSDBE

Posted: Sat Apr 29, 2023 11:22 am
by SlavkoDam
Yes, ADSDBE_MEMOFILE_EXT is RO. But, it has to be used ADSDBE_TBL_MODE which is RW.

Re: DBT memos with ADSDBE

Posted: Sat Apr 29, 2023 11:38 am
by 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.

Re: DBT memos with ADSDBE

Posted: Sat Apr 29, 2023 11:51 am
by SlavkoDam
What exactly do you want to specify and achieve?

Re: DBT memos with ADSDBE

Posted: Sat Apr 29, 2023 5:17 pm
by 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.

Re: DBT memos with ADSDBE

Posted: Sun Apr 30, 2023 3:04 am
by 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.