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
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
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
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
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
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.
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.
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: [
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
9 matches
Mail list logo