Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL select questions.
Message
De
16/06/1997 07:45:55
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
SQL select questions.
Divers
Thread ID:
00036481
Message ID:
00036481
Vues:
65
I have two questions : 1. The following code VNRCRT=0 SELECT NRCRT() AS NC,NAME FROM ADDBOOK FUNCTION NRCRT VNRCRT=VNRCRT+1 RETURN VNRCRT return the following cursor : nc name == ===== 2 john 3 mark .... It seems that NRCRT() is called twice for the first record. Is this a feature? Is this a bug? There is any (logical) reason for this behaviour? 2. I'm using something like : SELECT FIELD1, FIELD2, UDF1() AS CFIELD1 FROM TABLEA INTO CURSOR CURSOR1 The UDF1 return a numeric value. There is any way to force VFP to create the CFIELD1 cursor field with a specified lenght and decimal digits? 3. I have a table like DATE AMOUNT ==== ======= 01/01 10 01/02 5 01/05 7 There is any way to create a cursor with a "running total" additional field like DATE AMOUNT TOTAL ==== ======= ======= 01/01 10 10 01/02 5 15 01/05 7 22 using only one SQL select without any UDF? Thank's
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform