General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
SQL - UPDATE Command problem
I had a problem in while updating two tables like Master & Transaction in SQL Server 7.0 throgh ODBC using VB6.
I used the command as appended below:
Dim MyDb As Object
Dim SqlString1, SqlString2 As String
Set MyDb = OpenDatabase("", dbDriverNoPrompt, False, "ODBC; DSN=SQL; UID=User; PWD=Password")
SqlString1 = "UPDATE Master SET = 'Newvalues' WHERE nId = IdValue"
SqlString2 = "UPDATE Trans SET = 'Newvalues' WHERE nID = IdValue"
MyDb.Execute SqlString1
MyDb.Execute SqlString1
When Execute the SqlString, the following error message appeared
'3073 - Operation must be use an updatable Query'
Please help me, Thanks in advance.
Regards,
Ragu.
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only