Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 6 of 6 total |
Error 700 |
Fri, Jan 26 2007 12:17 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
"_ID" INTEGER GENERATED BY DEFAULT AS NOT NULL, generates an error #700 _ID is also used as the primary key Roy Lambert |
Fri, Jan 26 2007 1:56 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< "_ID" INTEGER GENERATED BY DEFAULT AS NOT NULL, generates an error #700 _ID is also used as the primary key >> This is normal - the above syntax is not correct. Did the SQL above get generated by the EDB manager ? -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jan 26 2007 2:01 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Yes - no way am I up to speed yet <vbg> Roy Lambert |
Fri, Jan 26 2007 2:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Yes - no way am I up to speed yet <vbg> >> How did you define the column ? Did you try to define it as a generated identity column ? -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Jan 27 2007 4:03 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>How did you define the column ? Did you try to define it as a generated >identity column ? Since I have no idea what you're asking all I can say is I checked generated, unchecked nullable, and I think I clicked on generate as identity on the generation page cos I had no idea what I was doing (did you know you can teach an old dog new tricks but it doesn't half make his brain hurt) How should I have set it up? From your question I'm guessing I should have used an expression, but what? Roy Lambert |
Sat, Jan 27 2007 11:06 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Since I have no idea what you're asking all I can say is I checked generated, unchecked nullable, and I think I clicked on generate as identity on the generation page cos I had no idea what I was doing (did you know you can teach an old dog new tricks but it doesn't half make his brain hurt) >> Okay, I figured out what the issue was. You must have checked the Generated check box and left the Generated as Expression memo blank. I've added a check for this in the table dialog now so that you can't do that. << How should I have set it up? From your question I'm guessing I should have used an expression, but what? >> It's up to you - a generated column uses an expression to populate itself. If you wanted an identity (autoinc) column instead, then you needed to check the Generate as Identity radio button instead of the Generate as Expression radio button. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |