[Gambas-user] Is there a limit to exec string

[Benoit Minisini]

On Wednesday 15 February 2006 21:48, johnf wrote:
> On Wednesday 15 February 2006 12:26, Benoit Minisini wrote:
> > On Wednesday 15 February 2006 21:21, johnf wrote:
> > > On Wednesday 15 February 2006 12:00, Benoit Minisini wrote:
> > > > On Wednesday 15 February 2006 20:52, johnf wrote:
> > > > > On Wednesday 15 February 2006 08:25, Rob Kudla wrote:
> > > > > > On Wed February 15 2006 03:01, johnf wrote:
> > > > > > > Is there a limit to the length of the string that a
> > > > > > > connection.exec(string) can accept?  Does it truncate?  When I
> > > > > > > pass a string with a length of 370 chars I think it is
> > > > > > > truncating the string.
> > > > > >
> > > > > > 370 characters is way too short to be truncating a SQL query....
> > > > > > I've written MySQL queries that were like 4K.  (Don't ask, it
> > > > > > was ugly.)
> > > > > >
> > > > > > Does Postgres maybe have some logging facility so you can see
> > > > > > what queries have been run?
> > > > > >
> > > > > > Rob
> > > > >
> > > > > It took a while but I figured out how to turn on the logging.  So
> > > > > the postgres database engine sees everything but the "where" clause
> > > > > then I discovered I wasn't actually sending the "where" clause. 
> > > > > Thanks for everyones help.  So the programmer bites it again.... 
> > > > > Still I did learn that Gambas does not have anyway to see the
> > > > > return messages. John
> > > >
> > > > To see the queries sent to the database server, set DB.Debug to TRUE.
> > > >
> > > > Regards,
> > >
> > > It is true that if I had DB.Debug = true I might have seen the fact I
> > > was not sending the "where" clause.  But does DB.Debug report any
> > > messages from database engine?  Is there a way to read the return
> > > messages? John
> >
> > If the database engine returns an error, the error string is added to the
> > gambas error message.
> >
> > Regards,
>
> I sort of knew that but I was hoping for something that told me how many
> records were effected, etc...  Thanks
> John
>

Number of affected records ? This is in the TODO list :-)

-- 
Benoit Minisini