General information
Category:
Coding, syntax & commands
Title:
Updating, Saving and deleting from a remote view..
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!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only