> Either way could be implemented.
>
> I have tried a stored procedure.
> It work. But I lack response from the server while the rutine runs.
>
> I havn't tried the
>
> insert Into table )
> value,
> value)
> Select value, value from table where condition
>
> And here I will NOT select records I insert.
>
> But I could also do it with unidirectional set to TRUE.
> This actually completed with no errors.
>
> But which is best ?
>
> There will be other clients connected at this point, so the impact
> should be as small as posible to them.

How long does it take?

Is this a one time operation? If so, and it takes little time, why bother?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com