on 5/30/01 23:16, Keith DeLong at delong At redcort .DO.T com wrote:
> Ruslan,
> Here's the steps to duplicate my corruption on the attached data:
>
> 1. Open Valentina and open the attached data file
> 2. Mark records 2-4 of the timecards table
> 3. Delete the marked records
> 4. Quit Valentina
>
> 5. Open ViSQL (I'm using PPC 1.1a15) and open the data file
> 6. SELECT * FROM Employees WHERE TimeCardPtr = 0
>
> Even though the second record's TimeCardPtr was SetNull by the delete, the
> SELECT will not return any records.
>
> Delete the Index and open ViSQL then run the SELECT again - viola!, you get
> a proper record set.
>
> I hope this helps!
Hi Keith,
well it seems this was "OLD" bug.
it happens if you delete a record which has many related to it by ObjectPtr
records of table B, in fact > 30% of records of table B.
yes, this is very bad bug so I am going in nearest time update all products.
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on At lists .DO.T macserve.net
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2001 Ruslan Zasukhin |
