Jean-François ROY
|
Posted: 11/08/2002, 7:28 AM |
|
Hi,
I'm building this admin interface where I want to delete records from the
table t_order and the table t_order_detail.
Sincerely,
Jean-François
|
|
|
RonB
|
Posted: 11/08/2002, 11:53 PM |
|
Hi,
this is not easy without knowing which database you use. In Oracle you could
write an trigger to do this (with a constraint)or create a view and delte
via the view. For mysql you have to write an after delete event, something
like:
delete from t_order_detail where order_id_field_in_t_order_detail =
'{field_in_grid_containing_order_id}'
Hope this helps,
Ron
"Jean-François ROY" <jfroy@wanadoo.fr> schreef in bericht
news:aqgl75$akm$1@news.codecharge.com...
> Hi,
>
> I'm building this admin interface where I want to delete records from the
> table t_order and the table t_order_detail.
>
> Sincerely,
>
> Jean-François
>
>
|
|
|
|