|
| Edit/Insert Rows In a "Connecting" Table |
 |
31 Mar 2008 02:52:07 -0700 |
Hi,
I have a "connecting" table which is a table designed just to connect
multiple items from one table to multiple items in a second table. Basically,
this table's fields are [ID_TABLE_1,ID_TABLE_2] and that's all. This way I can
connect as many TABLE1 items with as many TABLE2 items I want (N<->N).
I have a grid that shows the contents of this table with some extra fields from
TABLE_2 (for description pourposes), example:
TABLE_2.Description, TABLE_2.NAME, TABLE_2.etc. When I try to insert or edit the
fields I have an exception that says I need to provide some values that aren't
set (this values are the extra values from TABLE_2 which are not required for my
Update/Insert operation).
I've put the AfterPost of my ClientDataSet to do a simple ApplyUpdates and the
DataSetProviders OnBeforeUpdateRecord does the dirty work. The problem is that
because of that Exception, the AfterPost never gets called and neither does the
BeforeUpdateRecord..
I hope I could explain this properly,
Does anyone has any idea on how to proceed on this matter?
Thank you,
|
| Post Reply
|
| Re: Edit/Insert Rows In a "Connecting" Table |
 |
31 Mar 2008 03:01:14 -0700 |
|
| Post Reply
|
|
|
|
|
|
|
|
|
|