EViews.com

Posted: **Fri Feb 15, 2019 9:01 am**

Hi there!

I have an eviews program that currently is being migrated to SQL, i´m new to eviews, is there a way to show the result in the same page as the created the workfile?

This is how i created:

Code: Select all

wfcreate(wf=passthrough, page=home) d5 1/1/2007 12/31/2019

i want to store the result of the below query in the home page:

Code: Select all

pageload(type=odbc, page=home) "Description=desc;DRIVER=ODBC Driver 13 for SQL Server;SERVER=localhost;Trusted_Connection=Yes;APP=EViews;DATABASE=iec;" "querycode"

What is the right approach to do it?

Posted: **Fri Feb 15, 2019 9:28 am**

Try using import rather than pageload.

Posted: **Fri Feb 15, 2019 9:30 am**

If i change to import it shows the error:

Incomplete date specification (no start date provided) in "IMPORT(TYPE=ODBC, PAGE=HOME) "DESCRIPTION=DESC;DRIVER=ODBC DRIVER 13 FOR SQLSERVER;SERVER=LOCALHOST;TRUSTED_CONNECTION=YES;APP=EVIEWS;DATABASE=DATABASE;" "SELECT ID, PRODUCTNAME FROM PRODUCT WHERE ID = 15"".

Posted: **Fri Feb 15, 2019 9:38 am**

Sorry, i just read the help for import and check that i need to pass the @append. But if i do this overwrites the resid that i had with the wfcreate

Posted: **Fri Feb 15, 2019 10:00 am**

resid is meaningless, overwriting it should be fine?

Posted: **Fri Feb 15, 2019 10:08 am**

Hmm, didn´t know that, i thought that it was used. Thanks!

EViews.com

Import SQL data to the same page created

Import SQL data to the same page created

Re: Import SQL data to the same page created

Re: Import SQL data to the same page created

Re: Import SQL data to the same page created

Re: Import SQL data to the same page created

Re: Import SQL data to the same page created