[X]My Assistant

[access2009eg]

friends;

if i have some commands with SYSTEM.IO
MOVE file
COPY file
Delete file
In Vb.net as example

I want to execute all command if one of this command fails all process fail is this possible


Thanks you

[JonSmith]

Well unless you have added some error handling one would assume that you would get a runtime error if one failed?
Error handler seems to be the way to solve this regardless.

[projecttoday]

Does it work ordinarily? Are you running this from VB.Net? Can you show the code?

[GroverParkGeorge]

So, since you've posted this in the Visual Basic 2003 forum, are we to assume this is a VB.Net application?

If so, look into the use of Transactions

[access2009eg]

friends
this what i want
pseudo code


string sourceDbSpec = @"C:\Users\Public\a.accdb";
string destinationDbSpec = @"C:\Users\Public\b.accdb";
// Required COM reference for project:
// Microsoft Office 14.0 Access Database Engine Object Library
var dbe = new Microsoft.Office.Interop.Access.Dao.DBEngine();
dbe.CompactDatabase(sourceDbSpec, destinationDbSpec);
System.IO.File.Delete(sourceDbSpec);
System.IO.File.Move("C:\Users\Public\b.accdb", destinationDbSpec );


i want run all this command at the same time without any problem as package using some think like transaction in SQL server

[GroverParkGeorge]

Okay, did you go read the information on transactions to which I linked?

If so, what part do you need help understanding?

If not, please read it and see if you can implement it.

[access2009eg]

GroverParkGeorge

i read documentation

and i'm use Transaction with Insert Delete Update with database

but i'm not using transaction with command like

CODE

System.IO.File.Delete(sourceDbSpec);
System.IO.File.Move("C:\Users\Public\b.accdb", destinationDbSpec );

is possible use Transaction with Delete , Move .net
and when there is error in delete or move
can rollback

[GroverParkGeorge]

Well, the best way to know for sure is to try, isn't it?

[access2009eg]

not work with System.IO

CODE

   OleDbTransaction transaction;
try
            {
                dataConnection db = new dataConnection();
                db.cn.Open();
                //  int successdTransation = 0;
                
                transaction = db.cn.BeginTransaction();

                System.IO.File.Move(@"H:\b.txt", @"d:\db\b.txt");
                System.IO.Directory.Delete(@"H:\db");
                transaction.Commit();
            }
            catch (Exception ex)
            {
                transaction.Rollback();
                MessageBox.Show(ex.Message);
            }