help requested figuring out error

[Dave Parizek]

I am converting a V4RB 1.x project to 2.0.

When I try to execute the following code (in 2.0):

   Binds.append App.timestamp
   Binds.append vLogEntry

   stmt = "INSERT INTO Log (Timestamp, LogEntry) VALUES (:1, :2)"
   numAffectedRows = app.mDatabase.SQLExecute(stmt, Binds)


I get a VException:

error info from end of V4RB_Log.txt file:

	Database_SqlExecute_2...
		PARAM: inQuery = "INSERT INTO Log (Timestamp, 
LogEntry) VALUES (:1, :2)"
	ERROR: 0x71000 line 1:1: unexpected token: (

	return (int) AffectedRecords = 0

error number was 462848



The variables' values at time of exception:

	vLogEntry: New database created at SleepNIn:Jane:JaneDB.vdb
	stmt: INSERT INTO Log (Timestamp, LogEntry) VALUES (:1, :2)
	Binds(0): 2/11/2005 11:31:8
	Binds(1): New database created at SleepNIn:Jane:JaneDB.vdb


Any idea what is wrong?

--Dave

-- 

_______________________________________________
Dave Parizek
Dave at RemainderZ.com

"Outside of a dog, a book is a man's best friend.
Inside a dog, it's too dark to read."
                  -- Groucho Marx