>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 >>
TEXT to mSqlcommand noshow pretext 15 TEXTMERGE UPDATE MyView SET Field1 = nValue1, Field2 = <<.nSomeValueIHave>> WHERE code = nValue3 ENDTEXT &mSqlCommandBe sure to remove all semicolons in your code. The TEXTMERGE comment will replace
<<.nSomeValueIHave>>with the value of your form property.