Page 1 of 1
.recordcount invalid, when the query has too long record
Posted: Tue 24 Jun 2014 14:05
by Ludek
delphi xe6 (both 32 and 64bit), newest sdac 6.10.20 (it happens also with .19)
steps:
1. create tmsquery with following sql text:
Code: Select all
with a as (
select
cast('' as varchar(255)) a,
cast('' as varchar(255)) b,
cast('' as varchar(255)) c,
cast('' as varchar(255)) d,
cast('' as varchar(255)) e,
cast('' as varchar(255)) f,
cast('' as varchar(255)) g,
cast('' as varchar(255)) h,
cast('' as varchar(255)) i,
cast('' as varchar(255)) j,
cast('' as varchar(255)) k,
cast('' as varchar(255)) l,
cast('' as varchar(255)) m,
cast('' as varchar(255)) n,
cast('' as varchar(255)) o,
cast('' as varchar(255)) p,
cast('' as varchar(255)) q,
cast('' as varchar(255)) r,
cast('' as varchar(255)) s,
cast('' as varchar(255)) t,
cast('' as varchar(255)) u,
cast('' as varchar(255)) v,
cast('' as varchar(255)) w,
cast('' as varchar(255)) x,
cast('' as varchar(255)) y,
cast('' as varchar(255)) z
)
select * from
a a,
a b,
a c,
a d,
a e,
a f,
a g,
a h,
a i,
a j,
a k,
a l,
a m,
a n,
a o,
a p,
a q,
a r,
a s,
a t,
a u,
a v,
a w,
a x,
a y,
a z,
sysobjects so
2. open it
3. examine the msquery.recordcount value
you'll get the number 5, although the query contains much more rows...
what can i do to get rid of this incorrect behavior?
Thanks, Ludek.
Re: .recordcount invalid, when the query has too long record
Posted: Tue 24 Jun 2014 14:16
by Ludek
note: sdac 5.00.0.5 & delphi XE does NOT suffer from this bug. It is something new...
Re: .recordcount invalid, when the query has too long record
Posted: Wed 25 Jun 2014 14:27
by azyk
Thank you for the information. We have reproduced this problem and fixed it. This fix will be included in the next SDAC build.
Re: .recordcount invalid, when the query has too long record
Posted: Wed 25 Jun 2014 15:28
by Ludek
stupid question as always: when does this version come? if it is more than a week, would you mind telling us the fix in the 6.10.20 sources? (some line number & new version of the line?) i would be so happy
Re: .recordcount invalid, when the query has too long record
Posted: Thu 26 Jun 2014 14:10
by LHSoft
same interest, theme "TMSLoader unspecified Error"
would be glad if bugfixes comming soon.
Hans
Re: .recordcount invalid, when the query has too long record
Posted: Fri 27 Jun 2014 15:44
by azyk
Ludek wrote:stupid question as always: when does this version come? if it is more than a week, would you mind telling us the fix in the 6.10.20 sources? (some line number & new version of the line?) i would be so happy
LHSoft wrote:same interest, theme "TMSLoader unspecified Error"
would be glad if bugfixes comming soon.
Hans
If you want to get this fix, provide your e-mail address and license number to andreyz*devart*com and we will send you a custom build.
Re: .recordcount invalid, when the query has too long record
Posted: Fri 04 Jul 2014 12:09
by Ludek
My colleague responsible for licensing products sent you an email 2.7. and today again, still without any response at all?!
Re: .recordcount invalid, when the query has too long record
Posted: Fri 04 Jul 2014 14:10
by azyk
I haven't received these letters in my e-mail (I have checked spam too). Please provide your e-mail address and license number via our contact form
http://www.devart.com/company/contactform.html
Re: .recordcount invalid, when the query has too long record
Posted: Mon 07 Jul 2014 06:18
by Ludek
email sent last week also to
[email protected], also no reply? contact form needs logging in and does not know any of possible emails, that we possibly used to register (it is already a long time ago, that the first sdac version was bought, perhaps registration info was lost?)
Re: .recordcount invalid, when the query has too long record
Posted: Tue 08 Jul 2014 10:18
by azyk
Please specify the e-mail address from which you sent the letter.
Re: .recordcount invalid, when the query has too long record
Posted: Fri 11 Jul 2014 08:18
by Ludek
We got reply, that our subscription already expired. have renewed, again asked for this version (already 2 days ago), until now no reply again
Re: .recordcount invalid, when the query has too long record
Posted: Tue 15 Jul 2014 07:51
by Ludek
still no reply
Re: .recordcount invalid, when the query has too long record
Posted: Wed 16 Jul 2014 10:21
by azyk
We sent a custom build to your email.
Re: .recordcount invalid, when the query has too long record
Posted: Thu 17 Jul 2014 07:59
by Ludek
Thank you very much!