Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
<ColumnConstraintDefinition> problem |
Sun, Mar 29 2009 10:39 AM | Permanent Link |
"Lucian Radulescu" | Hi,
With ElevateDB Manager, I am trying to create a table with a column referencing a column in a different table, something like this: CREATE TABLE "B" ( "RecRef" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1), "ARef" INTEGER REFERENCES A(RecRef) ) I get this error: ElevateDB Error #700 An error was found in the statement at line 4 and column 28 (Expected PRIMARY, UNIQUE, FOREIGN, REFERENCES, CHECK but instead found () I have no idea what's wrong..? TIA, Lucian |
Thu, Apr 2 2009 11:37 AM | Permanent Link |
Fernando Dias Team Elevate | Lucian,
I couldn't see nothing wrong - it apears to be a bug. -- Fernando Dias [Team Elevate] |
Thu, Apr 2 2009 12:28 PM | Permanent Link |
"Lucian Radulescu" | Fernando Dias wrote:
> Lucian, > > I couldn't see nothing wrong - it apears to be a bug. Thanks, I thought it was a documentation problem. Lucian |
Thu, Apr 2 2009 3:13 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Lucian,
<< I get this error: ElevateDB Error #700 An error was found in the statement at line 4 and column 28 (Expected PRIMARY, UNIQUE, FOREIGN, REFERENCES, CHECK but instead found () >> It's definitely a bug. Sorry for the delay in getting back to you on this - I actually looked at it and fixed it already, but forgot to respond to you. The fix will be in 2.02 B11. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Apr 3 2009 8:25 PM | Permanent Link |
"Lucian Radulescu" | Tim Young [Elevate Software] wrote:
> Lucian, > > << I get this error: ElevateDB Error #700 An error was found in the > statement at line 4 and column 28 (Expected PRIMARY, UNIQUE, FOREIGN, > REFERENCES, CHECK but instead found () >> > > It's definitely a bug. Sorry for the delay in getting back to you on > this - I actually looked at it and fixed it already, but forgot to > respond to you. > > The fix will be in 2.02 B11. Thanks, glad it's fixed. No problem with the delay no rush here, just started with EDB, so... I'm catching up on things Lucian |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |