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.
| Author |
Topic |
|
zamaan
Starting Member
19 Posts |
 Posted - 2006-01-01 : 03:18:37
|
| Hello i am new to MS SQL. Just moved in from MS Access.I used to program in VB6.mY Question is when i attemp to delete a record the followin error message displays"Key column information is insufficiant or incorrect.Too many rows were affected by the update."I have put the as code for the 'DELETE Record' command button in VB6 as follows.adomain.Recordset.Delete adAffectCurrentPlease help me to safley delete a record from the SQL database using VB6. |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-04 : 10:54:10
|
| HiPlease give us more infoIf you want your computer to be faster then throw it out of the window. |
 |
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-01-04 : 13:39:53
|
| Does the table have a primary key , it seems like you dont ... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-04 : 23:55:02
|
| There may be duplicate rows as your table doesnt have Primary keyMadhivananFailing to plan is Planning to fail |
|
|
|
zamaan
Starting Member
19 Posts |
Posted - 2006-01-05 : 11:14:42
|
| Thanks every body.Yes. it seems the problem with the Primary key. Actually i did not have a primary key. Now the problem seems disapeared.Going wellzamaan |
|
|
|
|
|
|
Cant delete a record