Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert blank records
Message
From
27/01/2005 11:40:49
 
 
To
27/01/2005 11:33:16
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00981237
Message ID:
00981242
Views:
26
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform