FiveTech Software tech support forums

Posted: **Wed Sep 23, 2009 2:52 am**

I am using Advantage Database Server version 8.1

I have the AIS portion of my system running like a charm. However, I want to switch to ALS and create temp tables here and there in my code. I cannot seem to figure out how to use *both* ALS and AIS in the same application.

Can someone help me out? My specific question is how to COPY STRUCTURE, USE, etc. using ALS when I have an active .ADD
connected via AIS.

TIA

Andy

Posted: **Wed Sep 23, 2009 10:09 am**

TIA,

See:

AdsCopyTableStructure()

Regards

Posted: **Thu Sep 24, 2009 1:46 am**

arpipeline wrote:I am using Advantage Database Server version 8.1

I have the AIS portion of my system running like a charm. However, I want to switch to ALS and create temp tables here and there in my code. I cannot seem to figure out how to use *both* ALS and AIS in the same application.

Can someone help me out? My specific question is how to COPY STRUCTURE, USE, etc. using ALS when I have an active .ADD
connected via AIS.

TIA

Andy

Mr. Andy,

I have a similar application which uses both ADS and ALS at the same time.

Code: Select all

 ...
 hADS := 0
 hALS := 0

 lServerOK := ADSConnect60(  <.add location>,4,'adssys',,,@hADS)
 ...
 lLocalOK  := ADSConnect60( <.add location>,1, 'adssys',,,@hALS)
 ...

Use this to switch your connection

Code: Select all

...

AdsConnection( hADS )    //switch to ADS handle
...

AdsConnection( hALS )    //switch to ALS handle
...

All other ADS operation are standard.

Regards,
-Frances

FiveTech Software tech support forums

ADS 5132 Errors / Struggles with Internet and Local Server

ADS 5132 Errors / Struggles with Internet and Local Server

Re: ADS 5132 Errors / Struggles with Internet and Local Server

Re: ADS 5132 Errors / Struggles with Internet and Local Server