Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group by missing or invalid - strangeness
Message
De
12/10/2007 14:40:15
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Group by missing or invalid - strangeness
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01260687
Message ID:
01260687
Vues:
52
Hi All,

I have code in the aftercolchange method to set data up. Now I have a select that use to work, and is now, not working. It is Friday, I know, and I want to go home, so I can not see the problem with this select statement. I do not want to group the results. I am only looking at the first set of data returned.
  SELECT client_id, MAX(act_time) FROM sup_act ;
    WHERE client_id = lcclientid AND problem_id = lcproblemid ;
    INTO ARRAY latemp
I do not see where group by has any thing to do with the statement. Help!

TIA
Beth
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform