How to trace the return value of shell command in VB
Posted on 2003-02-25
I'm executing a .sql file(which has around 100 insert statements) from VB using shell command.
If any one of the insert statements fail in .sql i want to rollback the other transactions.
Any idea how to trap it.
I'm doing like this...
nResultVal = Shell("sqlplus vri/vri@gpoint @C:\Query.sql", vbMinimizedNoFocus)
This nResultVal is not consistent also.So i'mnt able to check for the success of all the queries.
Can u let me know??
pls mail at my id firstname.lastname@example.org