>>>how to add a temporary table to dataenv which changes every time it loads with same alias name & is source to a grid control.
>>
>>If you mean create a cursor that you can bond a grid to, you can run your SQL from te Form.Load.
>
>Will this work in VFP 6? I had problems if I explicitly referenced a non-existent alias (that I was planning to create in the form.load) and received numerous errors. I eventually moved the sql statement to the dataenvironment.beforeopentables and was successful. Have you encountered this problem?
I do this all the time. You WILL get errors if you wait until the form.init, but load happens before the grid instanciates.
Erik Moore
Clientelligence