Register and join over 40,000 other developers!
Recent Topics
-
Print specific values from dictionary with a specific key name
Siten0308 - Jun 20 2019 01:43 PM
-
Learn algorithms and programming concepts
johnnylo - Apr 23 2019 07:49 AM
-
Job Gig PHP Form Needed
PJohnson - Apr 18 2019 03:55 AM
-
How to make code run differently depending on the platform it is running on?
xarzu - Apr 05 2019 09:17 AM
-
How do I set a breakpoint in an attached process in visual studio
xarzu - Apr 04 2019 11:47 AM
Recent Blog Entries
Recent Status Updates
Popular Tags
- networking
- Managed C++
- stream
- console
- database
- authentication
- Visual Basic 4 / 5 / 6
- session
- Connection
- asp.net
- import
- syntax
- hardware
- html5
- array
- mysql
- java
- php
- c++
- string
- C#
- html
- loop
- timer
- jquery
- ajax
- javascript
- programming
- android
- css
- assembly
- c
- form
- vb.net
- xml
- linked list
- login
- encryption
- pseudocode
- calculator
- sql
- python
- setup
- help
- game
- combobox
- binary
- hello world
- grid
- innerHTML

3 replies to this topic
#1
Posted 10 September 2008 - 01:55 AM
Hai,
I am new in vb6. Now i was started a programe for developing Granite Processing System. For that i have lot of problems.
For ex:
If i click the save button, it will execute all queries i am writing. it is having 5 insert statement. after completing 3 queries i have an error for some thing. Execute all five queries without an error this is exexute. Inbetween any errror will occur i will be remove the last transaction.
How to Use the transactions.
I am new in vb6. Now i was started a programe for developing Granite Processing System. For that i have lot of problems.
For ex:
If i click the save button, it will execute all queries i am writing. it is having 5 insert statement. after completing 3 queries i have an error for some thing. Execute all five queries without an error this is exexute. Inbetween any errror will occur i will be remove the last transaction.
How to Use the transactions.
#2
Posted 10 September 2008 - 12:23 PM
What's the error message?
If you enjoy reading this discussion and are thinking about commenting, why not click here to register and start participating in under a minute?
#3
Posted 15 September 2008 - 03:10 AM
I think you can use begintrans and committrans. This will allow you to either insert all transactions or insert none.
#4
Posted 22 September 2012 - 07:28 PM
set a boolean (say bError) to False
begin the transaction
do your inserts here
after each insert, if there's any error set bError to True)
after all the inserts, if bError is false
commit the transaction
else
roll back the transaction (and give the user some indication of what happened)
begin the transaction
do your inserts here
after each insert, if there's any error set bError to True)
after all the inserts, if bError is false
commit the transaction
else
roll back the transaction (and give the user some indication of what happened)
Also tagged with one or more of these keywords: Visual Basic 4 / 5 / 6
Language Forums →
Visual Basic →
64bit Excel Office 2010: Automation error %1 is not a valid Win32 application.Started by Jerdzzz, 18 Nov 2012 ![]() |
|
![]() |
||
visual basic 4 / 5 / 6
Language Forums →
Visual Basic →
visual basic newbieStarted by HarryRecon, 05 Oct 2012 ![]() |
|
![]() |
||
visual basic 4 / 5 / 6
Language Forums →
Visual Basic →
Buttons VB don't workStarted by Jeroen, 20 Sep 2012 ![]() |
|
![]() |
||
Visual Basic 4 / 5 / 6
Language Forums →
Visual Basic →
VB6.0 and DB2Started by libbylibra, 28 Aug 2012 ![]() |
|
![]() |
||
Visual Basic 4 / 5 / 6
Language Forums →
Visual Basic →
Why use VB6 or VB.NET?Started by Zer033x, 14 Aug 2012 ![]() |
|
![]() |
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download