Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

QueryDesignerViacode

edited October 2002 in End User
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

Comments

  • edited October 2002
    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

  • edited October 2002
    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

  • edited October 2002
    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

This discussion has been closed.