General information
Category:
Coding, syntax & commands
>I am currently trying to manipulate data in a SQLServer
>table.
>
> It is my understanding that
>
>1. to do this with VFP I must use a "Remote View" -
no, you can use SQL* commands like
SQLEXEC SQLCONNECT etc.
but I think remote views are better
>2. If I change recordsin the remote view, those records are changed in the back-end table on issuing a TABLEUPDATE or closing the view.
you have to set your view as updatable (see CURSORSETPROP and
DBSETPROP commands) for updates to happen
also in VFP5.0 you have off-line views which update the data only when they are turned on-line
Arnon
Previous
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