>>
>>
>>Try this

TEXT to mSqlcommand noshow pretext 15 TEXTMERGE
>>UPDATE MyView
>>	SET
>>		Field1 = nValue1, 
>>		Field2 = <<.nSomeValueIHave>> 
>>	WHERE code = nValue3
>>ENDTEXT
>>&mSqlCommand

>>
>>Be sure to remove all semicolons in your code. The TEXTMERGE comment will replace

<<.nSomeValueIHave>>

with the value of your form property.
>>HTH
>
>Works OK in the given example with numeric values (assumed by the "n" prefix), but doesn't work in case of character or date.

Sorry, forgot that part.
If you have a char value use

"<<.nSomeValueIHave>>"

If you have a date value use

{<<.nSomeValueIHave>>}