>>How can I make program execution stop until a requery is completed and the sql server is not busy? >>I get the error is busy....at a minimum I would like to trap that error so that it >>does not display on screen and just waits until its not busy any more. I have tried setting all >>the fields available in sqlsetprop to thier highest values with no help at all. Thanks >> >>Gary > > >You could use the CONNECTBUSY property and essentially loop until this property is false and then issue the requery().. > >-=E
You can also set the view (No. of records to fetchat a time = ALL).
Another way is to create a connection class to provide a non busy connection to open your view, if no connection is available, then create new connection.