Syntax error in INSERT INTO statement. - Xtreme Visual Basic Talk

03-05-2005, 09:51 PM

bradac

Regular

Join Date: Sep 2001

Location: Mokane, MO

Posts: 98

Syntax error in INSERT INTO statement.

Sorry to bother everyone tonight but I'm just not seeing what I'm doing
wrong with this code. It's the 'cn.Execute's insert line. I've went so far
as removing my var's and hard coding the line with data but I'm still not
seeing what I'm doing wrong.

Can anyone help?

Code:

Sub DB_Creation()

Dim cn As ADODB.Connection
  
  Set cn = New ADODB.Connection
  dbfilename$ = frmMain.Combo1.Text & ".mdb"
  
  If Dir$(App.Path & "\" & dbfilename$) = "" Then Call CreateDataBase
  If Dir$(App.Path & "\" & dbfilename$) = dbfilename$ Then
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\" & dbfilename$
    cn.Execute "INSERT INTO AA3(Module, Game) VALUES('test1', 'test2')"
    cn.Close
  End If

End Sub

03-05-2005, 10:04 PM

Bart1123

Contributor

Join Date: Mar 2003

Location: Oklahoma City, OK

Posts: 455

Any chance that there is a data type mis-match between the DB and the data being inserted? I.e. Module is set to an integer but test1 is a string.

Just a late night thought. Hope this Helps

Bart

__________________
"I have not failed. I've just found 10,000 ways that won't work." - Thomas Alva Edison
Want a Gmail Account? Forum Members only please. Email me with your forum nick :)

03-05-2005, 10:33 PM

bradac

Regular

Join Date: Sep 2001

Location: Mokane, MO

Posts: 98

Thanks I didn't think of that.

I'm creating the DB and record field via code, how would I add the type suffixes manually? Your correct most of the fields should be strings.

- Brad

03-05-2005, 10:51 PM

webbone

Hydrogen Powered

Administrator
* Expert *

Join Date: Jul 2003

Location: Sacramento, CA

Posts: 6,090

One other thought - since Module might be a special word you might want to surround it with [ ]:

Code:

cn.Execute "INSERT INTO AA3([Module], Game) VALUES('test1', 'test2')"

__________________
"With the appearance of the AddressOf operator, an entire industry has developed among authors illustrating how to do previously impossible tasks using Visual Basic. Another industry is rapidly developing among consultants helping users who have gotten into trouble attempting these tasks." -Dan Appleman

03-05-2005, 10:55 PM

bradac

Regular

Join Date: Sep 2001

Location: Mokane, MO

Posts: 98

Quote:

Originally Posted by webbone

One other thought - since Module might be a special word you might want to surround it with [ ]:

Code:

cn.Execute "INSERT INTO AA3([Module], Game) VALUES('test1', 'test2')"

Duh! Thanks that it exactly!

- Brad