Err = DeleteAll() problem

Barney barney at custombased.com
Wed Jul 28 14:40:06 CDT 2004


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.

Thank you.

Barney 



More information about the Valentina mailing list