>Hi Cetin...
>
>My mistake.. I was looking at the wrong example. You code works perfactly. The following code causes an error with a ? mark in the description fields.
>
>
>

>lcSQL = "UPDATE so_b SET " +;
>	    "itm_numb = [" + so_b.itm_numb + "], " +;
>	    "itm_desc = [" + so_b.itm_desc + "], " +;
>         "WHERE iid_numb = " + TRANSFORM(liIid_numb)
>	=SQLEXEC(gnC, lcSQL)
>

>
>Thanks AGain
>Raz

Raza,
Check my sample again. It doesn't use transform() or any other hardcoding as you did. Instead it uses parameters. If you don't use parameters be prepared for a number of headaches (and you'd be lucky if you all get is syntax error).

lcSQL = "UPDATE so_b SET " +;
	    "itm_numb = ?so_b.itm_numb," +;
	    "itm_desc = ?so_b.itm_desc" +;
         "  WHERE iid_numb = ?m.liIid_numb"
	=SQLEXEC(m.gnC, m.lcSQL)

Also check:
Re: How to use ? in variables for UPDATE/INSERT statements? Thread #1235643 Message #1235960
Cetin