Sql Server 6 & Identity columns 
Author Message
 Sql Server 6 & Identity columns

My apologies if this has been asked before.

db grids and a table that uses an identity column
When a sql select returns no records to the grid (not
  because the table is empty, but the result set for this key is empty)
and a user inserts a record - Two appear in the grid!

One assumes that the first is the one without an identity and the second
is the one with the identity.  Requerying the server makes this "shadow"
go away and it will not happen again for this key.  All following inserts
are "singles" and not doubles.  I killed off the effect with icky code
but was wondering what the suggested approach would be?

Mon, 22 Feb 1999 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. VB 4.0 & SQL Server 6.5 (Identity Column)

2. :Identity column (SQL 6.5) & Index (Access)

3. how to alter an identity column to a non-identity column

4. How to change an identity column to non identity column

5. How do make an identity column NOT an identity column

6. Reset Identity Column (SQL Server 6.5)

7. Run time error 3622: OpenRecordSet: SQL server table: IDENTITY column

8. Problems with identity columns in SQL Server 6.5

9. Identity Column - Sql Server 7.0

10. Programatically drop IDENTITY column in SQL Server?

11. SQL Server Identity column contains zero every time

12. Reset Identity Column in SQL Server table with VB

Powered by phpBB® Forum Software