Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
Binary literal - parsing problem |
Thu, Dec 27 2007 12:18 PM | Permanent Link |
"Ole Willy Tuv" | 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 |
Thu, Dec 27 2007 3:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Dec 27 2007 7:39 PM | Permanent Link |
"Ole Willy Tuv" | 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 |
Fri, Dec 28 2007 2:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Friday, May 3, 2024 at 08:07 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |