>>>>>>>Thanks for the help
>>>>>>
>>>>>>You are welcome. Are this working? It sould, but just curious :-)
>>>>>
>>>>>Hi Borislav,
>>>>>
>>>>>I too am attempting to connect using Cursor Adaptors to Clarion via their ODBC drivers.
>>>>>
>>>>>I created a connection string as you instructed, and I get a OK response on the the Test connection.
>>>>>
>>>>>My next step is within the cursor adaptor builder I want to enter a select statement that will display the tables and fields available in a specific tps file.
>>>>>
>>>>>I try variations on Select * from 12345, Select * from 12345.tps, Select * from 12345\!Debtor. All error out in the cursor adaptor builder: Message: Variable 'TABLE_NAME' is not found. Method OMEMBER.gettables.
>>>>>
>>>>>Can anyone help?
>>>>>
>>>>>thanks
>>>>>bill
>>>>
>>>>I am not sure, because I never worked with Clarion Tables, what is 12345? Is this a Database name or this is a table name?
>>>
>>>12345 is just the table name. Is is a "top Speed" table which contains multi-tables within it. Kind of a DBC container.
>>
>>What happens if you use:
>>

>>IF SQLTABLES(YourODBCConnectionHandler,['TABLE'],[crsTables]) < 0
>>   AERROR(laError)
>>   MessageBox(laError[1,2])
>>   RETURN
>>ENDIF
>>BROW NORMAL
>>

>Yes !!!!!
>I get a list of all of the Tables within each TPS file in the directory.
>
>This is great - I feel we have made so much progress - thank you -
>
>Still - I am lost as to how to utilize this info in my CA situation.
>
>thanks again
>bill


Run the builder, choose ODBC, Then Use Connection String. In the connection string edit box paste the connection string you use for YourODBCConnectionHandler :-), Test Connection. Then if the connections is successful go to Data Access tab and build the Select statement.