>>>>>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.