View Incident Report

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 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

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

Products Affected

DBISAM Additional Software and Utilities
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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap