Import SQL data to the same page created

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

lgazire
Posts: 14
Joined: Mon Feb 11, 2019 8:56 am

Import SQL data to the same page created

Postby lgazire » 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?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12266
Joined: Tue Sep 16, 2008 5:38 pm

Re: Import SQL data to the same page created

Postby EViews Gareth » Fri Feb 15, 2019 9:28 am

Try using import rather than pageload.
Follow us on Twitter @IHSEViews

lgazire
Posts: 14
Joined: Mon Feb 11, 2019 8:56 am

Re: Import SQL data to the same page created

Postby lgazire » 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"".

lgazire
Posts: 14
Joined: Mon Feb 11, 2019 8:56 am

Re: Import SQL data to the same page created

Postby lgazire » 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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12266
Joined: Tue Sep 16, 2008 5:38 pm

Re: Import SQL data to the same page created

Postby EViews Gareth » Fri Feb 15, 2019 10:00 am

resid is meaningless, overwriting it should be fine?
Follow us on Twitter @IHSEViews

lgazire
Posts: 14
Joined: Mon Feb 11, 2019 8:56 am

Re: Import SQL data to the same page created

Postby lgazire » Fri Feb 15, 2019 10:08 am

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


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 6 guests