If it's not too long and hairy can you post your code for us to look at?
>thank you for giving me alternative solutions for this particulat problem. however, i still encounter the same problem once in a while. all the tables (SQl) i am using have already their respective indeces. do you think there are problems with the codes which i used in visual interdev? help me, pls.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
