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

[Benoit Minisini]

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,

-- 
Benoit Minisini