Icon View Incident Report

Serious Serious
Reported By: Sean Cunningham
Reported On: 3/30/1999
For: Version 1.13 Build 1
# 398 Using SQL Queries on In-Memory Tables in a Multi-Threaded Application Causes Errors

As you know, I am doing multi-threaded updating of in-memory tables. I am finding that at random but regular intervals I get DBISAM error Access Denied 11013, or Cannot delete for a TMPx.DAT file. I checked the help file for this error, but haven't been able to figure out the problem. I actually have 3 different db updating routines in each thread, which update 3 different inmem tables. I use run-time created queries, which share the same session name with the inmem tables.

Comments Comments
Problem was caused by the naming of the temporary tables used as the result sets of queries. Version 1.14 now names temporary tables using thread IDs so as to avoid any conflicts in a multi-threaded application.

Resolution Resolution
Fixed Problem on 5/30/1999 in version 1.14 build 1