Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by yodaa

  1. yodaa

    Discard target="_top" for external page in iframe

    cLFlaVA, All files are on the same server. I want to replace the current index file with an index file containing the tool bar. My new index page code <html> <head> <title>UNITS tool bar test 3..</title> <meta http-equiv="content-type" content="text/html;charset=utf-8" />...
  2. yodaa

    Discard target=&quot;_top&quot; for external page in iframe

    cLFlaVA, There is a javascript in the head setting the target in the following way (PopNew is the ID of a check box) if( document.form1.PopNew.checked ) document.form1.target = "NewWindow"; else document.form1.target = "_top"; The javascript also sets PopNew to true if the page...
  3. yodaa

    Discard target=&quot;_top&quot; for external page in iframe

    Hi, I wish to create a basic page using an iframe. The iframe will contain a login page for a system we have purchased and can't modify. When you hit the login button, the welcome page will load on top of the page because since the target is set to top. The reason for why I wish to use an...
  4. yodaa

    Discard target=&quot;_top&quot; in external page in iframe

    Hi, I wish to create a basic page using an iframe. The iframe will contain a login page for a system we have purchased and can't modify. When you hit the login button, the welcome page will load on top of the page because since the target is set to top. The reason for why I wish to use an...
  5. yodaa

    Scheduled reports stuck in &quot;Running&quot; state

    MJRBIM, Thanks for the reply. I tried patching up CE, but it didn't solve the problem. So my next approach was to uninstall CR and CE, that worked fine. But when I tried to install CE again, it detected MS SQL Server on the machine. For some reason, I don't have the username/password to be able...
  6. yodaa

    Scheduled reports stuck in &quot;Running&quot; state

    Hi, I'm using CR Enterprise 10 on a server to schedule a number of reports. As of yesterday the reports haven't run, the're stuck in "Running" mode. I can't see any messages that could be of help. This has worked fine for about a month. The only change on the server is that I the day before...
  7. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    Yeah, sorry about that. I didn't look at the whole picture there. Thanks again guys, will try this first thing at work tomorrow. /yodaa
  8. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    Beilwish, Sweet.. Did not know you could use negation in substr(). That will make my select statement more clean. I can't create a new table as I need to have the 4000 character capacity. Thanks for the help, all of you. /yodaa
  9. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    Solved it! select "Field_A","Field_B",substr(case when length("Field_C") < 256 then substr("Field_C",1,length("Field_C")) when length("Field_C") > 255 then substr("Field_C",length("Field_C")-255,length("Field_C")) end,1,255) as NewName from "Table_A" Thanks for all the help. /yodaa
  10. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    SantaMufasa, Have you had the chance to look at the VARCHAR2(4000) issue? Thankful for any help. /yodaa
  11. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    SantaMufasa, If I don't use the double quotes I get syntax errors. That's the only reason for why I'm using it. I'll see if there's a way of getting rid of those, thanks for noticing it. My original code will never return a string > 255. The thing forcing me to use the case statement is that I...
  12. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    hoinz, thanks for the quick help.. I've tried the below query to create the view and I still get a VARCHAR(4000). I'm in a catch-22 situation and don't know where to go from here. select "Field_A","Field_B",case when length("Field_C") < 200 then "Field_C" when length("Field_C") > 199...
  13. yodaa

    Alter the size of aVARCHAR2 column in a VIEW

    I have created a View in Oracle 10g where one of the columns is a VARCHAR2(4000). I want to change that VARCHAR2 column to a VARCHAR2(255) because I'm having problems with using the field in a formula in Crystal Reports 8 since CR8 can't use fields > 255 characters in formulas. Is it possible...
  14. yodaa

    Request propagation (multimaster replication) from trigger?

    I'm looking for information regarding multimaster replication in Oracle 10g. I've found out that asynchronous replication would suit our needs well. The exception is the data conflict that occurs when two users at the same time creates a new record in the exact same table in their local...
  15. yodaa

    Trigger with embedded select that returns multiple rows

    Hi, I have a problem with a trigger. Three tables are invovled in the process. Table a pID, aID Table b pID, bID, bNum, bType The tables above are the source tables and shall be used to populate Table c. Table c should contain values from the tables above as seen below. Table c pID, aID, bID...
See more

Part and Inventory Search

Back
Top