>I do an update with set
>
>

>UPDATE MyView ;
>	SET ;
>		Field1 = nValue1, ;
>		Field2 = .nSomeValueIHave ;
>	WHERE code = nValue3
>
>this gives an error even if there is a WITH in the beginning of that procedure
>
>
>UPDATE MyView ;
>	SET ;
>		Field1 = nValue1, ;
>		Field2 = thisform.nSomeValueIHave ;
>	WHERE code = nValue3
>
>doesn't give an error
>

>
>What's wrong here?



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