Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 3.0 updateable view problem
Message
From
16/11/1996 18:47:12
 
 
To
15/11/1996 04:50:11
Andrzej Majlich
Vulcan sp. z o. o.
Wroclaw, Poland
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00012219
Message ID:
00012515
Views:
37
>>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,
I had some problems (my main HD at home crashed completely (s) )
so I wasn't on-line much
just to get strait- your current problem is that it sends update but it doesn't send update for newrecords , right?

Arnon
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform