SQL Related Articles: Use Identity column in MS SQL
2003-06-14 -- Jim Kane
Newsgroups: softvelocity.products.c55ee
in the dictionary, for the auto numbered field, in the external name entry
put 'fieldname | READONLY'
Then the driver will not try to write to that field. dont use
indentity_insert.
Jim Kane
"Edvard Korsbæk" wrote in message
news:3eeab7d9$1@news.softvelocity.com...
> Hi All!
>
> Perhaps a bit off topic, but anyway..
>
> When i make MSSQL apps i use a long autonumber (INT in MSSQL) as primary
> field. Best way to do it is to let the backend make the autoincrement with
> identity, seed =1 and increment =1. Only problem is, that my MSSQL server
> invariably retuns the attached error message exept in one app, and i do
not
> remember what i did there.
> The error message is 'Cannot insert explicit value for identity coloumn in
> table 'Tablename' when IDENTITY_INSERT is set to OFF (23000) when i try to
> update via a form (Wizard generated or not) from Clarion 5.5H.
>
> Please help, as this simply stops me from using SQL
>
> --
> Best regards
>
> Edvard Korsbæk
> +4570229998
>
>
Printed May 4, 2024, 5:11 pm
This article has been viewed/printed 35120 times.
Google search
has resulted in 408 hits on this article since January 25, 2004.