How to change this SQL to adapt to UCanaccess?

A pure Java JDBC driver for Microsoft Access database files

Brought to you by: jamadei

How to change this SQL to adapt to UCanaccess?

Forum: Help

Creator: Jacky Luk

Created: 2014-09-09

Updated: 2014-09-21

Jacky Luk - 2014-09-09

String str = "SELECT DISTINCTROW Partition([Age],15,120,6) AS Age_Range, Count(Patient.Age) AS Range_Count FROM Patient GROUP BY Partition([Age],15,120,6)";

Thanks
Jack

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marco Amadei - 2014-09-09

The reason why it doesn't work is that the partition function isn't supported yet
BUT
it will be implemented in the 2.0.9.(that will be released very soon).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Jacky Luk - 2014-09-09
  
  Thanks Marco, longing for that to arrive!
  Jack
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marco Amadei - 2014-09-11

Added support to partition function in the 2.0.9.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jacky Luk - 2014-09-21

Thanks a lot
Have a nice day!
Jack

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.