>Since the connection is open when the .Fill is called the dataadapter will leave the connection open and you will need to close it yourself afterwards
Ok, this works. So, this means, if I have a robot that does those record selections every minute, I will have to issue the RAND(-1) everytime just before the SQL command in the same environment. In VFP, we only have to do it at first when the application starts.