I am in the process of developing my first application with VFP5.0. The program is a call manager that also has a callback queue where everyone in the company will have access to add calls into the queue, but only phone reps will have the ability to remove calls from the queue. The problem I am running into is in making the actual queue.

I have created an SQL statement that I originally made to be used with a paramaterized view (so I could use the =REQUERY() function to update the contents of the queue in real time). The problem is that a view appears to open the underlying tables in exclusive mode only, this prevents two copies from running on the network (second copy causes GPF error to occur on two different systems I have tried).

I would use a query, but I can’t seem to get the grid to update in real time when using the query (the grid just blanks out when I rerun the query). I have also tried putting the SQL statement directly into the RecordSource property (with the RecordSourceType set to 4 - SQL statement) but this just causes a GPF error to occur as soon as move off of the property.

All of the tables and other data objects I have initialised through code, I have given up on the DataEnvironment window as it cannot maintain relationships reliably.

Can anyone tell me how I can use a grid object with an SQL statement where I can rerun the SQL statement in real time? I do not want to have a separate browse window open that displays the results, I want it integrated into a grid control object. This is the last major segment of my program, and I was supposed to go live this week.

Any help is greatly appreciated, thanks in advance.