Hello,
I am using Delphi 10.3.2, UniDAC 8.0.1, FirebirdSQL 2.5.9, targeting Win32 executable.
When copying data from one database to another using TUniLoader I have error at the end of operation. Despite of error, all data copied to target table.
1-Set TUniQuery.Unidirectional = True
2-Set TUniQuery.SQL so that it include very last record in source table. For example, if source table has 100000 records in it. TUniQuery must have all records(select * from table), or must include last 100 records. If TUniQuery.SQL includes records but not last record in table, error is not re-produced.
My case, that source table does not include any kind of index in it, including primary key index. I did not test problem with a table with primary key index.
3-Load records using some code like "UniLoader1.LoadFromDataSet(UniQuery1);"
You are going to have all records successfully copied from source to detail unfortunately, you are also going to get error UniQuery1: Record not found." at the end of the operation.
I am going to send small test case project with necessary databases using contact form including a download link because database I need to include is big in size even after compressing.
Thanks & regards,
Ertan
UniLoader error "Record not found"
Re: UniLoader error "Record not found"
Thank you for the information. We have already fixed the issue. This fix will be included into the next UniDAC.
As a temporary solution, you can assign a value other than 25 to TUniQuery.FetchRows -- for example, 24.
As a temporary solution, you can assign a value other than 25 to TUniQuery.FetchRows -- for example, 24.