Icon View Incident Report

Serious Serious
Reported By: Dan Bassett
Reported On: 11/28/2002
For: Version 3.19 Build 1
# 1277 ExportTable Method Does Not Export Fields from Live Queries Properly If the Fields Are Calculated

When issueing the ExportTable method of the TDBISAMQuery component, and concatenating 2 fields in the Select statement, that field value always gets exported as an empty string, even though the concatenated fields value does show up when you do a MessageBox on the Field.

g_DB.SQL.Text := 
'SELECT LastName + ", " + FirstName AS Name FROM 
tblEmployees';
g_DB.Open;
//the message box shows the concantenated value
MessageBox(0,pchar(g_db.Fields[1].AsString),'test',0);
//the following resulting file contains no value
g_db.ExportTable('Data\' + sTable + '.lst','|');



Resolution Resolution
Fixed Problem on 12/5/2002 in version 3.21 build 1
Image