EViews.com

Posted: **Tue Jul 31, 2012 9:16 am**

I've programmed a routine in VBA (excel) that calls a prg.

I work with EViews 6 running under v4 compatibility and works just fine.

When I run it on my client's computer (EViews 7.2 Enterprise Edition with the latest patch installed today), the routine crashes with an uncontrolled error. Report is attached here. The line that causes the crash should be quite innocuous and similar tables are defined previously, so I don't have any idea of what is going on.

"Table T_S_InvMG_%valor2 = tablaa" (tablaa is another table defined previously)

What is worse, is that I thought maybe the wildcard had something to do with the issue, so I rewrote the line like this "Table T_S_InvMG_{%valor2} = tablaa", but nothing happened, so I tried:

"Table T_S_InvMG_{%valor2}
T_S_InvMG_{%valor2} = tablaa"

AND GUESS WHAT? It worked! BUT, when I tried to run the VBA routine with the shell command, it crashed again AND wouldn't even run from EViews without the shell command.

I'm completely puzzled by this and I need a prompt solution. If this uncontrolled bug needs a patch, I will need a temporary solution at least. I hope you can help me.
Thanks!

: error report.png (227.01 KiB) Viewed 10692 times

: error report 2.png (214.41 KiB) Viewed 10692 times

Posted: **Tue Jul 31, 2012 10:43 am**

Can you confirm the build date of your copy of EViews? You can check it under Help->About EViews.

Posted: **Tue Jul 31, 2012 10:52 am**

20 Jul 2012 -enterprise edition

Posted: **Tue Jul 31, 2012 2:16 pm**

We are looking into the issue and will reply to this thread as soon as we have more information

Posted: **Tue Jul 31, 2012 2:36 pm**

Thanks.

If you need to talk to someone please give us a call ASAP

Posted: **Wed Aug 01, 2012 2:14 pm**

Ok I tried to do the following to recreate your issue but failed to find a problem:

1. Created a program named test111.prg with the following contents:

Code: Select all

wfload c:\files\blah1.wf1
%valor2 = "v"
table t_{%valor2} = t

where blah1.wf just contains a single table object named "T"

I ran the program from within EViews and it worked fine. A new table object by the name "T_V" was created.

2. I also kicked off EViews7.exe with the path to the program file and that worked fine:

Code: Select all

EViews7.exe c:\files\test111.prg

3. Finally, I used COM Automation using VBA from Excel 2007 to launch an instance of EViews and ran the program with the following code:

Code: Select all

Sub test()
    Dim mgr As New EViews.Manager
    Dim app As EViews.Application
    
    Set app = mgr.GetApplication(NewInstance)
    
    app.Show
    
    app.Run "run c:\files\test111.prg"
    
End Sub

and that worked fine as well.

Are you doing something different?

Steve

Posted: **Thu Aug 02, 2012 7:13 am**

Steve,

As I mentioned in the first post, the strangest thing is that the overflow happens when creating a table, but NOT the first time it is done.

We're running the program from a shell command such as

shell(path/EViews 6/Eviews6.exe path/program.prg), similar to your 2 option. Is it exactly the same?

Posted: **Thu Aug 02, 2012 9:47 am**

Send me your EViews program and highlight the line (with a comment) that is causing the error. Send it to steve@eviews.com.

EViews.com

EViews 7.2

EViews 7.2

EViews 7.2

Re: EViews 7.2

Re: EViews 7.2

Re: EViews 7.2

Re: EViews 7.2

Re: EViews 7.2

Re: EViews 7.2