Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

cancel replace

BubikolRamios's profile image BubikolRamios posted 9 months ago in General Permalink

Can you sort that, right most window would have "cancel all replace", or something. One forgets to check 'Selection' and gets stuck, can't do anything but kill program.

Possible way out would be adding 'ignore sql error' check, default on.

Note - the message on screen comes from trigger ...

image description

ansgar's profile image ansgar posted 9 months ago Permalink

Is that really happening with the latest HeidiSQL version?

BubikolRamios's profile image BubikolRamios posted 9 months ago Permalink

Latest nightly build, a bit different, but, all looks ok (really not), then you click into data tab, and repeats idefinitely SAME sql that produces error on trigger. like:

UPDATE test SET f = 'foo' where f1 = 'foo1' / SQL Error (1048): Column 'id_tezaver' cannot be null / Upper error comes from attempt to trigger insert something into another table.

BubikolRamios's profile image BubikolRamios posted 9 months ago Permalink

SAME sql means update of exactly same row.

BubikolRamios's profile image BubikolRamios posted 9 months ago Permalink

Note, you don't realy have to kill a prog in latest ver. to get out, you can set focus to another table and come back to table of interest. An ugly workaround. As said, nice would be ignoring all sql errors and replace update all records that can be updated.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.