Err = DeleteAll() problem

[Ruslan Zasukhin]

On 7/28/04 5:40 AM, "Barney" <barney at custombased.com> wrote:

> Hi,
> 
> V4RB.rbx both Windows and Mac IDE latest plugin downloaded
> 
> Cur = APP.DB.SQLSelect("Select * from Table1")
> If Cur.RecordCount > 0 then
> Err = Cur.DeleteAll()
> App.DB.Flush
> End if
> 
> This works fine but if you narrow your search down...
> 
> Cur = APP.DB.SQLSelect("Select * from Table1 Where name = 'John' ")
> If Cur.RecordCount > 0 then
> Err = Cur.DeleteAll()
> App.DB.Flush
> If Cur.RecordCount > 0 then
> 
> This will only delete the first record of cursor ?
> 
> Step thru running code in IDE and the cur has deleted all, but
> upon opening the database again, all the records are there again ?
> 
> Is this a bug ? Can send project if need be.

Hi Barnet,

Try do next.

-- Open your db in viSQL.
-- do query as 

    DELETE FROM T WHEE name = 'John'


Yes of course send me something.

Also check db with diagnose.
Also try rebuild indexes.



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