Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Popups in a screen
Message
From
19/03/1999 14:37:42
 
 
To
19/03/1999 14:35:03
Susan Giddings
Aar Engine Component Services
Windsor, Connecticut, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00199906
Message ID:
00199919
Views:
15
If you would be in VFP completely then the reason and workaround are known. You should unlink combo from cursor before rebuilding it. However, I don't know by sure how to apply it to your mixed environment.

>Hi John, thanks for the quick response. Nothing was run through the converter. I am running the 2.6 spr files. The data is not yet in a VFP database. There is no dataenvironment associated with any screen. The child screens will open a table if it happens to be closed, but they do not close. When I return to the main screen the first thing I do is re-run the procedure that populates the popup list. This is:
> if used("repairs") && this is the cursor which needs to be refreshed
> sele repairs
> use
> endif
> if used ("tdmreps") && this is the table for the cursor
> sele tdmreps
> use
> use tdmreps && I found this worked with the last screen
> else
> use tdmreps in 0
> endif
> sele * from tdmreps ;
> where tdmreps.name = m.name ;
> order by tdmreps.repairno ;
> into cursor repairs
>
>I found if I did not close the cursor first, VFP would not actually recreate it. I tried the "clear resources repairs" command but that really didn't solve it either.
>
>
>>Hi Susan ---
>>
>>Odds are that the child forms are running their own dataenvironments that are being closed when the child form is closed, therefore disconnecting the main form bound controls from the data. You say this is a 2.6 form but how are the tables being opened? Was this form run through the Converter?
>>
>>
>>>I have a 2.6 spr file I am running from within VFP 6.0. This screen contains 4 popup lists each populated by a cursor. Additionally there are 4 push button controls associated with each of these lists which allow a user to add/edit/delete the supporting table which drives the lists. When a user clicks on one of these, another screen will prompt them to enter their changes to the table. When they do this, and control returns to the main (calling) screen, I am getting an error: "Cannot access the selected table." I had this before on a similar screen (only one popup list) and found when I closed and then re-opened the table prior to re-running the sql for the cursor and removed the show gets statement I was OK. Tried strategy on this screen + clear resources and still have the problem. I know what I'm trying to do is kind pushing things, but can anyone offer any tips on how to fix it quick and dirty? (I know I should re-write the thing in VFP and will do that, I just
>wanted
>>>to get everything running on one platform first and then do the re-writes.)
>>>
>>>TIA, S
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform