Hi,
i=B4ve some really strange problems with the following prepared statement=
=2E
LET l_query =3D "
select code, sum(t_flaeche.flaeche)
from t_flur, t_flaeche
wheret_flur.onr =3D ? and
t_flur.nr_fmass =3D ? and
#t_flur.land_kz =3D ? and
t_flaeche.onr =3D t_flur.onr and
t_flaeche.nr_fmass =3D t_flur.nr_fmass and
t_flaeche.nr_flur =3D t_flur.lfdnr
group by code
order by code"
PREPARE sc_code FROM l_query
DECLARE q_code CURSOR FOR sc_code =
When i use the statement in this form (the land_kz condition not
active), i can open the cursor as much times i like and fetch data.
If i activate the extra condition and open the cursor for the second
time and make the first fetch, i got an error -270 (Cannot position
within temporary file). =
This doesn=B4t happen if i remove the SUM and GROUP BY parts of the
statements. It also doesn=B4t happen i doesn=B4t prepare the statement.
But why should the above doesn=B4t work with a prepared statement. Is it =
a
known bug?
We=B4re running an Online 5.0x engine with 4.1 clients.
Greetings, Joerg