CLOSE DATABASES ALL CREATE DATABASE Test OPEN DATABASE Test SET DATABASE TO Test CREATE TABLE tTest (Bla C(10)) FOR asd = 1 TO 50 INSERT INTO tTest VALUES (STR(asd)) NEXT ALTER TABLE tTest ADD PRIMARY KEY Bla TAG Bla CREATE SQL VIEW vTest AS SELECT Bla FROM tTest DBSetProp("vTest","View","SendUpdates",.T.) DBSetProp("vTest","View","BatchUpdateCount",1) DBSetProp("vTest","View","CompareMemo",.T.) DBSetProp("vTest","View","FetchAsNeeded",.F.) DBSetProp("vTest","View","FetchMemo",.T.) DBSetProp("vTest","View","FetchSize",-1) DBSetProp("vTest","View","MaxRecords",-1) DBSetProp("vTest","View","Prepared",.F.) DBSetProp("vTest","View","UpdateType",1) DBSetProp("vTest","View","UseMemoSize",255) DBSetProp("vTest","View","Tables","eltest!results") DBSetProp("vTest","View","WhereType",3) DBSetProp("vTest.Bla","Field","DataType","C(10)") DBSetProp("vTest.Bla","Field","UpdateName","Test!tTest.Bla") DBSetProp("vTest.Bla","Field","KeyField",.T.) DBSetProp("vTest.Bla","Field","Updatable",.T.) CLOSE DATABASES ALL whatBla = STR(25) USE Test!vTest BROWSE CURSORSETPROP("Buffering",5,'vTest') lcAlias = "vTest" UPDATE (lcAlias) SET Bla = STR(55) WHERE vTest.Bla = m.whatBla GO 25 ? TABLEUPDATE(1,.t.,lcAlias) whatBla = STR(55) UPDATE (lcAlias) SET Bla = STR(12) WHERE vTest.Bla = m.whatBla GO 25 BROWSE CLOSE DATABASES ALL