Re: [sqlite] trim available ??

2007-04-16 Thread Stef Mientki
Dennis Cote wrote: Stef Mientki wrote: I don't know which version I'm running, how can I detect that ? Stef, You can call sqlite3_libversion (see http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details). Thanks Dennis, Yes, I see now, I've 3.3.8 ;-) cheers, Stef Mientki

Re: [sqlite] trim available ??

2007-04-16 Thread Stef Mientki
Liam Healy wrote: An option for versions that do not have trim is http://sqlite.org/contrib//download/extension-functions.tgz?get=17 thanks Liam, but I think it's better to recreate the database, with trimmed itesm. cheers, Stef

Re: [sqlite] trim available ??

2007-04-16 Thread Dennis Cote
Stef Mientki wrote: I don't know which version I'm running, how can I detect that ? Stef, You can call sqlite3_libversion (see http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details). HTH Dennis Cote

Re: [sqlite] trim available ??

2007-04-16 Thread Liam Healy
An option for versions that do not have trim is http://sqlite.org/contrib//download/extension-functions.tgz?get=17 On 4/16/07, Stef Mientki <[EMAIL PROTECTED]> wrote: > The TRIM function was added on 2007-03-17 17:52:42. > Thanks, that explains .. cheers, Stef > -- > D. Richard Hipp <[EMAIL

Re: [sqlite] trim available ??

2007-04-16 Thread Stef Mientki
The TRIM function was added on 2007-03-17 17:52:42. Thanks, that explains .. cheers, Stef -- D. Richard Hipp <[EMAIL PROTECTED]> Kamer van Koophandel - handelsregister 41055629 / Netherlands Chamber of Commerce - trade register 41055629

Re: [sqlite] trim available ??

2007-04-16 Thread drh
Stef Mientki <[EMAIL PROTECTED]> wrote: > Mohd Radzi Ibrahim wrote: > > Hi, > > I'm running 3.3.15. No problem at all. Maybe your version does not > > have this implemented yet... > > > > I use the SQLITE3.DLL dated 8 october 2006 The TRIM function was added on 2007-03-17 17:52:42. -- D.

Re: [sqlite] trim available ??

2007-04-16 Thread Stef Mientki
Mohd Radzi Ibrahim wrote: Hi, I'm running 3.3.15. No problem at all. Maybe your version does not have this implemented yet... I don't know which version I'm running, how can I detect that ? I use the SQLITE3.DLL dated 8 october 2006, but windows can't find the version info in that file.

Re: [sqlite] trim available ??

2007-04-16 Thread Mohd Radzi Ibrahim
Hi, I'm running 3.3.15. No problem at all. Maybe your version does not have this implemented yet... best regards, Radzi. - Original Message - From: "Stef Mientki" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, April 16, 2007 10:14 PM Subject: [

[sqlite] trim available ??

2007-04-16 Thread Stef Mientki
hello, As I read here http://www.sqlite.org/lang_expr.html there are trim functions availabel as part of an expression. But when I try to execute the next statement: SELECT App FROM PO WHERE LOWER(App_Type) = TRIM(LOWER('{ Afzuigapparaat } ')) I get the following error / ERROR