Major bug with TField that crashes application

XE8 has a very serious bug that was not in XE5 and it's pretty easy to duplicate:

Add a TADOQuery to a form, connect it to a database, and access TField in some way, e.g. using AsString:

   SQL.Clear;
   SQL.Add('select top 1 * from aTable');
   Open;
   for i:=0 to FieldList.Count-1 do
      Memo1.Lines.Add(FieldList.Fields[i].AsString);
   Close;

Then close the application and an EExternalException will crash the application.

This will prevent me from using XE8 completely. Anyone have a fix?

Bruce
0
Bruce
6/5/2015 6:03:32 PM
embarcadero.delphi.ado 597 articles. 1 followers. Follow

10 Replies
1100 Views

Similar Articles

[PageSpeed] 45

Note that the place to report bugs is the quality portal at 
http://quality.embarcadero.com.

Bruce H wrote:
> XE8 has a very serious bug that was not in XE5 and it's pretty easy to duplicate:
>
> Add a TADOQuery to a form, connect it to a database, and access TField in some way, e.g. using AsString:
>
>     SQL.Clear;
>     SQL.Add('select top 1 * from aTable');
>     Open;
>     for i:=0 to FieldList.Count-1 do
>        Memo1.Lines.Add(FieldList.Fields[i].AsString);
>     Close;
>
> Then close the application and an EExternalException will crash the application.
>
> This will prevent me from using XE8 completely. Anyone have a fix?
>
> Bruce
>
0
quinn
6/5/2015 6:08:01 PM
Tried, but my EDN credentials don't work. Had to use the old Quality Central, is report 131888.

> {quote:title=quinn wildman wrote:}{quote}
> Note that the place to report bugs is the quality portal at 
> http://quality.embarcadero.com.
>
0
Bruce
6/5/2015 11:27:58 PM
Could you please provide additionally:
- your table DDL
- your SQL Server provide name (or connection string)

-- 
With best regards,
Dmitry Arefiev / FireDAC Architect
0
Dmitry
6/6/2015 7:41:21 AM
> {quote:title=Dmitry Arefiev wrote:}{quote}
> Could you please provide additionally:
> - your table DDL
> - your SQL Server provide name (or connection string)
> 
> -- 
> With best regards,
> Dmitry Arefiev / FireDAC Architect
0
Bruce
6/8/2015 4:09:52 PM
This happens with ADO (not FDConnection nor DBX to SQL Server). Note also that XE5 works fine. I don't have XE6 or XE7.

Connection string: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Analytics;Data Source=Server34

