copy/paste renamed database link

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

rousing
Posts: 77
Joined: Fri Jun 11, 2010 5:56 am
Location: Switzerland

copy/paste renamed database link

Postby rousing » Tue Jun 23, 2015 8:15 am

Hi

If I create a database link, which I then rename - then when copying the renamed object to another page - the object gets automatically turned into an frml instead of remaining a database link object.

Code: Select all

fetch(d="DS_DB",link,c=l) LHMUN1Y(IN) rename LHMUN1Y(IN) LHMUN1Y_IN
Thanks in advance for your assistance :)

Best regards
Rasmus
Eviews 9 Jun 8 2015 build
90C05629

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: copy/paste renamed database link

Postby EViews Steve » Tue Jun 23, 2015 8:36 am

I tried to reproduce your issue but couldn't.

Your FETCH command would've created an object in your workfile with a different name than: LHMUN1Y(IN)
as "(" and ")" are both invalid characters in an EViews object name.

Because of that your rename line would be invalid as well and would do nothing other than generate an error.

Are you sure the second line is what's causing the change from link to formula?

Please try running your program line by line manually to see what is happening in detail...

Steve

rousing
Posts: 77
Joined: Fri Jun 11, 2010 5:56 am
Location: Switzerland

Re: copy/paste renamed database link

Postby rousing » Tue Jun 23, 2015 8:39 am

Sorry the (in) should not have been there in the first part of the rename

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: copy/paste renamed database link

Postby EViews Steve » Tue Jun 23, 2015 8:41 am

My guess is that the FETCH line is creating an object whose name is: LHMUN1Y_IN_

If you don't do the RENAME, is that what you're left with? And is it a link (pink) or a formula (orange)?

rousing
Posts: 77
Joined: Fri Jun 11, 2010 5:56 am
Location: Switzerland

Re: copy/paste renamed database link

Postby rousing » Tue Jun 23, 2015 9:41 am

The invalid characters are not taken care of - as is usually the case - when doing the fetch - on my side at least.
Another example involving an ISIN creates the same issue.

Code: Select all

fetch(d="DS_DB",link,c=l) DE0001135143(RY) rename DE0001135143 DE0001135143_RY
The initial link and renaming are pink, the paste is a normal frml with the following content in the formula field: fetch ds_db::de0001135143(ry)
Maybe also important to say, I do the copy/paste manually from one sheet to the other.
And the database fetch is from Datastream.

Best regards
Rasmus

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: copy/paste renamed database link

Postby EViews Steve » Tue Jun 23, 2015 10:40 am

Ah, copying an object from one page to another creates a page link, not a external link -- so this is working as it should.

The newly copied object is referring back to the object that you copied, not the source of the object that you copied. This was a design decision we made when we encountered this scenario during our testing.

Steve

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: copy/paste renamed database link

Postby EViews Steve » Tue Jun 23, 2015 10:44 am

Actually, I just read the rest of your post.

How did you do the copy/paste exactly? Did you use the mouse? Or did you use the keyboard at all?

rousing
Posts: 77
Joined: Fri Jun 11, 2010 5:56 am
Location: Switzerland

Re: copy/paste renamed database link

Postby rousing » Tue Jun 23, 2015 10:55 am

both copy/paste with mouse and keyboard ctrl+c ctrl+v generates the same outcome.
But maybe I am confused - but I am under the impression that copy/paste previously perfectly replicated the link - but cannot seems to get that outcome anymore both in Eviews 8 and 9.

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: copy/paste renamed database link

Postby EViews Steve » Tue Jun 23, 2015 11:00 am

If you copy an externally linked object (pink), then paste it to another page in the same workfile, the new object will page link back to the object on the other page, not the source of that object.

It's always been this way I believe...

Steve

rousing
Posts: 77
Joined: Fri Jun 11, 2010 5:56 am
Location: Switzerland

Re: copy/paste renamed database link

Postby rousing » Tue Jun 23, 2015 11:08 am

yes, this I know - the normal paste as link

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: copy/paste renamed database link

Postby EViews Steve » Tue Jun 23, 2015 11:18 am

Ok, if you believe this is still an issue, please email me screenshots of what you are seeing after you do the copy procedure manually. Email me at steve@eviews.com.

Specifically, I'm looking for a dialog that shows the new object being a formula with "fetch ds_db::de0001135143(ry)" inside the textbox.

Steve

rousing
Posts: 77
Joined: Fri Jun 11, 2010 5:56 am
Location: Switzerland

Re: copy/paste renamed database link

Postby rousing » Tue Jun 23, 2015 11:24 am

just tested on earlier build versions of my 32-bit installations both 8 & 9 - and it does not copy the way I thought it was suppose to...
Apologies about this mix-up from my side.
I figured out the database links distinguishes between local eviews db links - where copy paste works as I was expecting - but for the datastream links - this is not the case...and it was always like this
Last edited by rousing on Tue Jun 23, 2015 11:34 am, edited 1 time in total.

EViews Steve
EViews Developer
Posts: 844
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: copy/paste renamed database link

Postby EViews Steve » Tue Jun 23, 2015 11:25 am

No problem. Let me know if you run into any more link issues...


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 2 guests