Hello,

 

I have a form containing a datasource linked to a MySQL database table. The
datasource contains datacontrols to display the data from the underlying
table. There are buttons for add, edit, save, delete and cancel. The add
button creates a new record. The save button saves the record. The Edit
button allows change to the record. The cancel button cancels the changes.
The delete button deletes the entire record.

 

I would like the cancel button to cancel the add and all edits and
repopulate the form with the original data from the datasource table. If the
user hits the cancel button no change should be made to the table. The
delete button asks for confirmation before deleting the record.

 

I'm not so much looking for code so much but for advice on the proper
sequence of bd.begin etc. Should add and edit begin a transaction and save
commit the transaction? Should cancel rollback the transaction? The syntax
is $Con.Begin, $Con.Commit and $Con.Rollback. Is that correct? If my thought
is correct how do I get the form to display the original data?

 

Thanks

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user

Reply via email to