Devart Forums

I just updated to 3.5.0.12 and I am now getting an Ora Error "No Data Found" being return from one of my TUniQuery's.
Steps Taken within development environment (Enable Session in Codegear XE c++ designer. Open Query and Execute.)
1) Execute Query as is. - This results in no data found error
2) Remove one field from the query (it does not matter which one) - This works without error
3) Do a NVL on one of the fields in the query and return 3 spaces. - This works for some of the records the original query did not work for but not all. (ex. NVL(Field, ' '))

My Query is below. I can not get a concrete example to send because it seems to not be consistent.

SELECT ITEMID
,MAX(ITEMDESC) ITEMDESC, GTIN, SUM(PQTY) PQTY, MAX(VALADD) VALADD, UPC, SUM(GQTY) GQTY, SUM(AUDQTY) AUDQTY, MAX(PICKLINE) PICKLINE
,MAX(GMFLAG) GMFLAG, MAX(CPCNV) CPCNV, SUM(AQTY) AQTY, MAX(PICKLOC) PICKLOC
,MAX(SHELF_PACK) SHELF_PACK
,MAX(BKWHO) BKWHO
FROM ITEM
WHERE
CRTNO = :cartNum
GROUP BY ITEMID, GTIN, UPC
ORDER BY VALADD


This is an issue that has only come up in the migration to Unidac 3.50.0.12. Has something changed in that version that would cause this issue? I am ruling out a programming error because I am running the query in the Codegear IDE without any of my program running. Also this same query runs fine when I put it into the ora developer sutdio and run it.

Any help would be appreciated. I know the explanation is not the clearest, but honestly the problem is very strange and hard to explain. Could this be a unicode issue in devart that Codegear XE Enforces? What differences in this version would be causing this issue as it has worked fine in previous issues?

Thanks

Hello,

I can not reproduce the problem.
Your example query executed without error. Please send a script to create the table and tell me which mode did you use to connect to the database - direct or OCI mode.

I am using direct mode. I have sent an email with an oracle export file to [email protected].

The query you can use is:
SELECT ITEMID ,MAX(SUBSTR(ITEMDESC,1,35)) ITEMDESC, MAX(GTIN) GTIN, SUM(PQTY) PQTY,
MAX(VALADD) VALADD, MAX(UPC) UPC,
SUM(GQTY) GQTY, SUM(AUDQTY) AUDQTY, MAX(PICKLINE) PICKLINE,
MAX(GMFLAG) GMFLAG, MAX(CPCNV) CPCNV, SUM(AQTY) AQTY, MAX(PICKLOC) PICKLOC
,MAX(SHELF_PACK) SHELF_PACK
, MAX(BKWHO) BKWHO
FROM ITEM WHERE CRTNO = :cartNum
GROUP BY ITEMID
ORDER BY VALADD

Use for :cartNum: 00000316553088448229

Hello,

Unfortunately we have not received your mail, please send it again to alexp*devart*com

Hello,

We have fixed this bug
This fix will be include in the next build of UniDAC.
If you want we can send you the the fixed *.dcu files, please specify your IDE version and email address.

Codegear XE Rad Studio
[email protected]

I will also need directions on how to install.

Just curious, What was the issue?

Hello

I sent the fix for Delphi XE by E-mail.

I do not know how to install this dcu. I have tried to copy it to the directory that the previous one was installed in but that did not do it. I assume I need to re compile? I do not have source code.


Please provide with directions on how to install this dcu update into rad studio xe

Hello,

You should to put the *.dcu files into the ..\Devart\UniDac for Delphi 7\Lib\ folder.

But this fix will work only in the run-time mode, in design-time you will get the same error. It will be fix in the next UniDAC build.

This did not fix the probelm. I have included the query I am running again as well as emailed the oracle export file to [email protected] again.
I am getting the same no data found error when I try to execute this query on the database.
I am using Rad Studio XE (c++ personality). I have tested at both design and run time. Please fix and send me another DCU to [email protected]

Hello,

If changing *.dcu files doesn't help, you have to wait for the official release of the new build.
We plan release it this week.

I do not see a new version has been released. When is this update to be released.

Hello,

There were some problems, that's why the new release will be available this week.