Posted by Cima on 04/29/05 07:13

hi,

thanx for your input.

i noticed that the last part of the create table query was the part that was
causing the 'problem'. the on commit delete rows was deleting the values i
inserted after executing the query therefore i couldnt select anything from
it.

i did try Richard Lynch's code and it works fine. thanx.

[Back to original message]