REALLY strange bug.

[Ruslan Zasukhin]

On 7/14/04 7:49 AM, "Deane Venske" <deane.venske at eduss.com> wrote:

> Hi guys,
> 
> Well this one had me going all day...
> 
> I have a DB with a large amount of users, let's just say the user and
> userDetails table.

> Now I have a list box I select users from then do a mass deletion.

> I'm basically getting each ID to be deleted and executing the following:
> DELETE FROM user WHERE userID = xxx
> flush db
> DELETE FROM userDetails WHERE userID = xxx
> flush db

In fact you can be more effective with

    DELETE FROM T WHERE userID in (id1, id2, id3, ....)

Single command to server


> At the end, whether I started with 1000 users or 500 users the records
> from userID 223 to 255 (I don't delete userID 1) do not get deleted and
> are in fact then not able to be removed from the DB using SQL. Even in
> studio. 

May be you have some kind of RESTRICT for links on that table

> I can delete the user from the data browser, or if I user "DELETE
> FROM user" without a WHERE clause.

> Can't even see the data with a SELECT *
> FROM user WHERE userID = 223 query. BUT can see data with a SELECT * FROM
> user query.

It looks to be some problems with db.
Have you diagnose it ?

> If I delete the first 200 users then CLOSE my application, close any
> connections to the DB then open it again and try delete the next 200 users
> it only gets through the first 32.
> 
> V Studio does not have problems like this and I imagine what is going on
> is that the RB API works fine, but the SQL interface has bugs when it
> comes to too many transactions in the way I am executing them. This
> problem happens whether or not I flush after each query.
> 
> PLEASE help me on this one. There is little I can do on my side unless I
> change everything to rather use API than SQL, but then I don't want to do
> that, I want to use SQL.


> If v2 is going to be the answer then how much work is needed in changing
> my code, and is v2 stable enough for release, because this product is
> already out there but users want the ability to delete multiple users from
> the system.

2.0 is not ready yet

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