https://sourceforge.net/p/squirrel-sql/bugs/1521/2023-10-14T01:22:46.829000ZRecent changes to 1521: Copy / Paste table deletes in wrong order2023-10-14T01:22:46.829000Z2023-10-14T01:22:46.829000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.net5090013e8d86a6ea4ea1cd2112d3c8ed2ca7b62d

2023-09-28T05:45:16.336000Z2023-09-28T05:45:16.336000ZChris Bitmeadhttps://sourceforge.net/u/chrisbitmead/https://sourceforge.netd78dd75d9600a568301f472406e77cfda8f6c124

<div class="markdown_content"><p>When you do a copy and paste of multiple tables, a little dialog box pops up saying it is analysing foreign keys, by which I assume it is analysing what order to copy the tables so as to not violate foreign key constraints. However, it seems to me that when it deletes the old records (which is the default behavior), it does it in the same order, whereas it should do it in the reverse order.</p> <p>For example , if table B has a foreign key to table A, then of course you should populate A before B. However you should first delete records in B before deleting in A. </p> <p>I suspect the wrong thinking here extends into the UI, because when it asks you permission to delete the records, the options are "Yes" or "Yes to all", and I think its intention is to do one table then asking the question again if you select "Yes". But of course you can't think about deleting from A, until you've deleted from B. So it seems to me there should be no question presented to the user about yes or yes to all, the answer is always yes to all. Maybe you want an "OK" "Cancel" dialog to stop people accidently blowing away data, but once they've decided yep they want to copy, it should go ahead and do all tables, in the reverse order.</p> <p>One other thing, this copy process seems to want to pop up a number of dialogs in succession, The time between one dialog and the next can be so long that you think it is silently failed, and you go to kick it off again. The whole copy process should be done in one window that sticks around from start to finish, so you know where it's up to.</p></div>

2023-09-28T05:45:16.336000Z2023-09-28T05:45:16.336000ZChris Bitmeadhttps://sourceforge.net/u/chrisbitmead/https://sourceforge.net920d389f715b182bd39379dd475aa13db7d5a594

<div class="markdown_content"><p>Ticket 1521 has been modified: Copy / Paste table deletes in wrong order<br/> Edited By: Gerd Wagner (gerdwagner)</p></div>