Since updated to 2.02b1 I've this strange behaviour.

C/S
View  vwMeses: SELECT  Ano,  Mes,  SUM(TotalDia) AS HorasMes FROM
GPMESPLN GROUP BY  Ano, Mes ORDER BY  Ano, Mes

In client, this view acts as a Master (using TDataSource) to a query
over  GPMESPLN.

When view vwMeses has just one record, this occurs:

vwMeses.Refresh;
if not vwMeses.Locate( ... ) then
 vwMeses.Last
;

Then all fields from vwMeses are NULL
This not occurs is vwMeses has more than one row

Workaround is making another vwMeses.Refresh after Last

Before 2.02b1 this code worked ok.


Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.

Tiago,

I have a problem here with 2.02 and (some, not all) fields becoming null in Report Builder
Preview, haven't narrowed it further down, but seems to apply only with queries with one row.

At the moment it looks like that my problem occurs only in C/S mode, if I run the same
report with the same data in filesharing mode, it works.

I'm curious...have you tried it in filesharing mode ? Does it work then ?

Heiko

Tiago,

<< In client, this view acts as a Master (using TDataSource) to a query over
GPMESPLN.

When view vwMeses has just one record, this occurs:

vwMeses.Refresh;
if not vwMeses.Locate( ... ) then
 vwMeses.Last
;

Then all fields from vwMeses are NULL
This not occurs is vwMeses has more than one row >>

Please send me the database catalog that you're using along with a short
code snippet.  I will check it out and let you know what I find.  There was
one change in 2.02 regarding this, and it was this:

http://www.elevatesoft.com/incident?action=viewaddr&category=edb&release=2.02&type=f&incident=2815

So, it's possible that there may have been a side-effect from this change.

--
Tim Young
Elevate Software
www.elevatesoft.com

Heiko,

>I'm curious...have you tried it in filesharing mode ? Does it work then ?

I haven't test it in F/S, but after some testing in C/S I can say is a
2.02 bug.

Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.

Tim,

>Please send me the database catalog that you're using along with a short
>code snippet.  

See at your mail box

Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.

Tiago,

<< See at your mail box >>

Got it, thanks.  I've fixed this and a fix will be in the next build (2.02
B2).

--
Tim Young
Elevate Software
www.elevatesoft.com