Jens
One possibility would be to use the TEXT("0002") expression. That might
work, but it's non-standard syntax.
Pete
----- Original Message -----
From: Jens Panse <jens.panse@EasternGraphics.com>
Date: Monday, February 12, 2001 1:23 pm
Subject: InstantDB: integer or char() error
> We have to handle different kinds of article numbers
> (string/char), that
> may consist of numbers starting with 0.
> But using the following statement (simplified) always leads to
> trouble.
> "SELECT '00002' FROM test" and you will receive "2" not "00002"
>
> This seems to be of the same kind as "SELECT lower("00002") FROM test
>
> AWT-EventQueue-0 java.sql.SQLException: LOWER requires a single
> string parameter
> java.sql.SQLException: LOWER requires a single string parameter
>
>
> The string "00002" is never interpreted as a string (or char), how can
> one force it to be a string ?
>
> Jens Panse
>
>
>
> --
> -[ ]-/\-( )---------------------------------------EasternGraphics--
> -----
>
> Jens Panse
>
> http://www.EasternGraphics.com
> phone: 03677 678267
> private: jens.panse@gmx.de
>
>
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the
> body of the email.
> If you have other questions regarding this mailing list, send
> email to
> the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|