FIXED: Bug in subselects // FIXED, bug with ObjectPtr

[Ruslan Zasukhin]

on 7/25/03 21:05, Kurt Klamp at K.Klamp at t-online.de wrote:

Hi Kurt,

FIXED !!!!

Thank you very much for this bug report. IT was very bad bug.
Problem could come when we have sub-selects or may be even 2 cursors in the
same time that have TMP table.

I will build new VAPP Carbon for you now.

> Ruslan Zasukhin wrote at 23.07.2003 18:40 Uhr
> 
>>> Sorry Ruslan,
>>> 
>>> no changes. The following Sql statement gives the right result only after
>>> 6-12 trials -or- direct after reindexing the database(opening with
>>> trashed *.ind file)
>>> 
>>> select sum(BuchungsWert) from InvBuchungen WHERE BuchDatum in (select
>>> max(BuchDatum) from  InvBuchungen GROUP BY InvPtr)
>> 
>> Okay.
>> 
>> 1) Can you send me DB that produce wrong results?
>> I hope it is not huge
>> 
>> 2) AS script that open db and do this query
>> 
> 
> 
> Here it is : db and script
> 
> open result  and event window in script editor and run the script.
> remember to open the db 'P_daten' forst before calling script.
> 
> on my side there is always a similar behavior.  The right result comes
> after about 4-8 calls of the script and then normaly coming right results
> afterwards, but it can be that after the first right result the next call
> will bring a wrong one again.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------