activeX exe

[abhijit]

hi everybody,
though i have been a visual basic developer for around 3 years, my knowledge about activeX exe's is very limited.

could anyone provide any sample code for activeX exe appz?
regards,
abhijit

[simonm]

What is it exactly you are trying to achieve?

There isn't really any difference between an ActiveX EXE and a normall EXE besides from the fact that an ActiveX EXE (may) expose classes that can be instantiated by external projects.

An ActiveX EXE will run in a seperate process from the calling application.

[abhijit]

Hi SimonM,

Thanks for getting back to me. Now presently I am having one table which is getting updated through an activeX eXe. I mean I pass certain parameters to the activeX exe and if the transaction fails, I abort.

Or else I continue and insert the records.

However there are certain aspects over here. I am still not able to figure out how to generalize this exe for any table. Cos it presently works only with that particular table. Also I figure on using MTS as well. Now is there a real need of MTS over here? I dont think so. Cos I can very well go ahead and check the same thing over here in the activeX eXe. I simply dont understand the need for using an MTS.

So where would an MTS transaction be used?

Cheers,
Abhijit

[simonm]

I'm not entirely sure I understand you correctly but as for making a generic table update procedure, How about passing in an array of variants (containing field values) and an array of strings (containing the corresponding field names). This way, all you have to do is cycle through your two arrays, validate each field exists and then assign the value to it.

As for MTS, I don't use MTS so I'm not the best person to tell you about it's advantages and disadvantages.

[abhijit]

Hi SimonM,
Thats a nice idea. I think I ought to try that. Passing everything in an array. I will try this at once.

BTW - I noticed that you are in England. So am I at the present. I am based in Middlesex.

Cheers,
Abhijit