>I'm trying to form an INSERT INTO string and run it:
>
>

>sSqlCommand = "insert into syserrors "+;
>  "(datetime, error, line, message, codeline, program," +;
>  "user, appname, memory, status, callstack, notified)"+;
>  " values "+;
>  "("+ sDateTime + "," +;
>  sErrNo + "," +;
>  sLineNo + "," +;
>  "'" + sErrMessage + "' ," +;
>  "'" + sLineOfCode + "' ," +;
>  "'" + sProgram + "' ," +;
>  "'" + sUserId + "' ," +;
>  "'" + sAppName + "' ," +;
>  "'" + sMemory + "' ," +;
>  "'" + sStatus + "' ," +;
>  "'" + sStack + "' ," +;
>"0)"
>

>
>After running this the string looks like:
>
>

>insert into syserrors (datetime, error, line, message, codeline, program, user, appname,
>memory, status, callstack, notified)
>values
>(10/31/2005 07:40:27,1000,5000,'TEST MESSAGE' ,'TEST CODE LINE' ,'TEST PROGRAM' ,'KMAROIS'
>,'TEST' ,'' ,'' ,'TEST STACK' ,0)
>

>
>
>SQL Server is returning the error "Incorrect syntax near '07'.
>
>Notice the DateTime value. It seems to be appearing as a string. Anyone know how
>to solve this?

Use parametric strings.

text to m.sSqlCommand noshow
insert into syserrors 
  (datetime, error, line, message, codeline, program,  
  user, appname, memory, status, callstack, notified)
   values 
  (?m.sDateTime,?m.sErrNo ,?m.sLineNo, ?m.sErrMessage,... )
endtext

sDatetime = {^2005/10/31 07:40:27}
sErrno = 1000
sLineNo = 5000
...

SQLExec(m.lnHandle, m.sSQLCommand)

Cetin