curDisplay IS the selected workarea/alias and open. Verified with MESSAGEBOX(ALIAS(SELECT(0))). Prior to the problematic line.
The curDisplay is created immediately before the SELECT curDisplay line. Using a Select-SQL.
>>This particular error is bothering me.
>>
>>On this one line:
>>
>> Grid1.RecordSource = 'curDisplay'
>>
>>
>>VFP 9 Runtime reports an error of : "No table is open in the current work area"
>>
>>However, (I have my executable spit out a file with tables in use etc) I can plainly see the table in use in the current Datasession:
>>
>>...
>>Alias Table File
>>CURDISPLAY 00003QXL004H.TMP
>>...
>>
>>
>>I have placed this line before the line giving an error to ensure it is there:
>>
>>SELECT curDisplay
>>
>>
>>I even have it verifying that it is in use PRIOR to the statement giving the error. What gives?
>>
>>Any ideas would be appreciated.
>>
>>Richard
>
>Richard,
>It is not saying 'curDisplay' is not found, it's saying no table is open in current workarea. What is the alias() in current workarea, check that. Probably curDisplay was created with afields().
>Cetin
State of Florida, DCF