A table DDL that throws the error:


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Assays](
	[Test] [varchar](100) NOT NULL,
	[DT_Created] [datetime] NOT NULL CONSTRAINT [DF__Assays__DT_Creat__55F4C372]  DEFAULT (getdate()),
	[DT_Modified] [datetime] NOT NULL CONSTRAINT [DF__Assays__DT_Modif__56E8E7AB]  DEFAULT (getdate()),
	[DT_Inactive] [datetime] NULL,
	[User_Created] [varchar](10) NOT NULL CONSTRAINT [DF__Assays__User_Cre__57DD0BE4],
	[Long_Name] [varchar](255) NULL,
	[Description] [varchar](255) NULL,
	[Narrative] [varchar](255) NULL,
	[Screen] [bit] NOT NULL CONSTRAINT [DF__Assays__Screen__58D1301D]  DEFAULT (0),
	[Confirmation_Test] [varchar](30) NULL,
	[Lead_Time] [varchar](30) NULL,
	[Prior_Supv_Review] [bit] NOT NULL CONSTRAINT [DF__Assays__Prior_Su__59C55456]  DEFAULT (0),
	[Tech_Review_Req] [bit] NOT NULL CONSTRAINT [DF__Assays__Tech_Rev__5AB9788F]  DEFAULT (0),
	[Admin_Review_Req] [bit] NOT NULL CONSTRAINT [DF__Assays__Admin_Re__5BAD9CC8]  DEFAULT (0),
	[Analytic_Hours] [float] NULL,
	[AutoInc] [int] IDENTITY(1,1) NOT NULL,
	[Stamp] [timestamp] NOT NULL,
	[Include_In_TAT_Stats] [bit] NOT NULL CONSTRAINT [DF_Assays_Include_In_Stats]  DEFAULT (1),
	[Max_Number_Scheduled_At_Once] [tinyint] NOT NULL CONSTRAINT [DF_Assays_Max_Number_Scheduled_At_Once]  DEFAULT ((1)),
 CONSTRAINT [PK__Assays__55009F39] PRIMARY KEY CLUSTERED 
(
	[Test] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


> {quote:title=Dmitry Arefiev wrote:}{quote}
> Could you please provide additionally:
> - your table DDL
> - your SQL Server provide name (or connection string)
> 
> -- 
> With best regards,
> Dmitry Arefiev / FireDAC Architect
0
Bruce
6/8/2015 4:17:10 PM
It may have something to do with the timestamp field. On some of my other tables (they all have timestamps) the error doesn't occur, and it does occur on other tables. I created another table with the same DDL just posted and the error occurs. If I delete the timestamp field the IDE crash does NOT occur anymore.

Note that you have to have data in the table (an empty table will not throw the error), and you must access the <field>.AsString property.

Bruce

> {quote:title=Bruce H wrote:}{quote}
> > {quote:title=Dmitry Arefiev wrote:}{quote}
> > Could you please provide additionally:
> > - your table DDL
> > - your SQL Server provide name (or connection string)
> > 
> > -- 
> > With best regards,
> > Dmitry Arefiev / FireDAC Architect
0
Bruce
6/8/2015 4:39:06 PM
Thank you for reporting. This is XE8 regression bug. It is fixed now.

If you like to apply patch then do:
- download dbbitconv.pas from there https://forums.embarcadero.com/thread.jspa?threadID=115788&tstart=0
- open Data.DB.pas in editor
- locate there TDBBitConverter methods implementations
- replace them with the dbbitconv.pas content
- save Data.DB.pas
- add path to Data.DB.pas to your IDE Library Path
- recompile and test your application

-- 
With best regards,
Dmitry Arefiev / FireDAC Architect
0
Dmitry
6/9/2015 6:45:28 PM
now that's great support right there ;)
0
Brian
6/10/2015 4:13:34 AM
Agreed! My thanks to Dmitry.

Bruce

> {quote:title=Brian Hamilton Hamilton wrote:}{quote}
> now that's great support right there ;)
0
Bruce
6/10/2015 7:45:43 PM
The fix works. I had to copy the Data.ADODB.pas file as well, and both compile as .dcu files with the project, but working now, thanks.

Bruce
0
Bruce
6/10/2015 10:02:35 PM
Reply:

Similar Artilces:

RE: Major bug with TField that crashes application
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --JivePart=_ab501.zeB8CwDOH5aMJzMl Content-Type: text/plain; charset="Utf-8" -- -- With best regards, Dmitry Arefiev / FireDAC Architect --JivePart=_ab501.zeB8CwDOH5aMJzMl Content-Type: application/octet-stream; name="dbbitconv.pas" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="dbbitconv.pas" eyBUREJCaXRDb252ZXJ0ZXIgfQ0KDQpjbGFzcyBwcm9jZWR1cmUgVERCQml0Q29udmVydGVyLklu dGVyb...

crash crash crash crash CRASH
Name: Pete VANHEE Email: vanhee Product: Firefox Summary: crash crash crash crash CRASH Comments: please how can I get my old Firefox browser back ? I can't work like this; 3.0 crashes several times a day; it's bloody annoying Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.9) Gecko/2008052906 Firefox/3.0 From URL: http://hendrix.mozilla.org/ ...

Crash, crash, crash, crash, crash...
Name: Product: Firefox Summary: Crash, crash, crash, crash, crash... Comments: All versions I've tried since 3.0 are crash happy, on both Windows & Mac. This latest 3.6.13 for Mac OS X is no exception, it's like running alphaware. Just access http://www.blogdelnarco.com (among many others), and within 2-3 seconds she goes Tango Unicorn and dumps you at the desktop. I used to love FF and recommended it to all, but no longer. Really it isn't worth the trouble. What follows is the crash report sent to Apple: Process: firefox-bin [19988] Path: ...

a bug report in my application (Delphi)
Generally required to implement a bug report (such as Opera, Firefox) in your application, can somebody tell me how to implement this method, or anyone to share a reference for the implementation of this method would be very grateful. ...

Crashing, Crashing, Crashing, ....and more Crashing
Name: Dale Email: davidsdaleatgmaildotcom Product: Firefox Summary: Crashing, Crashing, Crashing, ....and more Crashing Comments: To whom it may concern: Please explain to me why does your product crashes so much. Please dont tell me it is my hardware or software. Besides for that, This is one of the best products You can get. I dont want to depart from it. Please help. Thank you in advanced, for your reply. Kind regards -Dale. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1b3) Gecko/20090305 Firefox/3.1b3 From URL: http://hendrix.mozilla.or...

Convert Delphi 5 ADO App to Delphi 2007 ADO.NET
I have an appliction tha that is writen in Delphi 5 with ADOConnetion, ADOTable, and ADOQuery components. I need to upgrade to Delphi 2007 and use ADO.NET. I have the program building in with Delphi 2007. Is there anything I need to do to convert the ADO to ADO.NET? > I need to upgrade to Delphi 2007 and use ADO.NET. Why ? -- With best regards, Dmitry Arefiev AnyDAC (www.anydac.com) - Oracle, MS SQL Server, IBM DB2, MySQL, Firebird, Interbase, PostgreSQL, Sybase ASA, SQLite, MS Access, DBX, ODBC, InMem - universal high-speed native data access engine Reasons for ...

MOVED: random (opendialog.onhint) crash ,delphi (was: random (opendialog.onhint) crash ,delphi)
On Sat, 24 Jan 2009 09:23:32 -0800, arthur gibbs wrote: Moved to delphi.vcl.components.using https://forums.codegear.com/thread.jspa?threadID=10897 -- Marc Rohloff [TeamB] marc -at- marc rohloff -dot- com ...

