\r\n in a string not accepted on database

Question

I create a string variable for an Update SQL command in order to execute this command to a dbf file ( with OleDb).

When my SQL Command contain in a string \r\n the SqlCommand is not accepted :(

Here is an example of my SQL Command :

update ZZAg7eve set evenotes = 'line1\r\nline2' where eveNum = '00000003'

I know that the problem is \r\n. I tried to use a verbatim, but there is always the same error : "Command contains unreconized phrase/keywords".

cause if i remove it, the SQL command is executed whitout any problems — Walter Fabio Simoni, Apr 02 '13 at 19:06

score 1 · Answer 1 · answered Apr 02 '13 at 21:28

1

In VFP, you use CHR(13) + CHR(10) to indicate CRLF. So try:

update ZZAg7eve set evenotes = 'line1' + chr(13) + chr(10) + 'line2' where eveNum = '00000003'

answered Apr 02 '13 at 21:28

Tamar E. Granor

1 Answers1