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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TheEntertainer

    Strange Formula

    Dear All, Well there not really strange just not what I've seen before. I've come across a couple of formulas in some sample Crystal Reports and I'm just wondering what it is they are doing and what language they are referencing. Here is the first example, which I don't know what its doing...
  2. TheEntertainer

    InfoView User Delete Permissions

    Dear All, Sorry if this has already been answered, I've done a search and can't find anything. I've given a user view on demand permissions to a set of reports, what I don't want them to have is delete permissions. Is it possible remove restrict this option/button from there infoview window...
  3. TheEntertainer

    ListBox Column as Subform Recordsource

    Think I've sorted it. Just needed to change the multiselect property of the listbox to simple or extended. Cheers
  4. TheEntertainer

    ListBox Column as Subform Recordsource

    I'm doing something similiar but I am making selection, but it doesn't seem to register the selection. This is the code is below the if statement (If Me.List39.Selected(intCounter) = True) never seems to be true and therefore the strCriteria is not constructed correctly. For intCounter = 1 To...
  5. TheEntertainer

    Upgrading from Access to Oracle

    GoStillers, If you down load SQL Developer (free) from here: http://www.oracle.com/technology/products/database/sql_developer/index.html Once installed do a check for update under Help option and and it should it should give you the option of installing some migration tools including 1 for...
  6. TheEntertainer

    Julian to Gregorian

    Dear All, I've tried to use the formula in thread183-1148071 Changing the table and the fields of course select dateadd(d,convert(int,MCD2J) % 1000,convert(datetime, (convert(varchar,convert(int,MCD2J) /1000 + 1900) + '/1/1'))) From PS_TEST.TSDTA.F0006 I keep getting an error message of...
  7. TheEntertainer

    dbms_scheduler

    Thanks for the reply Ken, I figured it out, by having a look at some of the system dbms_scheduler jobs set up, you've got to enter the date for the start date as '08-AUG-06 11.15.00.000000000' I'm hoping that this equates to 11.15 am if not back to the drawing board. Once I get it working I...
  8. TheEntertainer

    dbms_scheduler

    Dear All, I'm trying to create the following job using dbms_scheduler begin dbms_scheduler.create_job( job_name => 'DEMO_JOB_SCHEDULE' job_type => 'PLSQL_BLOCK' job_action => 'declare x varchar2(1); begin select * into x from dual; dbms_output.put_line(x); end;' start_date => '08/08/2006...
  9. TheEntertainer

    simple question, help pls...

    h3nd, As you've logged into the database, I would think you'd know what database you were in Number of tables: select count(*) from all_tables; Name of tables: select table_name from all_tables Look at the data dictionary for a wealth of tables that provided database information. [afro]
  10. TheEntertainer

    Problem with variable.

    replace WHERE H.DOCKET_NO = :DOCKET_NO1 with WHERE H.DOCKET_NO = DOCKET_NO1 if you really what to use bind variable then in sqlplus you need to put in something like variable DOCKET_NO1 NVARCHAR2(14) [press return] begin select '2005-001-00001' into :DOCKET_NO1 from dual; end; [type /...
  11. TheEntertainer

    toad like program to access and query an oracle

    tekkerguy, SQL Developer. 1) Free 2) From Oracle 3) Automatic Updates 4) Platform independant 5) Simple install - just unzip files to folder http://www.oracle.com/technology/products/database/sql_developer/index.html TheEntertainer [afro]
  12. TheEntertainer

    SP help

    bmanning2, I to work with Crystal Reports XI and Oracle and my understanding is that for Crystal to read/see a recordset it has to be in a package. You need to search for a document called cr_oracle_stored_procedures.pdf on business object website. You should also look at this...
  13. TheEntertainer

    The request timed out (BOXI)

    Hello, Thanks for your responses. I've now tried both an OLE and Oracle Server connection, the oracle server connection was based on a SP as well to see if that was quicker. I'm not scheduling the report, just running. The 600,000 being 10 mins makes sense as it takes around 15 mins to start...
  14. TheEntertainer

    Ref Cursor Oracle 9i and Crystal Report

    Stefan, Thanks for that, I've been trying to figure it out and just couldn't. You'd think whoever wrote it would have tested it and then they would come up with the same error. Anyway it working now, it even returning data into Crystal. Just one question for anyone. This seems very...
  15. TheEntertainer

    Ref Cursor Oracle 9i and Crystal Report

    Hello, I've not even got as far as crystal! I'm just trying to create a simple package with which to report off. This is what I've got so far: CREATE OR REPLACE PACKAGE Test_Package AS TYPE Test_Type IS REF CURSOR RETURN table%ROWTYPE; PROCEDURE Test_Procedure ( Test_Cursor IN OUT...
  16. TheEntertainer

    The request timed out (BOXI)

    I've had a look and can't quite find an answer to this problem. I've got a report based on a query which does some complex number crunching on the database and the returns the records. It takes around 15 minutes to return, if you run it for data running back from August 2004 to today in Crystal...
  17. TheEntertainer

    Sqlplus

    Yeah, I saw that in another tread, but I'm fairly new with Enterprise and when I went to change the setting it said that the server had to re-boot and I chicken out until I'm sure that it will not affect anything else Thanks to you both for your help. Cheers
  18. TheEntertainer

    poor raptor performance

    Hi, I've just installed raptor and I'm finding that it runs the same as in TOAD! Although I've not run anything complicated. I've found it useful in that we don't have full TOAD here and the free new version restricts number of row exported etc so I've been using an old, old version that...
  19. TheEntertainer

    Sqlplus

    Turkbear, Thanks for your response on this. I've followed your suggestion and I've managed to get the database to do most of the calculations. Reduced the number of records from 3 million plus to 19! (With 48 columns). BOXI is still timing out as the database has got to do some churning...
  20. TheEntertainer

    Sqlplus

    Thanks, For the replies. -k you are right in the sense that it is a recordset. If I explain what I'm after then you guys could probably point me in the right direction. I've got a report which contains around 18 months worth of data which produces 3 million plus records. The sql starts...

Part and Inventory Search

Back
Top