Hi Helen,

Thanks for the reply, but i am a bit lost as to what "MY" options are here,

Does this mean that i cannot write EXECUTE BLOCK statements and use my beloved IBOdataset components any more ?

I can write the function as four IBOQuery components, 2 for the purchase order copy, then and other 2 for the purchase order items copy but seems crazy as i can do it in one simple EXECUTE BLOCK call is that waht you mean by "executable SP"

I cant see how i can get the primary key value from an insert statement so i can use it in the detail table for its FK in your example insert into blah b select foo, bar,.... from foobar f
where b.foo = :bfoo
and b.bar = :bbar

I only have IBODataset components and am not licenced to use any other components i was informed unless i buy the complete set, So is the end for me and IBO components ?

How can I use the update sql as it says i cant prepare an empty statement ?

Thanks for your help with this

COlin Coleman