Access Violation after first query

[expired user #7816]'s profile image [expired user #7816] posted 9 years ago in General Permalink
Hi,

I've recently been getting repeated Access Violations when trying an SQL query.

This is fairly random but can even happen when I open the program, copy and paste my SQL query and either press F9 or click on the 'Play' icon.

Any help would be appreciated.

Jason
1 attachment(s):
ansgar's profile image ansgar posted 9 years ago Permalink
Is that reproducible for you?

The call stack says it happens in line 5 of TAppSettings.PrepareRegistry, which calls this simple construct:
if '\'+FRegistry.CurrentPath <> Folder then

Nothing special apart from strings here.
[expired user #7816]'s profile image [expired user #7816] posted 9 years ago Permalink
I have just tried again by entering the following SQL:

SELECT NULL AS ID, rg.ID AS GROUP_ID, arp.START_DATE, arp.END_DATE, arp.TEACHING_BLOCK, 'SEMINAR' AS TYPE,
SUBSTRING_INDEX( rg.NAME, ' ', 1 ) AS MODULE, NULL AS STAFF_CODE, 0 AS DELETED
FROM attendance_tutorials.attendance_register_periods AS arp
INNER JOIN attendance_tutorials.register_groups AS rg
WHERE arp.GROUP_ID = 30386
AND rg.ID BETWEEN 19500 AND 19999
;

It didn't happen the first time but after pressing F9 a few times - it crashed at exactly the same place after the 5th press. It doesn't seem to matter what SQL I choose to execute - this was just a query I had handy.

I left a second between the previous query completing (which it does in <1 second) and the next press of F9.
[expired user #7816]'s profile image [expired user #7816] posted 8 years ago Permalink
As well as the frequent crash mentioned above I have just had another one at a different location in your code so thought it may help you trace the problem. The stack trace is attached.
1 attachment(s):

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