General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
I cann't update tables...
Hi,
I'm having a view of 4 tables - thats:
2 VFP Tables and
2 Remote views
They are joined in 1 view.
Adding a reccord an update should update base tables.
The funny is: the remote views update correct and nicely, but VFP tables are untouched:
This is what I do:
Browse the view from project view:
SELE allview
scatter memvar
Append blank
gather memvar - change key values
First
SELE allview
? tableupdate(.T.) && this is the all - view returns .T.
SELE remote1
? tableupdate(.T.) && returns .T. and does it
SELE remote2
? tableupdate(.T.) && returns .t. and does it
brow VFPtab1 && No new reccord added
brow VFPtab2 && no new reccord added
I have set the buffer to 3 in vfptab1 and 2
In the view designer (Eview! not VFP) there are cheked the update bottoms, there are keyfields - sendSQL = .T.
WHAT AM I MISSING????
Thanks in advance.
Lasse
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