>>>>>>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