Old ERS Script

[DBergkamp10]

Hi,

I have an old ERS script that I am converting to VBA. In the old scripts, there are two functions:

ERSSQLStmtPrep

and

ERSSQLExecPrep

What would be their equivalent in VBA?

Thanks in advance for any help.

Regards,

Ivan

 

[dgillz]

I'm not sure, very few people ever used ERS. I've been doing this for 14 years and I have had exactly 1 customer that used ERS.

What does this script do? We can likely write it from scratch.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[DBergkamp10]

It's pretty huge. It does Provincial Tobacco taxes.

 

[dgillz]

Are you Jim Matthew's customer by any chance? You are in Canada right?

We wrote a big tobacco tax application for a customer in Oklahoma. He said he had another tobacco client but it has been years since we discussed it.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[DBergkamp10]

Yes. Amazingly I have converted the tax from the old 16-bit ERS to ERS 50, and it seems to be working, but as you know, ERS 5 isn't supported. It's okay as a stop-gap measure of course.

Thx

 

[stravis]

You would want to use ADO (Classic) in VBA in place of the ERSSQL statements. ERS 5.0 has a layer that simplifies access to ADO but under the hood it is using ADO. There is no direct mapping of functions between these ERS functions and ADO. These days the best information on how to access ADO using VBA can be found on sites providing information on database access for ASP Classic websites.

Scott Travis

http://www.enterpriseexpressions.com