[Gambas-user] db.delete always returning error

[Ron Onstenk]

On Tuesday 15 August 2006 09:07, rudy wrote:
> Hi,
> 
> I try to delete a record from table using db.delete, but it always returning 
> error message "Wanted Result got Void instead". However, the record IS DELETED 
> CORRECTLY.
> 
> The procedure:
> ---------------------------------------------------------------------------------------------
> PUBLIC SUB Delete_Transaction(nomor AS Integer)
>   
>    DIM rs AS Result
>    DIM criteria AS String 
> 
>    criteria = "nomor = &1"
>      
>    db.Begin
> 
>    rs = db.Delete("transaksi_tunda", criteria, nomor)

Are you sure db.Delete _is_ returning a Result ?
A boolean True/false looks to me more the case.


> 
>    rs.update
>    db.Commit
>    
>    CATCH
> 
>    Message.Error(ERROR.text)
>    
> END SUB 
> --------------------------------------------------------------------------------------------------
> Is there something wrong with above 
> procedure, or is it a bug ? (Using other db command such as db.Exec and 
> db.Edit, they work correctly, no error message).
> 
> I use gambas 1.9.34 on Suse 10.0, database is MySQL 4.1.14.
> 
> Thanks,
> Rudy
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 

-- 
The only bug free software from MickySoft is 
still shrink-wrapped in their warehouse...