Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tip o' the Day: ALTER TABLE on a Cursor
Message
De
16/02/2001 02:02:33
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Tip o' the Day: ALTER TABLE on a Cursor
Divers
Thread ID:
00476591
Message ID:
00476591
Vues:
77
I just found out this works, with a caveat (at least in VFP5). I used a complex SELECT - SQL to generate a report cursor. I wanted to add a memo column to the resultant cursor:
* Report cursor:
SELECT ;
  ... ;
  INTO CURSOR MyCursor ;
  ...

* Make the cursor read-write:
USE ... AGAIN etc.

* Add the memo column:
ALTER TABLE ... ADD COLUMN MyMemo M
Yes, I know you can use CREATE CURSOR to create a dummy cursor with a single M column, then add that into the JOINs in the SELECT - SQL, but it was a pretty heinous statement already so I thought I'd be lazy ;-)

One caveat I've found that any long cursor column names are truncated to the old FP standard 10 characters (watch out if you have column names that match to that length).

Maybe just of academic interest, but it could be a useful tool in report generation or just general-purpose data munging.

BTW can anyone confirm if this works in VFP6?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform