Graham Menhennitt wrote: > Mark Johnson wrote: > >> PostgreSQL gives a warning for '', but accepts it; it prefers \'. MySql >> takes the ''; I'm not sure about \'. Obviously SQLite won't take the \'. >> >> However, the real problem is that it is not gnucash-gda code which is >> doing the escaping of the single quote. It is libgda, probably the >> SQLite provider. Therefore not under this project's control. >> >> > Guys, this isn't the right way to do it. When using SQL, you should > never have to worry about quoting because you shouldn't build SQL > statements like that. Use a prepared statement and bind the values to > numbered or named parameters in the SQL. All the relevant providers > allow it. GDA allows it. Now there may be bugs in GDA - I don't know. > But at least try to get it to work before worrying about workarounds > like this. > > Graham > > I wasn't suggesting a workaround; merely illustrating differences between DBs. As soon as I get time, I am going to make a trial project for purposes of a possible bug report to the libgda project. That's my first option before any workaround.
Mark _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel