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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2004-03-25 : 07:56:58
|
K writes "I have a table (in MS access) that has only ever got one record. I need this table in database so that C++ program can access details (through VB6 program). However when I delete the record in order to replace it by using a delete query the instance of the record rather than the values is deleted. How can I delete and replace, and then save the new values (or null values) in the database, without deleting the record?Thank you.K." |
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2004-03-25 : 08:36:14
|
If I understand this right, what about using UPDATE rather than some DELETE?--Frankhttp://www.insidesql.de |
 |
|
|
|
|