Hi Denise,
Perry helped with one part of your question, I have a pointer on another: Look at the Asynchronous property with SQLSETPROP() to get the program to pause until the view is totally refreshed.
'Course, you can always bring this up at the next FUG (bring source code, data, a laptop and hard alcohol :-)
>Another question for those of you that have a moment... I have a routine in my program that deletes all the old records of a table and reads in new information. Of course, it's a view too. And it's several thousand records. So what's happening here is that I use table exclusive and it takes a couple seconds to read that in. But the code continues immediately to try to execute even though it's not finished reading in all the records. Then I get an error message stating that the connection is busy. What I really need is for the execution of the code to pause until it's finished reading in all the records. I was thinking of putting some type of error trap in a loop so that whenever that error comes up I could put up a wait window or something informing the user that it's busy. That would solve the problem of making the code pause and letting the user know the computer is not locked up. What do you think of that? Would that be the best way to go about this?
>
>Thanks again for all your help.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05