MyDac TMyTable.Limit

lucascompa · Post by **lucascompa** » Mon 09 Jun 2008 08:23

Hi we are migrating from MyDac to UniDac.

How can we replace the server-side instruction?

TMyTable.Limit := 10

Thanks!

Plash · Post by **Plash** » Mon 09 Jun 2008 10:54

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.

lucascompa · Post by **lucascompa** » Tue 10 Jun 2008 09:11

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?

Plash · Post by **Plash** » Fri 13 Jun 2008 10:37

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