GDA Missing records in SQLite

Mark Johnson mrj001 at shaw.ca
Thu Feb 21 09:34:11 EST 2008


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



More information about the gnucash-devel mailing list