Insert SQL and RecordSets 1

[seema165]

Hi,

I have an error in my code which says:

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ':'.
At line 69.

Here's the code:

strInsertSQL = "INSERT INTO Navigation (UserName, SystemTime, InitialProcess, OpportunityGUID, ActivityGUID) "
strInsertSQL = strInsertSQL & "VALUES (" & userID & ", " & time() & ", " & "TEST" & ", " & "Blank" & ", " & strActivityID & ")"

objRS= objConn.Execute(strInsertSQL)

line 69 of my code is the last line above where it executes the sql. The connection I have used is:

Const ODBCConnection = "Driver={SQL Server};Server=AGGTEX;Database=Rental;Uid=xxx;Pwd=xxx;"

I know the connection works as I have successfully managed to do a select statement using the same database.

Please could somebody help as I have been working on this for a while.

Thanks in advance

 

[FesterSXS]

your SQL code needs to have the appropriate quotes around the values you are inserting.

for exmple:

INSERT INTO myTable (numberField, stringField, dateField) VALUES (546, 'myString', '19/08/2005')

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[seema165]

Cheers Tony!

I always forget to add the obvious things to my code! ;-)


Thanks for all your help today