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

[Carlos G.A. <car...@ho...>]

Hello:

    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


This is corrent only if you don´t check the box "All user tables" ( todas 
las tablas de usuario ) and then select the table form create the view.

Best Regards
Carlos Guzmán Álvarez

>From: sc...@de...
>To: fir...@li...
>Subject: [Firebird-odbc-devel] Creating, Editing Remote-Views with FoxPro
>Date: Fri, 7 Jun 2002 10:16:32 +0200
>
>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
>
>
>
>_______________________________________________________________
>
>Don't miss the 2002 Sprint PCS Application Developer's Conference
>August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
>_______________________________________________
>Firebird-odbc-devel mailing list
>Fir...@li...
>https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel




_________________________________________________________________
Únase con MSN Hotmail al servicio de correo electrónico más grande del 
mundo. http://www.hotmail.com