Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids and error
Message
From
13/10/2006 10:37:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01161719
Message ID:
01161749
Views:
30
Requery? It sounded like a cursor to me. If it's cursor how did you create it?
Cetin

>The Form will open and display data. It is happening during a requery of the data source. Similar code works throughout this application with zero problems. I did have a problem at one point with losing my columns but that problem has been solved. This one has just started.
>
>Possibility of a corrupt Form file?
>
>Richard
>
>
>
>>>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
>>
>>Perhaps you're opening or creating your curDisplay in Form's Init, which is too late for the grid. You need to have curDisplay available in form's Load.
Ç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
Reply
Map
View

Click here to load this message in the networking platform