> I'm using Sqldb to access a PostgreSQL database. Is it possible to find out
> easily what sql commands is sqldb generating and trying to execute ?
>
> I have a DBgrid which is associated to a table.
> After updating a row and executing query.ApplyUpdates , the program generates
> an exception :
> "An error occurred while applying the updates in a query: preparation of query
> failed. (PostgreSQL: ERROR: syntax error at end of input at character 132). "
>
> Enabling the statement logging in postgres doesn't help in this case,
> because the
> sql command is not recognised at all, and therefore it doesn't show
> up in the log.
?
It's more then 132 characters long, so it should be in the log?
Since it's with applyupdates. The SQL is probably parsed incorrectly.
You can look what the updatequery.sql, modifyquery.sql etc. are. Maybe
that that already reviels the problem.
Joost
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
