Search found 13 matches

by lgazire
Thu Feb 21, 2019 10:26 am
Forum: Programming
Topic: Variables as parameters in SQL procedure call
Replies: 2
Views: 144

Variables as parameters in SQL procedure call

I want to execute the following case? %s = @str(!productId) pageload(page={%produto}, type=odbc) "Description=DEsc;DRIVER=ODBC Driver 13 for SQL Server;SERVER=localhost;Trusted_Connection=Yes;APP=EViews;DATABASE=Db;" "{call USP_SEL_GetMovingAveragePriceQuote ("+%s+"))}"...
by lgazire
Wed Feb 20, 2019 11:21 am
Forum: Data Manipulation
Topic: Get rows from a table and convert to vecto
Replies: 2
Views: 127

Get rows from a table and convert to vecto

Hi! I have a table data type displayed like this: series1 series2 series3 series4 series5 series6 series7 TOP 1 0.277443 0.291860 0.029998 0.290479 0.333404 0.283614 0.299484 TOP 2 0.268523 0.291546 0.029209 0.290310 0.332705 0.283433 0.299298 TOP 3 0.260101 0.289590 0.029191 0.289099 0.331738 0.280...
by lgazire
Fri Feb 15, 2019 10:41 am
Forum: Data Manipulation
Topic: Copy sample to another page is not working
Replies: 1
Views: 136

Copy sample to another page is not working

When i run sample smpl_{%produto} {%dt} generates the data 01/02/2009 @last but when i try to copy to another page it only generates @all Steps: sample smpl_{%produto} {%dt} copy(overwrite) home\smpl_{%produto} {%produto}\dt I tried without the overwite param as well and it didn´t work, what am i do...
by lgazire
Fri Feb 15, 2019 10:08 am
Forum: Data Manipulation
Topic: Import SQL data to the same page created
Replies: 5
Views: 167

Re: Import SQL data to the same page created

Hmm, didn´t know that, i thought that it was used. Thanks!
by lgazire
Fri Feb 15, 2019 9:38 am
Forum: Data Manipulation
Topic: Import SQL data to the same page created
Replies: 5
Views: 167

Re: Import SQL data to the same page created

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
by lgazire
Fri Feb 15, 2019 9:30 am
Forum: Data Manipulation
Topic: Import SQL data to the same page created
Replies: 5
Views: 167

Re: Import SQL data to the same page created

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 F...
by lgazire
Fri Feb 15, 2019 9:01 am
Forum: Data Manipulation
Topic: Import SQL data to the same page created
Replies: 5
Views: 167

Import SQL data to the same page created

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: wfcreate(wf=passthrough, page=home) d5 1/1/2007 12/31/2019 i want to store the result of the below que...
by lgazire
Tue Feb 12, 2019 1:03 pm
Forum: Data Manipulation
Topic: Convert Series type to svector
Replies: 3
Views: 155

Re: Convert Series type to svector

Awesome! It worked great!
Just one more question i need to get the series date time values into a date time array, how can it be done?
by lgazire
Tue Feb 12, 2019 10:16 am
Forum: Data Manipulation
Topic: Convert Series type to svector
Replies: 3
Views: 155

Convert Series type to svector

Getting the result table from a sql query returns two data types, a series and a alpha, i can easily convert the alpha to svector using the @convert, is there a way to do the same with the series type? Currently using Eviews 10.
by lgazire
Mon Feb 11, 2019 10:39 am
Forum: Any Other Business
Topic: Passing parameter and run prg file in API
Replies: 5
Views: 362

Re: Passing parameter and run prg file in API

The run and exec commands allow you to pass arguments and options to the .prg. The .prg could be written such that it uses those arguments or options to populate the fields of your SQL log in, presumably. Hmm, nice, i will try to put the log in info in the prg file. Is there a documentation for this?
by lgazire
Mon Feb 11, 2019 10:28 am
Forum: Any Other Business
Topic: Passing parameter and run prg file in API
Replies: 5
Views: 362

Re: Passing parameter and run prg file in API

Not entirely sure I understand the question, but you can issue an exec or run command through COM that will instruct EViews to run a .prg. http://www.eviews.com/help/helpintro.html#page/content/commandcmd-exec.html I manage to execute the via COM like this: var manager = new Manager(); var app = (I...
by lgazire
Mon Feb 11, 2019 9:54 am
Forum: Any Other Business
Topic: Passing parameter and run prg file in API
Replies: 5
Views: 362

Passing parameter and run prg file in API

All,

I read the COM documentation and did not find any specs regarding running the prg extension file through the api, is there a way to run it without being a wf1 file? Also, need to pass parameters through the execution, can it be done?

Currently using the Interop.Eviews version 10.

Go to advanced search