SQL

  • Thread starter Thread starter Paul Mars
  • Start date Start date
P

Paul Mars

I think it is my SQL code that is causing the failure here. I receive "An
unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in
system.data.dll" on the second to last line below. What's wrong?

conUserInfo.Open()

Dim cmdAdd As OleDb.OleDbCommand = New OleDb.OleDbCommand


cmdAdd.CommandText = "INSERT UserGame VALUES " & strUserID & ", " &
strPassword & ", " & strAge & ", " & strGender & ", " & blnSound & ", " &
blnSoundAsLast & ", " & decGameSize & ", " & blnSizeAsLast & ", " &
strImagePlacement & ", " & blnImagePlacementAsLast & ""

also tried

cmdAdd.CommandText = "INSERT UserGame VALUES '" & strUserID & "', '" &
strPassword & "', '" & strAge & "', '" & strGender & "', " & blnSound & ", "
& blnSoundAsLast & ", " & decGameSize & ", " & blnSizeAsLast & ", '" &
strImagePlacement & "', " & blnImagePlacementAsLast & ""

also tried other variations

cmdAdd.Connection = conUserInfo

cmdAdd.ExecuteNonQuery()

conUserInfo.Close()
 
Don't quote me but I think "VALUES" must have brackets, ie.

INSERT INTO This VALUES (that1, that2, that3, that4)
 
Paul Mars said:
I think it is my SQL code that is causing the failure here. I receive
"An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll" on the second to last line below. What's
wrong?
Click to expand...

No solution but some hints:
- use Try/Catch block to catch and examine the exception
- use Parameters wherever possible (cmdAdd.Parameters)
- There's a group for ADO.Net questions:
microsoft.public.dotnet.framework.adonet


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html
 
Thank you Robin. I have been stuck for days on this. I had tried the
brackets before. What I was missing was "INTO". Now it works and I m so very
happy. !!!

thanks again !

Paul
 
Paul said:
I think it is my SQL code that is causing the failure here. I receive "An
unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in
system.data.dll" on the second to last line below. What's wrong?
Click to expand...

to know wats wrong use:

try
...
code
...
catch myODBCexception as odbcexception
console.writeline myodbcexception.message
end try
 
Back
Top