Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids and error
Message
From
13/10/2006 10:39:38
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01161719
Message ID:
01161752
Views:
20
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform