Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by missing or invalid - strangeness
Message
From
12/10/2007 14:40:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Group by missing or invalid - strangeness
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01260687
Message ID:
01260687
Views:
50
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
Next
Reply
Map
View

Click here to load this message in the networking platform