[Gambas-user] anybody have a parser

[johnf]

On Tuesday 14 February 2006 23:21, Rob Kudla wrote:
> On Wed February 15 2006 02:05, johnf wrote:
> > Will aVariant contain the response from the database engine?
> > Something like "Query returned successfully: 1 rows affected,
> > 36 ms execution time."
>
> I think that string is something generated by the query software
> itself, and all the database returns is the number of rows
> affected... but the result of Connection.Exec is a Result object
> (i.e. a recordset) if anything's returned at all.
>
> Maybe Result.Count returns the number of rows affected in an
> insert/update operation?  I've never tried that.
>
> Rob
I wish result.count returned the string.  But it is = 0.  At the moment I'm 
having trouble with the connection.exec("update set field = 'string' where 
field = 'string' ") not respecting my "where" clause.  Any thoughts?
John