>>Hello all,
>>
>>I have a problem updating a VFP table from C# code, whenever i try to pass text from a multiline textbox to a VFP memo field.
>>
>>When i execute the following code:
>>
>>_comando.CommandType = CommandType.Text;
>>_comando.Connection = _connection;
>>_comando.CommandText = _text;
>>_comando.ExecuteNonQuery();
>>
>>where _text = "update _table set datamov = {^2007/05/12}, horai = '08:00' nao_conf = 'line1 line2', normas = 'line 1' where numero = 125 and nitem = 1"
>>
>>At _comando.ExecuteNonQuery() i got this error: "Command contains unrecognized phrase/keyword."
>>
>>The problem is in the sentence "nao_conf = 'line1 line2'", if i go back to the multiline textbox and delete de 2nd line the error does not happens.
>>
>>The VFP table field 'normas' is also a memo field, filled with data from a multiline textbox, but as i put only a line of text, i got no error. If i put 2 or more lines i would get the same error.
>>
>>If i go to a VFP command line and execute this code i get no error, is obvious. The problem is at the way C# builds the string or in the VfpOleDb.
>>
>>Does anybody knows why? And how to solve this?
>>
>>TIA,
>>Joaquim
>>Joaquim
>
>Pete is right with the embeded carriage return, line feed causing the problem. One solution is to pass the values using a parameterized update. Here is an example for updating a vfp table.
>
>OleDbConnection conn = _Connection_;
>OleDbCommand Cmd = new OleDbCommand();
>Cmd.Connection = conn;
>Cmd.Parameters.Add("HEADER", OleDbType.Char);
>Cmd.Parameters.Add("TEXT", OleDbType.VarChar);
>Cmd.Parameters.Add("ID", OleDbType.VarChar);
>Cmd.Parameters["HEADER"].Value = ps_header;
>Cmd.Parameters["TEXT"].Value = ps_text;
>Cmd.Parameters["ID"].Value = ps_id;
>sql = "UPDATE calhead SET HEADER = ?, TEXT = ? WHERE ID = ?";
>Cmd.CommandText = sql;
>Cmd.ExecuteNonQuery();

Thank you Michael,

I've solved the problem creating a method that replaces the '\r\n' string with 'chr(13)+chr(10)', but think your solution is better.

Joaquim