Rowset painful transition from RecordSet

Databases
1

recSet = dbJHGCGC.SQLSelect( "SELECT * FROM tblEventTracker WHERE eventName=?" cboEventName.Value )

I keep getting syntax error on this line…

Actually I am getting 2 errors on this code below:
Try
recSet = dbJHGCGC.SQLSelect( “SELECT * FROM tblEventTracker WHERE eventName=” cboEventName.Value )

  If recSet <> Nil Then
For Each row As DatabaseRow In recSet
  Try
    recSet.EditRow
    recSet.Column( "archEvent" ).StringValue = "A"
    
  Catch
    MessageBox( "Oh crap! UPDATE didn't update... Call Ian!!!" )
  End Try
Next
recSet.Close
  End If
Catch error As DatabaseException
  MessageBox("Error: " + error.Message)
End Try

First is frmEventTracker.btnArchive.Action, line 18
Syntax error
recSet = dbJHGCGC.SQLSelect( “SELECT * FROM tblEventTracker WHERE eventName=” cboEventName.Value )

Then frmEventTracker.btnArchive.Action, line 34
Syntax error
End Try

2

Comma before the cboEventName.value?

recSet = dbJHGCGC.SQLSelect( "SELECT * FROM tblEventTracker WHERE eventName=?", cboEventName.Value )
3

If I do that then I get an error stating I am passing too many arguments…

4

Make sure you dont have magic quotes around your strings

Select( “SELECT

This quote is a magic one, delete it and add again. You copied it from external source so have to be careful about those, same with the ending one. Then put your comma back in.

5

You’re mixing API 1 and API2. Try using:

SelectSQL (...

instead of:

SQLSelect (...

and you do need the comma.

6

Thank you, that was it SelectSQL with the comma

But when I run the code I get an error: “incomplete input”

7

Nevermind… I found a way to make it work spiffy!