` Use Identity column in MS SQL (Jim Kane) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

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 > >

Today is November 21, 2024, 3:49 am
This article has been viewed 35232 times.
Google search has resulted in 408 hits on this article since January 25, 2004.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription