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
 Other Forums
 MS Access
 VB6 using SQL to save record in database

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?



--Frank
http://www.insidesql.de
Go to Top of Page
   

- Advertisement -