Re: [gnome-db] Oracle 8 and Sql

[Rodrigo Moya <rodrigo gnome-db org>]

On Thu, 2001-12-13 at 04:19, Jorge Cardoso wrote:
> 
> So i decide to add a simple sql query in gda-test.c after get the above 
> messages like this:
>   
>     GdaCommand * micomando;
>     GdaRecordset* mirecordset;
>     gulong recount;
>     gulong flag;
> 
>     ... 
>     ...
>     ..
>      ..
>      micomando = gda_command_new(); 
>      gda_command_set_connection (micomando,cnc);
>      gda_command_set_text (micomando,"select FECHA from S1ADB112 where 
>      indice=1");
>     
>     mirecordset= gda_command_execute(micomando,&recount,flags);
>     g_printf ( "Getting %d  entries \n " , recount ); 
> 
>     gda_command_free (micomando);	
>     g_print("\nclosing connection...\n", provider);
>     gda_connection_free(cnc);
>  
> The new gda-test.c compiled succefully.
>  But after run it get the following message:
> 
> 
> --------------------------------------
> gda-connection.c: 69: gda_connection_real_error called
>   Getting 134516457  entries 
> 
> ** WARNING **: Errors still associated with gda_connection
> 
>    closing connection...
> --------------------------------------
> 
> I have just two  or three records in this table.
> 
> What I ' m doing wrong 
> 
you're not doing anything wrong, it's just that some providers don't set
the reccount variable on the gda_command_execute. You shouldn't rely on
it, since in this case, Oracle does not do it.

For the GNOME 2 version, this will be fixed, I hope :-)

cheers
-- 
Rodrigo Moya <rodrigo gnome-db org> - <rodrigo ximian com>
http://www.gnome-db.org/ - http://www.ximian.com/