Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid can't find SQL Cursor
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00304561
Message ID:
00304579
Views:
26
>I have recently acquire VFP6 and am trying to adapt a VFP5 app. I have a number of pages with grids populutated using either a Select SQL or a QPR. They work perfectly in VFP5, but in 6 I get an 'alias not found' error before the form even loads. The alias is the cursor which is the result of the SQL Select in the Grid Recordsource.

I had that problem too...Try removing all sources for the grids, and rebuilding. It should work okay, but whatever table is selected will appear in the grid (you can set recordsource = '' (empty string) in grid Init to avoid this). But the main thing is to get a fresh start, without any errors.

Anyway, it should run without error after this. Now, go back and add the sources to the grids again freshly, and try rebuilding.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform