> Yes I agree in keeping them short....
>
> But we have a procedure, that will select around 280.000 records (some
> varchar, some integer, some numeric etc).
> The program will iterate through them, and insert 1 new record for
> each of them.
>
> WITHOUT unidirectional I get a OUT OF MEMORY.
>
> WITH unidirectional I do not get this.
>
> At this point, I have to come up with a solution that will work NOW.
> I have to rewrite to code at some time, to make it better.
>
> So thats the reason......

Why not create a Stored Procedure for this :-)

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