rbaldwin
Posts: 172
|
| Posted: 07/02/2009, 3:11 PM |
|
I have a table, myTable, with the columns id, app_id, flag. I have full control on this table at present has about 10 rows
and i have a table masterTable that i only have select access on. with the columns app_id, app_name. this table has several thousand rows
myTable is a subset of masterTable.
i need to be able to insert rows from masterTable into myTable.
I would like to use the editable Grid to do this using custom delete but instead of deleting i would code my custom delete as an insert into myTable. I have built the page, but it isn't showing the delete checkbox. is this because i do not have the appropriate permision on the masterTable?
Do you think this approach can work? or can you suggest an alternative approach?
|
 |
 |
Waspman
Posts: 948
|
| Posted: 07/03/2009, 1:04 AM |
|
I do this all the time. Feed from a master table into an editable grid. Then Hijack the delete to insert into another table?
Build the table as normal allow delete and identify the delete control (checkbox).
Then set custom delete to sql and insert your code.
T
_________________
http://www.waspmedia.co.uk |
|
|
|
rbaldwin
Posts: 172
|
| Posted: 07/06/2009, 7:32 AM |
|
Thanks for the reply,
I've managed to get this working, but i had to:
CheckBox_Delete_Panel - had to add before show event to make it visible, even though by default it should be visible
CheckBox_Delete - had to also add code in before show event to make it visible even though i had already set in properties Visible = Yes from Dynamic.
Perhaps this is becuase in the datasource for the editable grid, i've had to join tables from two databases.
|
|
|
|
|
