>Hi,
>
>I'm new to using VFP with SQL Server and I have a question about inserting records into a SQL Server database.
>
>I am using the SQLEXEC command to do inserts right now. So far, the only fields I've updated have been character fields. The way I'm doing this is creating a string named 'strSQL' and building the insert command - then running SQLEXEC to insert the record.
>
>For example:

>lcText = "One"
>lcText1 = "Two"
>
>strSQL = "Insert into tblTest(cText1, cText2) Values( "
>strSQL = strSQL + "'" + (lcText) + "', "
>strSQL = strSQL + "'" + (lcText1) + "'" + ")"

>lcSuccess  = SQLEXEC(gnSQLSwitchParsingConn,strSQL)

>Now, I want to do the same thing with datetime and numeric fields. How would I handle inserting records with those data types using SQLEXEC?

The datetime value in SQL Server is represented by a character string.

...
strSQL = strSQL + Transform(lnNumber) + ", "
strSQL = strSQL + "'" + DTOC(ldDate) + "', "
strSQL = strSQL + "'" + TTOC(ltDatetime) + "', "
...