Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is it good practice to create temporary dbfs then ....
Message
De
05/01/2006 10:56:58
 
 
À
05/01/2006 10:34:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01082941
Message ID:
01083567
Vues:
13
>Why would you want to alter the stucture of the cursor? You should have built it correctly in the first place, since it is a cursor. You probable want to alter the data in the cursor.
>>
>>Uless your code will ALTER TABLE on the cursor, in which case the 10 character field name limit does come into play.

You may need to change the structure of the cursor, if the cursor is created by a SQL Select statement. For instance I often do like this
Select * From xx into cursor curdummy readwrite
Alter table curdummy add column newmemo m
This is much easier than listing all the fields in combination with Cast.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform