[Firebird-odbc-devel] Creating, Editing Remote-Views with FoxPro

[<sc...@de...>]

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