Re: [gnome-db] SQL Query Types

[Chris Silles <cas starfire-programming net>]

On Saturday 23 August 2003 23:47, Rodrigo Moya wrote:
> On Sun, 2003-08-24 at 00:43 +0200, Danilo Schoeneberg wrote:
> > if (number_of_columns==0) {
> >   /* non-query insert,update,delete or similar */
> > } else {
> >   /* select-like query */
> > }
> >
> > is that correct ?
>
> yes, and if some provider does not do that, it's a bug.

Well, the MySQL provider certainly doesn't do this, nor does mSql, Oracle or 
PostgreSQL from what i can tell (infact pgSQL doesn't appear to even have a 
function to return the number of columns?) [As an additional question, the 
Oracle routines 'gda_oracle_recordset_get_n_columns' and 
'gda_oracle_recordset_get_n_rows' is set to bail out with 0, where as the 
other providers do so with -1, should this be changed accordingly?]

Could be wrong though, it is rather late after all...