Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help Adding Column to Cursor
Message
De
30/11/2006 07:22:05
 
 
À
30/11/2006 00:04:21
Randy Wessels
Screentek Business Solutions, Llc.
Phoenix, Arizona, États-Unis
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 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01173581
Message ID:
01173633
Vues:
15
>You guys have been very helpfull in the past. Thank you ahead of time for any responses.
>
>I am trying to add a column to a cursor created by the Afields command but I am getting the error message on the alter statement: Field name is a duplicate or invalid.
>
>Select invoiceitems
>ordnumfields = Afields(orditemfieldarray)
>Create Cursor orditemview From Array orditemfieldarray
>alter table orditemview add column toplevelitem c(20)
>
>-Randy

Randy

To do with the 10-sig-chars field name. Have you 2 prospective fields who both have the same 10-char root, e.g.
Day_sales_Inv1 and Day_sales_Inv2?

Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform