$tr1 = ibase_trans();
$q4 = 'ALTER TABLE wlasciciele ADD miasto_id integer not null
references miasto(id)';
$r4 = ibase_query($dbh,$q4);
ibase_commit($tr1);
$tr1 = ibase_trans();
$q5 = 'ALTER TABLE wypadki ADD miejsce_id integer not null
references miasto(id)';
$r5 = ibase_query($dbh,$q5);
ibase_commit($tr1);
Could anyone help me? I need to write a small program (for
Interbase/Firebird ) witch will be doing:
- create new table in my current database
- add new column to some table ( alter table )
- insetr some datas to this new column (from others columns)
- delete some datas