>>>
>>>
>>>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>>}

When it comes to this, it is probably easier to simply not use WITH...ENDWITH -- then you don't have to worry about the types of the values.