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

[johnf]

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