Hi,
I am currently looking at creating a database component that can be used with both Hypersonic and MYSQL. As I am required to execute large statments a need to use the limit SQL keyword.
I have notice a differance between Hypersonic and MySQL. In Hypersonic the syntax is:
However In MySQL the syntax for limit is:
So I can't send the same statements to both database.
I was wondering which one is the standard way for the LIMIT syntax.
Once I know the standard way this should be done I may start looking at the database code for the non-standard one. May even be able to make them both the same
Thanks
Chris.
I am currently looking at creating a database component that can be used with both Hypersonic and MYSQL. As I am required to execute large statments a need to use the limit SQL keyword.
I have notice a differance between Hypersonic and MySQL. In Hypersonic the syntax is:
However In MySQL the syntax for limit is:
So I can't send the same statements to both database.
I was wondering which one is the standard way for the LIMIT syntax.
Once I know the standard way this should be done I may start looking at the database code for the non-standard one. May even be able to make them both the same
Thanks
Chris.