Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 3.0 updateable view problem
Message
From
15/11/1996 04:50:11
Andrzej Majlich
Vulcan sp. z o. o.
Wroclaw, Poland
 
 
To
15/11/1996 02:17:33
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00012219
Message ID:
00012325
Views:
34
>did you configure it to send updates on key fields as well..

Yes. Without this, updates to "old" records wouldn't happen I suppose.
I tried to extract problem to a short programm. Here's a setup code of it:

PRIVATE err, tustat

CREATE DATABASE try

CREATE TABLE items (Name C(20), id c(10))
INDEX ON id TAG id
=CURSORSETPROP('buffering',5,'items')

CREATE SQL VIEW v_items AS SELECT * FROM items
=DBSETPROP('v_items', 'View', 'Tables', 'items')
=DBSETPROP('v_items', 'View', 'WhereType', 1)
=DBSETPROP('v_items.nazwa', 'Field', 'UpdateName', 'items.nazwa')
=DBSETPROP('v_items.id', 'Field', 'UpdateName', 'items.id')
=DBSETPROP('v_items.id', 'Field', 'KeyField', .T.)
=DBSETPROP('v_items.nazwa', 'Field', 'Updatable', .T.)
=DBSETPROP('v_items.id', 'Field', 'Updatable', .T.)
=DBSETPROP('v_items', 'View', 'SendUpdates', .T.)
_________________

*|| Andrzej [NJ].
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform