Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Cursor mysteries
Message
De
30/09/2015 19:05:52
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Cursor mysteries
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01625276
Message ID:
01625276
Vues:
68
I'm converting some dbf's to SQL Server tables.
In several cases, I have to replace the dbf as a recordsource of a grid with a cursor created by reading from a SQL table.
I set the cursor name as the recordsource property of the grid, set the column names as the controlsource properties of the columns.
When I show the form instead of showing the named columns column1 in the grid shows the contents of column 1 in the cursor, etc, etc.
As a workaround, I changed the query so that things work, but that will not work in every case.
Any ideas?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform