Devart Forums

Hi we are migrating from MyDac to UniDac.

How can we replace the server-side instruction?

TMyTable.Limit := 10

Thanks!

Current version of UniDAC does not have this feature. You can replace TMyTable component with TUniQuery, and assign a SELECT statement with LIMIT clause to the SQL property.

We'll consider possibility to add support for LIMIT in TUniTable in one of the next UniDAC builds.

Thanks for your reply.

We already considered using TMyQuery but we didn't choose it because of the lack of the index-reading capability. (PSGetKeyFields)

We also tried to use FetchAll=False and FetchRows=n but this is not a good solution because of the heavy load on the server with an instruction returning million of rows to be processed.

When do you think the limit function could be avaible in UniDAC?

Maybe we'll add it to the next build of UniDAC. We are planning to release it in a month.