CODEWITHSUNDEEP
sqldatabasedelphiinterbase
user287161
user287161

Reputation:

Interbase XE3 Developer Edition doesn't save data

First I tried to execute simple INSERT request using IBX and FIBPlus, the query worked out but I couldn't find the record in the database. Then I made the same request using IBExpert executed request showed in the grid but after I reconnected to the database the record wasn't there. All the transactions were commited. (Windows 7, Interbase XE3 Developer Edition )

Code:

Query.Transaction.StartTransaction;
Query.SQL.Text :=
'insert into GT_AIRCRAFTSTATUS (MAINTTRACKKEY, KEY_NO, SN) values (:MAINTTRACKKEY,:KEY_NO,:SN)';
Query.ParamByName('MAINTTRACKKEY').AsInteger := 2;
Query.ParamByName('KEY_NO').AsString := 'ccc';
Query.ParamByName('SN').AsString := 'bbb';
Query.Prepare;
Query.ExecSQL;
IBSQLMonitor.OnSQL := TrackSql;
Query.Transaction.Commit;

IBSQLMonitor output:

[Application: Project6]
IBTransaction1: [Start transaction]

[Application: Project6]
Query: [Prepare] insert into GT_AIRCRAFTSTATUS (MAINTTRACKKEY, KEY_NO, SN) values (:MAINTTRACKKEY,:KEY_NO,:SN)

Plan: 

[Application: Project6]
Query: [Execute] insert into GT_AIRCRAFTSTATUS (MAINTTRACKKEY, KEY_NO, SN) values (:MAINTTRACKKEY,:KEY_NO,:SN)

MAINTTRACKKEY = 2
KEY_NO = ccc
SN = bbb

[Application: Project6]
IBTransaction1: [Commit (Hard commit)]

Is it a bug in the Developer Edition?

Upvotes: 0

Views: 180

Answers (1)

user287161
user287161

Reputation:

The table was a temporary table. When I last used Interbase/Firbird temporary tables weren't supported by these servers.

Upvotes: 0

Related Questions