Hi,
I have run some SQL queries like this one:
SELECT t. FROM emails t WHERE t.person_id = (SELECT t2.person_ID FROM emails t2 WHERE t2.address = "aaa");
This shows all of the emails of the user who has the aaa address.
After this I make one change to a value in a field and hit the green check mark (Post) to push to the server. However HeidiSQL gives me an Access Violation error (log attached).
- date/time : 2019-06-13, 18:46:54, 221ms
- computer name : DESKTOP-GBI4LJH
- user name : ducpham
- registered owner : Windows User
- operating system : Windows 10 x64 build 17763
- system language : English
- system up time : 6 hours 21 minutes
- program up time : 1 minute 31 seconds
- processors : 4x Intel(R) Core(TM) i5-7400 CPU @ 3.00GHz
- physical memory : 1965/8083 MB (free/total)
- free disk space : (C:) 87.58 GB
- display mode : 1920x1080, 32 bit
- process id : $3be4
- allocated memory : 81.76 MB
- largest free block : 1.10 GB
- executable : heidisql.exe
- exec. date/time : 2019-06-13 14:05
- version : 10.1.0.5464
- compiled with : Delphi 10.3 Rio
- madExcept version : 5.0.0
- callstack crc : $00000000, $37b74238, $37b74238
- exception number : 10
- exception class : EAccessViolation
- exception message : Access violation at address 00000000 in module 'heidisql.exe'. Read of address 00000000.
- main thread ($39b8):
- 00000000 ???
- 006c4d02 heidisql.exe Vcl.Forms TApplication.IsHintMsg
- 006c4eff heidisql.exe Vcl.Forms TApplication.ProcessMessage
- 006c4f86 heidisql.exe Vcl.Forms TApplication.HandleMessage
- 006c52b9 heidisql.exe Vcl.Forms TApplication.Run
- 773c0417 KERNEL32.DLL BaseThreadInitThunk
After this i restarted HeidiSQL. Interestingly, the change was pushed successfully to the server! However everytime I try to change a value this way I saw the Access Violation error again.
Is there anyway around it?