Search results for query: *

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

...strCritieria & " Outside Loop" If strCriteria <> vbNullString Then strCriteria = Left(strCriteria, Len(strCriteria) - 3) End If strSQL = "SELECT * FROM seizure" & _ IIf(strCriteria = vbNullString, ";", " WHERE " & strCriteria & ";") MsgBox strSQL It a multiple column listbox with values...

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

...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 10:50 AM' repeat_interval => 'FREQ=DAILY' enabled => TRUE comments =>...

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]

...on business object website. You should also look at this "thread759-1197042" A couple of important points you need a package and a package body Also the code in the package body needs to end with OPEN Cursor FOR SELECT * FROM table I hope this helps TheEntertainer

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

...AS PROCEDURE Test_Procedure ( Test_Cursor IN OUT Test_Type, Test_Parameter IN table.yearcode%TYPE ) IS BEGIN OPEN Test_Cursor FOR SELECT * FROM table WHERE table.yearcode = Test_Parameter; END Test_Procedure; END Test_Package; / this also compiles successfully Then to execute the stored...

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

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

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

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

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