MAJOR MAJOR MAJOR BUG IN VISUAL STUDIO.NET 2005
Okay this is BIG!!! Visual Studio.NET 2005 does not only have problems in its editor but also in the whole build system. Check out this: Here is my directory structure. UserPages (Folder) contains AddPost.aspx, AddReply.aspxDefault.aspx Login.aspx BasePage.aspx AddPost.aspx and AddReply.aspx both inherits from BasePage.aspx. AddPost looks something like this: public partial class AddNewPost : BasePage Now everything is working cool!! I build the application with no problem. I rebuild it no problems. I rebuild the website no problem. I was happy !! :) Now I start adding some lines in web.conf...

bugs, bugs, and more bugs..
Name: Michael Email: michaelatthemessengerdotcomdotua Product: Firefox Summary: bugs, bugs, and more bugs.. Comments: Your browser is really headed downhill fast!!! Do any of you techies realize there is a segment of the normal world that just wants to use a program for a year or two without changes??? I couldn't give a crap if it has a few holes, I just want it to work normally. I realize I need to upgrade from time to time (once a year is more than normal enough), but every month or two is just plain stupid. It's extremely difficult not to upgrade Mozilla, it...

Delphi XE7 Bug breaks ISAPI applications
If you are developing ISAPI IntraWeb applications with Delphil XE7 you MUST read this: http://atozed.com/IntraWeb/Blog/20141010.EN.aspx We already have a workaround ready (our own TUTF8ContentParser descendant). We should release a fix soon. Best regards ...

Crashing, crashing and more crashing
Name: Dang Email: dangguyatgmaildotcom Product: Firefox Summary: Crashing, crashing and more crashing Comments: Since I have upgraded to 3.5.2 firefox keeps crashing. I have read the forums and have read some of mozillas responses. This is a problem with the application not my pc and to suggest otherwise is disingenuous and insulting. I can use chrome with out any problems. I prefer firefox which I have used for several years. My advice is fix the latest version don't blame it on the users. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.2) Ge...

Bug Bug Bug!...
With the 2.0.0.13 and 4 tabs opened firefox crashes... or when a page is loading and clic on any link it crashes... i can't obtain a log or trace or something to give you for debug... ...

BUG BUG BUG
Name: Vinecnt Tartar Email: maelwyssatwanadoodotfr Product: Firefox Summary: BUG BUG BUG Comments: It crashes every two hours, always bloquing everything, after several weeks believing and praying for a quick fixing of this bug, I'm now desperate, shame on youo firefox, I use google chrome, lame... Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/1.0.154.48 Safari/525.19 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wish to ...

Bugs...bugs and more bugs
Hi all, We are currently running PB 7.2 build 8046. We have been unable to move to higher build versions since everytime we find new issues that cause us to go back to 8046. Two weeks ago, we installed the latest EBF bug fix version for PB 7.3 (build 10180). After preliminary tests, it seemed that everything is working fine.... finaly!! Well, today, we found that in two of our more complex datawindows, we get GPF (general protection fault) upon saving or regeneration. These datawindows contain both blob objects as well as nested reports. However, if you remove either t...

Web resources about - Major bug with TField that crashes application - embarcadero.delphi.ado

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

The Bachelor 2016 application process can get explicit - Laurina Fleure
CHANNEL Ten is calling on singles to sign up for a chance to find love on The Bachelor , but willing applicants have to open a lot more than ...

How to enable Potentially Unwanted Application protection in Windows 8 and Windows 10
... looking for ways to protect their systems, and Microsoft recently unveiled a new opt-in feature to protect against Potentially Unwanted Applications ...

Gun Sales, Concealed Permit Applications Surge After San Bernardino
The day after Syed Farook and Tashfeen Malik opened fire in San Bernardino, gun sales and concealed carry permit applications surged.

MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey, Purchase Applications up 24% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Surve Mortgage applications decreased 3.2 percent from one week earlier, according ...

Mortgage applications down 0.2%
Mortgage interest rates haven't moved much in the past three weeks, but they are holding at a higher level than for all of 2015.

LED market saturation to drive industry to seek profits in new applications in 2016, says LEDinside
According to LEDinside, LED makers had an especially tough year in 2015. "Despite rising LED lighting market demand and the large scale replacement ...

Six internet-of-things applications in big new government trial
Manchester, England, is set to be the UK demonstrator city for internet-of-things innovation. Of course, there is much smart technology already ...

Windows 10’s broken fall update removes user-installed applications without asking first
Microsoft's latest Windows 10 update is causing problems for at least some users, and uninstalling programs without the user's consent or evidence ...

The 3 Things That Can Happen With Your Early College Application
... Decision to wait as patiently as they can for the next two weeks as email inboxes and snail mail slots fill with the results of all those applications. ...

Resources last updated: 12/7/2015 10:09:28 PM