Hi,
when creating a remote-view with visual foxpro, the SQLPrepare()
is not called with the correct sql-statement.
The driver always prepends "SYSDBA." before the specific table.
eg:
SELECT * FROM SYSDBA.TEST
instead of:
SElECT * FROM TEST
...
I guess the username was used (putted before the relationname),
but how could it happen?
-->
The statement was formed by VFP, but this only happens with this driver . Which
method/function tells VFP to do so?.
-----
A last another proposal concerning VFP-Views:
in ODBCStatement.cpp line794ff:
use this code:
RETCODE OdbcStatement::sqlNumResultCols(SWORD * columns)
{
clearErrors();
if (!resultSet ){
// if the resultSet does not exist, execute it, to get a valid resultSet
// Foxpro calls this function to get all column-descriptions for its
// remote-views.
// This fixes the bug : ' I can't edit my remote-views in Visial FoxPro'
this->executeStatement();
}
.....
---------
If someone has a better idea to get a valid resulSet ... please let me know
|
