Update statement

[reysy28]

Hello guys,

What seems to be the syntax error on this command.... It says Syntax error in strSql = ........

Private Sub Command6_Click()

Dim cn As ADODB.Connection

'Purpose: Create a new query using ADO.
Dim strSql As String
Set cn = CurrentProject.Connection

strSql = "Update into EnglishAppAnswers( AppAnswer ) VALUES( CStr(Form_SubForm_exam.Ans1.Value) );"
cn.Execute strSql

DoCmd.GoToRecord , , acNext

End Sub


Thanks.....

 

[JHB]

Hello guys,

What seems to be the syntax error on this command.... It says Syntax error in strSql = ........

It is the "Update into".
You can insert data with "Insert into", but not "Update into"!

 

[jdraw]

Into is the issue
For syntax and example see http://www.w3schools.com/sql/sql_update.asp

http://www.w3schools.com/sql/sql_insert.asp

 

[spikepl]

Break the preocess down into steps - follow the recipe from here: http://www.baldyweb.com/immediatewindow.htm