Forums

Hi Alan

We do a lot of excel work but we use the active X automation not .Net. We imported the Excel Active X Automation library. We can then use these classes to open / drive excel.

In order to work out the code for Excel, we record a Macro in Excel of what we need to do and then look at the ...

If the transient method doesn't meet your needs, you could load a new method from a schema file. The schema file is just a text file containing the method source. Right click a method and choose Extract to create a file. You should be able to copy the format. It can be loaded using the Jadloadb ...

We have lock exception handlers as you have described. Basically, they back off and retry after a delay. The process may try three times before doing a pass back. If you are doing nightly processing, it may be better to put the object in a collection and then go back to it in a second pass. For ...

We've struck intermitent issues with users running our application on terminal server 2008 R2 servers. Sonetimes when the application displays a common dialog box (e.g. calls the CMSFileOpen::open method) the Jade thin client crashes. We are seeing a "14143 : Thin Client Tcp connection was closed ...

Method parameters are hidden in Jade. The following script will list a method's parameters in order. Should get you started for calling a method.


vars
oClass : Class;
oMethod : Method;
oParam : Parameter;
begin
oClass := currentSchema.getClass( VCContact.name );
oMethod := oClass.getMethod ...

Take a look at the "sendMsg" method (defined on Object.) This (and the sendMsgWithParams, sendMsgWithIOParams) methods allow you to call any method on an object. For example:

You can type cast a variable, for example:


someMethod(obj : Object)
vars
aCustomer : Customer;
begin
aCustomer := obj.Customer;


If the object is a customer, the code above will work, if not then an exception is thrown at runtime as Murray has pointed out.

You can check whether the object is ...

We've noticed an overhead (about 20 seconds in some cases) when Jade first interacts with a .Net component (Mainly on terminal servers.) This seems to be due to the loading of the .Net libraries. I've found the NGEN tool that allows the .Net components to be pre compiled at installation which helps ...

The PTF was what I remember. It was a useful tool for multi user scenarios (Load testing, locking and concurrency etc.)

I remember using a Jade utility to do some performance and load testing when I worked in the UK, unfortunately I can't remember its name. The utility would allow you to run clients on multiple machines and then set off the tests on all the clients. The management interface recorded both the test ...