QueryDesignerViacode

rbuser

I saw the post on the sample of code to use QueryDesignerViaCode and I
wish to do the same thing, but can you tell me how to change it so I can
access Advantage Tables?

Thank you,

Brian Paine

digitalmetaphors

You'll need to use a TdaADSSession instead of a TdaBDESession. Change the
SQL object's data settings to dtAdvantage and sqSQL2.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I made the changes as you suggested and I now see the tables. However, when I
click on the Fields tab I get an Advantage error that the server cannot be
found and the table cannot be opened. Any ideas? There must be more than just
changing the settings in the code.

Brian Paine

digitalmetaphors

You need to configure the Advantage ADS.ini file to have the database name
that you want to connect to. Use the data architect to create this alias.
This way you can assign the matching alias to the SQL object's database
name.


Cheers,

Jim Bennett
Digital Metaphors