Is there a generic Limit & Offset command which uniDAC will translate to the proper format for the target database system?
Best Regards,
Farshad R. Vossoughi
Generic Limit and Offset (Pagination)
UniDAC is universal. Limit & Offset commands are supported only by several databases. That's why we did not implement support for Limit & Offset commands in UniDAC.
But you can use macros to use Limit & Offset commands:
UniQuery.SQL:= 'SELECT * FROM Dept &LimitAndOffset';
And define them depending on the current database:
if UniConnection.ProviderName = 'MySql' then
UniQuery.MacroByName('LimitAndOffset').Value:= 'LIMIT 10 OFFSET 10'
else if UniConnection.ProviderName = '...' then
...
else
UniQuery.MacroByName('LimitAndOffset').Value:= '';
But you can use macros to use Limit & Offset commands:
UniQuery.SQL:= 'SELECT * FROM Dept &LimitAndOffset';
And define them depending on the current database:
if UniConnection.ProviderName = 'MySql' then
UniQuery.MacroByName('LimitAndOffset').Value:= 'LIMIT 10 OFFSET 10'
else if UniConnection.ProviderName = '...' then
...
else
UniQuery.MacroByName('LimitAndOffset').Value:= '';