Recent content by TheEntertainer

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...

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...

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

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...

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...

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...

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...

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...

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]

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 /...

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]

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...

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...

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...

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...