Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert blank records
Message
De
27/01/2005 11:40:49
 
 
À
27/01/2005 11:33:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00981237
Message ID:
00981242
Vues:
24
>I have a database (regular table) that has records in it sorted by a field called "customerid".
The "customerid" field identifies the customer ID number of individual records. There are multiple records with the same customer ID number. I want insert two empty/blank records after each group of records with the same customer ID number.
>
>What is the code to do that?

William,

Quite simple really, and many ways to do it.

xCustID = However_you_get_it && must not be a primary key (PK) i.e. unique
Inset into CustTable ( CustomerID) values ( xCustId)
Inset into CustTable ( CustomerID) values ( xCustId)

HTH

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