Recent content by puma51

Hi I am quite new to Oracle and have recently encountered this intermittent problem. It is now happening about twice a week and the rest of the time functions properly. Errors in file D:\oracle\admin\ernie\bdump\ernieCKPT.TRC: ORA-00206: error in writing (block 3, # blocks 1) of controlfile...

Hi I am trying to do an insert into a table but it is returning multiple rows. The source table contains the following:- Plan_No, Plan_Date, Company_No, User_No 123456, 01/01/2007, 456, 5 543454, 07/02/2007, 456, 4 345654, 21/03/2007, 456, 5 My select is as...

Hi Gary, thanks SELECT "BLK_MIN_ENEWS_LINKS"."LINKNO", "LINKS"."COMPANY_NO", "MSHMATCH"."MAILSHOT_NO", "LINKS"."LNK_DAT", "LINKS"."CONTACT_NO", "LINKS"."STAFF_NO", "LINKS"."STFDIVN_COD", "LINKS"."LNKREAS_COD", "LINKS"."LNKOUTM_COD" FROM "LIVE"."BLK_MIN_ENEWS_LINKS" "BLK_MIN_ENEWS_LINKS"...

Hi View is returning the correct results. Only when querying it through Crystal the problem happens. Not techy enough to write stored procedures I'm afraid. Thanks

Hi don't actually have a record selection in Crystal I'm just looking at the basic view:- CREATE OR REPLACE VIEW VW_MIN_ENEWS_LINK AS SELECT MIN(LINK_NO) AS LINKNO, MIN(LNK_DAT) AS LINKDATE FROM LINKS WHERE STFDIVN_COD = 'KBM' AND LNKOUTM_COD = 'PMARK'...

Hi Crystal 10 and Oracle 8 I have created a view in oracle which when queried through SQL+ or MS Access returns correct results. When I use Crystal to connect to the view it returns completely different results. The view has a condition that excludes records with a date range of <'01-JUN-05'...

Hi Using Crystal 10 and Oracle 10 I have a report that prints off event attendee names on badges. The Names are in the detail section of the report and I have formatted the section using 'Format with Multiple Columns' to create two colums of names across with five badges down i.e. 10 per page...

Hi Using Crystal XI on SQLServer 2000 I have a table of orders with the fields org_name and order_date. I want to identify the organisations that have had an order in a date range based on a parameter date field but who have not had an order in the 12 months prior to the latest date found in...

Hi Using Crystal 10 and Oracle 81. I have a simple report which calculates Gross * VAT @ 17.5%. I have to format the VAT field to 2 decimals places and round up to 2 characters to get the amount to display exactly right. E.g. 65 * 17.5% equates to 11.375 which I round up to 11.38 When I then...

Hi Using Crystal 11 and SQLServer 2000 I see that there are a number of posts for this already but no obvious answers - can anyone help? I have a number of identical reports containing crosstabs which I connect to different customer databases on same SQL server. These need to be exported to...