On Thu, 2006-10-05 at 17:19 -0400, Adrian Maier wrote: > On 10/5/06, Joost van der Sluis <[EMAIL PROTECTED]> wrote: > > > 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? > The size is not important. I meant that i've configured postgres to > write in the log > all the queries that are executed, for debugging. Yet, the query > which generates > the error is not recognized as a query at all, and only the error > appears in the > log.
Can't you specify to log all the commands which are sent? > > 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. > > I'm afraid that i still don't understand how can I see those queries. > What/where > are the update.sql, modifyquery.sql that you are referring to? Seems that they aren't public. What you could do: compile the sqldb-unit with debuginfo and place a breakpoint on line 1181. And then take a look at qry.sql.text. Or simply place a 'writeln(qry.sql.text);' on that line. Recompile fpc and try again... Joost _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives