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
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.
