Re: Get the first x records

Giorgio Vanoni wrote:



It does not work for all providers as well eg oracle.

All providers is not something that I have managed to acomplish
yet. So please specify which providers you need and we will see if
there is a common way to accomplish it.

That's the problem, I would use a unique method for all the prividers.
I use a ADOQUERY and a ADOCONNECTION.
The connection could be with Access,MSSQL,FB/IB through ODBC, ODBC-->?
So "all" the DB.

In my query there is "SELECT ......" and my software limit the record
fetched.

Giorgio.

You can accomplish this for your own software if you are determined
enough put not for every single SQL command with every single provider.

a couple of thoughts are

1) create a custom Connection class which will recognise the
providers you have and change the sql queries based on the
provider to enforce your requirement.

2) Make sure that you use stored procedures / views to access your data
and enforce your rule there changing each view/stored for each
provider.

regards
Yannis.

--

.