Unanswered: delphi TQuery and results on sapdb local
I have TQuery (Delphi 7 Ent) connecting to an sap db (v7.xx) local installation via odbc user dsn
in tquery sql porperty 'SELECT * FROM BBD.BBD_URUN'
statement returns results into a dbgrib that is connected to a datasource
The problem is when i run the sql statement in sql studio or else I get resultset. But in Delphi using BDE-ODBC pair some column names and values for any table in this sapDB database are not available.
When I replace TQuery with TTable I can set databasename property but when I try to set tablename I receive a General SQL Error.
Am I losing one step (For ex. do I have to create a BDE alias for the odbc dsn) or is there a problem with bde odbc drivers