Hi The next code generate error in adding to foxpro database alose it works fine in Access and sql server, i discovered that the problem is in the chr(10) [chr(0) & chr(39) do the same error] , is there any help to solve this:
Notes: I need chr(10 , 0 or 39) in the output string
dim st as string
st="Test1" & chr(10) & "Test2"
S = "insert into [table1] (Field1,Field2) Values (1 , ' " & st & " ')"
Thanx a lot