Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sql server record id

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-27 : 08:50:37
Dug writes "Interesting one!(probably only to me!)

I have an online/offline version of the same site. It uses asp
with sql server 2000 database. Both sites can update/delete
add new records, except the online version cannot add new records!
I know what the problem is but cant work out why it is nor how to fix it....The online page cannot insert a unique id..but why?
My offline version has no problem!!!

Please help before I take up a new career!
Dug (UK)"

andre
Constraint Violating Yak Guru

259 Posts

Posted - 2001-11-27 : 10:11:43
We'll need more information in order to help:
1) The data type of the primary key
2) The design of the table(PK, FK, indexes...)
3) The stored procedure or SQL insert statement that is giving the error



Edited by - andre on 11/27/2001 10:12:03
Go to Top of Page
   

- Advertisement -