Hi!

I have the following code:
LSQL="select * from instruct where mainkey="+"'"+ALLTRIM(modacad.mainkey)+"'"
CREATE SQL VIEW workinst CONNECTION upsize ;
as LSQL
use workinst in 0 nodata
select workinst
=CursorSetProp("Buffering",3,"workinst")

Where I create a view and use it as the 'working' area on a form.

However when I append a blank and edit the line, or edit a line or delete a line I then do a...

tableupdate()

According to Microsoft the details about saving this should be done and ven though it's a view it should save my changes to the underlying table.

But it saves nothing...

What am I doing wrong...

I am use SQL server 6.5 (The connection upsize works fine).
And VFP 6.0

An aside question: I did the create view code above and One time only.
When I went to
append blank
"I got this feature is unavialable in demo version"

But I am not using the demo version!
Ever seen this????

Thanks ALL!