I have a UniTable with a MySQL-Connection
fetchall=false
fetchrow=50
When I open the table with an Indexfield on IndexFieldNames then the Table opens with all the records instead of only 50. Is there anything else to do?
When I open the table without the Indexfield it works.
UniTable: IndexFieldNames and fetchall=false
Hello,
If you set the IndexFieldNames property, then we have to read all data from the table to sort it by the specified field afterwards. And as we get all records, the RecordCount property displays the actual number of records in the table correspondingly.
To sort everything on the server side, you can use the OrderFields property. In this case sorting will be performed on the server side and you will get the amount of records specified in the FetchRow property.
If you set the IndexFieldNames property, then we have to read all data from the table to sort it by the specified field afterwards. And as we get all records, the RecordCount property displays the actual number of records in the table correspondingly.
To sort everything on the server side, you can use the OrderFields property. In this case sorting will be performed on the server side and you will get the amount of records specified in the FetchRow property.