General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only