I would use Stored Procedure with loop - and inside of it i'd built dynamic SQL Statement (look in archives for examples - it was a few of them).
Marcin U�ytkownik "Dusan Kolesar" <[EMAIL PROTECTED]> napisa� w wiadomo�ci news:[EMAIL PROTECTED] > Hello, > > I want to insert row into more then one table. > List of tabels into which I want to insert is in the next table: > CREATE TABLE "ADMIN"."EVENT_TABLES" > ( > "TB_NAME" Varchar (30) ASCII > ) > I want to do it inside the trigger. > I don't know if is it posible at all, because in the manual is written: > INSERT [INTO] <table_name> ... > <table_name> ::= [<owner>.]<identifier> > There is nothing like table name can be a variabe. > > Thank you very much. > > Dusan > > -- > Dusan Kolesar > Helsinska 19 > 040 13 Kosice > Slovakia > e-mail : [EMAIL PROTECTED] > ICQ# : 160507424 > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
