create table test (col1 blob)

insert into test values (x'01F2102B')

Error:

ElevateDB Error #700 An error was found in the statement at line 2 and
column 27 (Expected ) but instead found '01F2102B')

The following works:

insert into test values (X'01F2102B')

Ole

Ole,

<< create table test (col1 blob)

insert into test values (x'01F2102B')

Error:

ElevateDB Error #700 An error was found in the statement at line 2 and
column 27 (Expected ) but instead found '01F2102B')

The following works:

insert into test values (X'01F2102B') >>

EDB expects a capital 'X' currently.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<< EDB expects a capital 'X' currently. >>

I figured out that much

What I tried to say is that SQL text is case-insensitive, hence the parsing
error doesn't make any sense.

Ole Willy Tuv

Ole,

<< I figured out that much >>

Sorry, I was trying to say that it was intentional.  However, I went
back and looked at the implementation and I can't, for the life of me,
figure out why.  At any rate, it's fixed for 1.07.

--
Tim Young
Elevate Software
www.elevatesoft.com