sql empty lines removed, don't know if odac or xe8 is to blame

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

sql empty lines removed, don't know if odac or xe8 is to blame

Post by albourgz » Wed 01 Jul 2015 15:04

Design-time bug.
Using c++ builder xe8 pro Update pack 1 ( 22.0.19908.869) on win 7 64 bits, vcl app, odac 9.5.16 .
I have a TQuery, I type any select in SQL property, and append a few empty lines at the end, click ok.

I edit the SQL property: my empty lines are removed.
Problematic as the application does;

Code: Select all

QInventory->SQL->Strings[6]="/* some where criteria */";
but there are now only 4 lines to SQL. So I get a List Index Out Of Bounds.

Is this due to ODAC or XE8?
If due to ODAC, can I get a fix?
If due to XE8, can you ask a fix to embarcadero?

Regards.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: sql empty lines removed, don't know if odac or xe8 is to blame

Post by AlexP » Thu 02 Jul 2015 08:41

Hello,

Thank you, we will change this behavior. In the next version, even empty strings specified in design time will be saved.

albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

Re: sql empty lines removed, don't know if odac or xe8 is to blame

Post by albourgz » Thu 02 Jul 2015 08:58

Do you have any date? Application has to be live on August 1st.
I don't know yet if it will be xe6 or xe8 (depending on patches availability).

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: sql empty lines removed, don't know if odac or xe8 is to blame

Post by AlexP » Thu 02 Jul 2015 09:33

The version with this fix will be released in the early September. If this problem is critical for you, we can send you a night build with the fix included.

albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

Re: sql empty lines removed, don't know if odac or xe8 is to blame

Post by albourgz » Thu 02 Jul 2015 11:33

yes please.
This is very dangerous as it changes properties at design-time without any notice.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: sql empty lines removed, don't know if odac or xe8 is to blame

Post by AlexP » Thu 02 Jul 2015 12:07

Please send to alexp*devar*com the license number and an e-mail address where I can send you the fixed version, also specify the used IDE

Post Reply