InterBase Express 12 [Delphi 2009] Catastrofic Error
Marcelo Colonna Rosman
I am using Delphi 2007 for Win32 and Delphi 2009 for Win32.
I have installed the InterBase 2007 Developer Edition and the
InterBase 2009 Developer Edition.
I am developing an database application using the following InterBase
Express components:
TIBDatabase
TIBTransaction
TIBDataSet
The problem only occurs on Delphi 2009 with InterBase Express 12,12
components
Everything works fine on Delphi 2007 with InterBase Express 11,11
components.
The same problem occurs if i use InterBase 2007 Developer Edition or
InterBase 2009 Developer Edition.
:: Components Configuration ::
======================
I have configured IBDatabase, IBTransaction and IBDataSet as usual:
IBDatabase.Databasename = mcr-pentium4/ib2007:D:\Database\SisCon\IBData
\DBSisCon.IB
IBDatabase.DefaultTransaction = IBTransaction
IBDatabase.Params with: user_name=sysdba
password=masterkey
lc_ctype=ISO8859_1
IBTransaction.DefaultDatabase = IBDatabase
IBTransaction.AllowAutoStartUp = True
IBTranscation.AutoStopAction = saNone
IBTranscation.DefaultAction = TACommint
IBDataSet.Database = IBDatabase
IBDataSet.Transaction = IBTransaction
IBDataSet.SelectSQL = select * from Usuario
Note: Usuario is the name of one of the tables of the database file.
Problem:
======
When I execute the Dataset Editor of the IBDataSet component an
exception error is raised with the following message:
"Unable to determine field names for IBDataSet."
After that the Dataset Editor of the IBDataset is opened.
When I click on the [Get Table Fields] button all the fields are
listed on the Key Fields column of the Dataset Editor.
When I click on the [Dataset Defaults] button the same error message
above is displayed again.
When I click on the [Select Primary keys] button the primary key of
the table is selected.
When I click on the [Generate SQL] button the same error message above
is displayed again and then the SQL instructions are generated without
any error.
This error happens with any table of the database file.
When I open the 'Fields Editor' of the IBDataset and execute the "Add
All Fields" command the following exception error message is
displayed:
"Dynamic SQL error
SQl error code = - 104
token unkown on line -2 char -1
from."
When I set IBDataset.Active = 'True' the same error message above is
displayed again.
I have tried to use IBQuery in place of IBDataSet and the same problem
occurred.
Because of that catastrofic error I returned to Delphi 2007 and opened
the same project on Delphi 2007 for Win32 and that error did not
happened. Everything worked fine.
These errors only occurs on Delphi 2009 for Win32.
Thanks for any help.
Best regards,
Marcelo Rosman