Allan,
Do yourself a favor and use the "[" and "]" delimiters as you build your strSQL. For numbers, just don't use quotes. For dates, different SQL databases use different methods. One way is to just pass in a VFP date value. Another is to use "DATE(yyyy, mm, dd)".
lcText = "One"
lcText1 = "Two"
lcNumber = "123.456"
ldDate = {^2001/12/31}
lcDate = [DATE(] + ;
TRANSFORM(YEAR(ldDate)) + [, ] + ;
TRANSFORM(MONTH(ldDate)) + [, ] + ;
TRANSFORM(DAY(ldDate)) + [) ]
strSQL =
[Insert into tblTest(cText1, cText2, nNumber, dDate1, dDate2) ] + ;
[Values( ] + ;
['] + (lcText) + [', ] + ;
['] + (lcText1) + [', ] + ;
lcNumber + [, ] + ;
ldDate + [, ] + lcDate + [)]
>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?