Icon View Incident Report

Serious Serious
Reported By: John Hay
Reported On: 2/8/2011
For: Version 4.30 Build 2
# 3404 Preparing a Script Before Executing Can Cause First Statement to Not Execute

With the following script, if I execute it in dbsys version 4.30 build 2, I get 3 records in memory\temp. I can execute it any number of times and get 3 records.

If I Prepare it first (ie click prepare button) I get 3 records the first time I run it. If I do not click Unprepare I get 7 records the 2nd, 11 records the third,15 records the 4th etc.

EMPTY TABLE IF EXISTS "memory\temp";
CREATE TABLE IF NOT EXISTS "memory\temp"
(t1 CHAR(10),
t2 CHAR(10));

INSERT INTO memory\temp (t1,t2) VALUES('11','12');
INSERT INTO memory\temp (t1,t2) VALUES('21','22');
INSERT INTO memory\temp (t1,t2) VALUES('31','32');



Comments Comments and Workarounds
DBISAM was not properly unpreparing the last statement executed. The workaround is to either a) not Prepare a script ahead of time, or b) make sure to UnPrepare the script after each execution.


Resolution Resolution
Fixed Problem on 3/15/2011 in version 4.30 build 3


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image