Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table not updating
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00361855
Message ID:
00361895
Views:
24
Did you also identify which fields to update and the key field[s]?

>I have a view that is not updating a table. I did set the checkmark send SQL update in update criteria tab. Tableupdate is return a true but it still doesn't update. Here is my code:
>
>r6 = cursorsetprop('sendupdates', .t.,'lv_emparc')
>Update lv_emparc set lv_emparc.e_flg1 = 0 where lv_emparc.e_id = .new_id
>r1 = tableupdate(.t., .t., 'lv_emparc')
>
>r6 = cursorsetprop('sendupdates', .t.,'lv_kkeysarc')
>Update lv_kkeysarc set lv_kkeysarc.k_e_id = new_id where lv_kkeysarc.k_e_id = .old_id
>r2 = tableupdate(.t., .t., 'lv_kkeysarc')
>
>
>Doe's anyone have a clue on this? I do have the view in my dataenvironment. help appreciated
>
>Thanks Nick
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform