Watch, Follow, &
Connect with Us
Public Report
Report From: Delphi-BCB/AddOn/Interbase components    [ Add a report in this area ]  
Report #:  96197   Status: Closed
cannot insert record into Global Temporary Table for the first time within a connection
Project:  Delphi Build #:  IB 10.0.2.474
Version:    15.1 Submitted By:   Teruyuki Nakayama
Report Type:  Crash / Data loss / Total failure Date Reported:  7/14/2011 12:15:03 AM
Severity:    Commonly encountered problem Last Updated: 4/29/2013 5:59:11 PM
Platform:    All platforms Internal Tracking #:   284886
Resolution: Fixed (Resolution Comments) Resolved in Build: : IB 11.0.2.540
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: 8
Description
Inserting records into global temporary table using IBX components fails with no error. But it fails first time only after you connect db. After it fails, it works fine until you logout the db..

Seems it doesn't happen with ISQL or DBX.

I am using Delphi XE with all the updates available.


Steps to Reproduce:
1. create a global temporary table
2. insert some records into the table created in step1.
3. browse the table.

A sample project is attached.
Workarounds
None
Attachment
Project1.dproj.zip
Comments

Tomohiro Takahashi at 7/14/2011 5:13:05 AM -
> ... using IBX components  ... Seems it doesn't happen with ISQL or DBX.
Is this issue about IBExpress components which comes with Delphi?
And, what version of Delphi do you use?

Teruyuki Nakayama at 7/14/2011 6:01:05 AM -
I am using Delphi XE with all the updates available.

Tomohiro Takahashi at 7/14/2011 7:28:43 PM -
Teruyuki-san
If you need quick help, could you please contact technical support service? Sorry for inconvenience.
http://support.embarcadero.com/

Teruyuki Nakayama at 7/19/2011 10:20:06 PM -
I have switched to dbx for now and I'm OK now. Thanks.
But I still hope this issue gets fixed asap.

Tomohiro Takahashi at 7/14/2011 5:04:50 PM -
ok, I changed [Project], [Version] and [Area] field as Sysop.

Tomohiro Takahashi at 4/29/2013 6:02:47 PM -
This issue is fixed with InterBase XE3 Update 2(11.0.2.540).
[Fixed bug >> INTB-1806]
http://docs.embarcadero.com/products/interbase/IBXE3Update2_JP/Readme_ja.html#new00E

Server Response from: ETNACODE01