You can do it like this
Begintrans 'update code If err = 0 then Committrans Else Rollback End if Wendy ________________________________ Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Verzonden: donderdag 23 september 2004 7:39 Aan: [EMAIL PROTECTED]; [EMAIL PROTECTED] Onderwerp: [Visual Basic 6 programming] Hello Group well i got a problem abt update database . i need a procedure like if something wrong happen then half updatation will b rollback means if update then all and not then nothing .. but please i need code i know that this is posible in SQL but i dont know how to make and use it with access.PLease help me to solve this problem . i attached my tables's relationship. Best Regards Kina Jadeja [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT click here <http://us.ard.yahoo.com/SIG=12915dc8s/M=294855.5468653.6549235.3001176/ D=groups/S=1705115364:HM/EXP=1098709471/A=2376776/R=0/SIG=11ldm1jvc/*htt p:/promotions.yahoo.com/ydomains2004/index.html> <http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group s/S=:HM/A=2376776/rand=994072609> ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] bscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=17756 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
