Tim

"_ID" INTEGER GENERATED BY DEFAULT AS  NOT NULL,

generates an error #700

_ID is also used as the primary key

Roy Lambert

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

Tim


Yes - no way am I up to speed yet <vbg>

Roy Lambert

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

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

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