General information
Title:
Having Functions in SQL Groupby
Is there any way where we can have functions in groupby while firing a SQL statement to visual foxpro.
Eg: select jobno,year(eta) from jobmast group by year(eta)
The above SQL gives an error. THe roundabout way is
select jobno,year(eta) as yr from jobmast group by yr
The above SQL Statement works fine, but the OLAP tool which connects to visual foxpro database generates the 1st SQL statement. And the report dosen't go through.
Regards
Ravi
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only