[Gambas-user] db.delete always returning error

rudy emil97 at ...1424...
Tue Aug 15 09:07:20 CEST 2006


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)

   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




More information about the User mailing list