Missed that... no.
>Richard,
>Asking once again. Is Afields() part of cursor creation?
>Cetin
>
>>OK, Wrapped the line in a TRY...ENDTRY. Still curDisplay.
>>
>>
>>>Richard,
>>>Maybe I was not clear. It's 'before'. I meant at the time it occurred.
>>>Cetin
>>>
>>>>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