>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