Devart Forums

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

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:= '';

Thank you very much

Best Regards,

Farshad R.Vossoughi