Can someone point me to some manual/examples of querys against a clarion / tps database via ODBC.
I'm trying to do a like querey eg.
"SELECT Field1, Field2 FROM ATable WHERE Field1 like 'abc%' "
and keep getting a [ ERROR [S0000] [TopSpeed Corp.][TopSpeed ODBC Driver]Invalid operand for operator: LIKE ]
& a Top Records eg.
"SELECT Top 100 * FROM ATable"
and keep getting a [ERROR  [TopSpeed Corp.][TopSpeed ODBC Driver]Expected lexical element not found: FROM]