Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grid can't find SQL Cursor
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00304561
Message ID:
00305011
Vues:
34
>>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.

I will give this a try, but what a hassle to remove about 20 sql statements, save them somewhere else and then later have to copy them in again. Surely this is not what the Microsoft Development team envisaged when they encourage people to update from version 5 to 6!?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform