View Incident Report

Serious

Reported By: Jim Margarit
Reported On: 7/20/2000
For: Version 2.03 Build 1

# 609 SQL INSERT Statement with SELECT * Sub-Query Causes AV

Using a SELECT * as the sub-query source for an SQL INSERT statement causes an access violation.

q.sql.clear;
q.sql.add('Insert into "parts.dat" select * from "partsOrg.dat"');
q.prepare;
q.execsql;
q.unprepare;

Resolution

Fixed Problem on 7/22/2000 in version 2.04 build 1

More Support Options