Hi,

I'm having a hard time with my SQL insert statement that I am using in ASP.NET. I need to insert a record into a VFP free table. I can insert values as long as the field is a character field. I can not insert a logical, numerical, or DateTime because my SQL String converts all data to a character. My Sql string is below: Does anyone have any ideas on how I can fix this? Thank you.

Tim

Dim sb As New StringBuilder
sb.Append("INSERT INTO testdb (Job_num, Slot, Date, Number ) Values( '")
sb.Append("JN43")
sb.Append("','")
sb.Append("01"))
sb.Append("','")
sb.Append(DateTime.Now)
sb.Append("','")
sb.Append(204)
sb.Append("')")
myInsertString = sb.ToString()