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

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

Hello:

I have the same problem but i solve it( partially because my solution fails 
in a concret situation ) in other way than you, the problem is caused 
because the driver only have access to the resultset of a executed 
statement, your solution is correct but if you have a table with a lot of 
records you have to wait to the finish of the execution of it, the good 
solution is ( i think ) make that the driver have access to the resulted of 
the prepared statement( i don´t post my code because i´m in a cyber and 
don´t have them ).


Best Regards
Carlos Guzmán Álvarez
Vigo-España

P.D: Sorry about my bad english but i´m spanish.



>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




_________________________________________________________________
MSN Photos es la manera más sencilla de compartir e imprimir sus fotos: 
http://photos.msn.com/support/worldwide.aspx