First, thanks everyone.

I now have:

PROCEDURE HandleError(sAppName AS String, iErrNo AS Integer,;
                      sErrMessage AS String, sLineOfCode AS String,;
	              sProgram AS String, iLineNo AS int, sStack AS String)

TEXT TO sSqlCommand NOSHOW

  insert into syserrors 
  (datetime, error, line, message, codeline, program,  
  [user], appname, memory, status, callstack)
  values 
  (?tDateTime, ?iErrNo , ?iLineNo, ?sErrMessage, ?sLineOfCode, ?sProgram,
   ?sUserId, ?sAppName, ?sMemory, ?sStatus, ?sStack)

ENDTEXT

And I'm getting prompted for values passed in as parameters








>>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