Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I cann't update tables...
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
I cann't update tables...
Miscellaneous
Thread ID:
00549134
Message ID:
00549134
Views:
36
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
Map
View

Click here to load this message in the networking platform