var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: on delete cascade on the same table - is it possible?
as u should know this code doesn't work ..
CREATE TABLE tempo (
PRIMARY KEY (cid),
FOREIGN KEY (parent_id) REFERENCES tempo ON DELETE CASCADE
any suggestion to achieve this ?
Create a trigger to delete all the records with the same criteria. When a record is deleted in that Table.
This Code may help
create trigger delcascadetrig
from tempo, deleted
where tempo.cid = deleted.cid
Last edited by machado; 05-08-03 at 17:28.
Double J IT Solutions
VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access