Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I cann't update tables...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00549134
Message ID:
00549139
Views:
19
I really don't know what is wrong with your code. I have a suggestion, though. Why don't you try to update one our your views, say remote1, standalone, without messing with allview and remote2 and see if that works.
SELE remote1
append blank
populate fields
? tableupdate(.T.) 

select VFPtable1
browse
This at least will give an idea whether the problem is the view or your code.

>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
Hector Correa
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform