>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();