Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query runs twice instead of once
Message
De
22/09/2004 06:43:28
 
 
À
21/09/2004 05:15:47
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00944391
Message ID:
00944903
Vues:
18
My dear Professor

Your codes has solved my problem. But I could not understand them.
If possible pleaes write some details about them specially about this select statment
Set Ansi On
Select Date,VOU_TYPE,Cnt(Distinct VOU_NO) As cntVouNo ;
  FROM VOUCHERS ;
  WHERE Date # {} And VOU_TYPE In ;
  ('CP', 'CR', 'JV', 'PR', 'PS', 'SL', 'SS', 'SO', 'SD', 'SC') ;
  Group By Date, VOU_TYPE ;
  order By Date ;
  INTO Cursor v1
Set ansi off
Please help again
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform