Page 1 of 1
copy/paste renamed database link
Posted: Tue Jun 23, 2015 8:15 am
by rousing
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
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 8:36 am
by EViews Steve
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
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 8:39 am
by rousing
Sorry the (in) should not have been there in the first part of the rename
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 8:41 am
by EViews Steve
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)?
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 9:41 am
by rousing
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
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 10:40 am
by EViews Steve
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
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 10:44 am
by EViews Steve
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?
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 10:55 am
by rousing
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.
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 11:00 am
by EViews Steve
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
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 11:08 am
by rousing
yes, this I know - the normal paste as link
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 11:18 am
by EViews Steve
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
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 11:24 am
by rousing
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
Re: copy/paste renamed database link
Posted: Tue Jun 23, 2015 11:25 am
by EViews Steve
No problem. Let me know if you run into any more link issues...