Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create new group
Message
De
18/01/2019 06:02:07
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Create new group
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01665534
Message ID:
01665534
Vues:
100
Sir I have these codes
CREATE CURSOR junk(qty n(3),idid n(3))

INSERT INTO junk values(5,1)
INSERT INTO junk values(10,0)
INSERT INTO junk values(15,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(15,0)
INSERT INTO junk values(10,0)
INSERT INTO junk values(5,0)
INSERT INTO junk values(0,0)
INSERT INTO junk values(10,0)
INSERT INTO junk values(15,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(15,0)
INSERT INTO junk values(10,0)
INSERT INTO junk values(5,0)
INSERT INTO junk values(10,0)
INSERT INTO junk values(15,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(20,0)
INSERT INTO junk values(15,0)
INSERT INTO junk values(10,0)
INSERT INTO junk values(5,0)
I want to fill idid column as follows




Logic:

Qty increase then decrease in every idid group.
New idid starts from small to bigger number like shown with red color.

Please
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform