I am trying to do something like the attached sql using the IStatement
interface.
An ordinary select works fine, but there is no cursor returned in this
case.
There are no examples of this sort of thing, which would be helpful.
Regards, Treeve
create table master(
id smallint generated by default as identity not null,
data char(10),
constraint pk_mast primary key(id)
);
create table detail(
id smallint generated by default as identity not null,
mast_id smallint not null,
data char(10),
constraint pk_det primary key(id),
constraint fk_det foreign key(mast_id) references master(id)
);
-- I am trying to use the following pseudo-code with the messages
interface
-- but am unable to get the returned values
insert into master(data) values('ME') returning id into :mid;
insert into detail(mast_id,data) values(:mid,'junk') ;
insert into detail(mast_id,data) values(:mid,'more') ;
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
