Check this out

Create a free table - table1
with two fields - groupid, group
where groupid is the primary key.

Create a view to this table - view1
where the update criteria is on groupid. check Send SQL updates.

Now create a form with a single textbox and set the dataenvironment to view1.
Then add the following code snippets

-----------------------
* Begin form1.init()
* Set buffering to optimistic, row buffering.
cursorsetprop("Buffering", 3)
* End form1.init()

-----------------------
* Begin text1.init()
this.value = view1.group

RETURN( .t. )
* End text1.init()

-----------------------
* Begin form1.unload()
tablerevert()
* End form1.unload()


For some reason the command - this.value = view1.group - causes a syntax error. I found that if I chose any SQL command for the field name I got the error. But if you change the field name to anyother name this command works fine.

Any thoughts?