Search results for query: *

Thanks, I have tried that but need the answer to 1 decimal place - 88 Any ideas

Hi, When I add a simple calculation to a formula field in crystal 8.5 and also crystal XI it calculates the wrong result e.g. 8/9 = 89 instead of 88 I suspect it a rounding problem but I can’t resolve this. Can anybody help?

Hi, I am trying to create a query in crystal that will return a list of all records that does not have a bracket at the start of the field. The following query returns all records that do have a bracket at the starts {REGISTRATION.NARRATIVE} STARTSWITH '{' But can anybody tell me how to make...

This is the error I am getting #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on contacts_cstm for insert,update as if update (hatcost_c) or update (ship' at line 2

Hi, I am new to SQL and have created the following trigger in MS SQL Express but can't get it to work in MYSQL 5.0 Can anybody tell me what is wrong it say the sytanx is wrong create trigger totalcost_c on contacts_cstm for insert,update as if update (hatcost_c) or update (shipping_c) begin...

I have a crystal report (version 8.5) that is summing an amount of money. e.g Mr Smith Amount Due Received to date Outstanding 100 50 50 200 175 25 300 225...

Hi, I need to export 136000 records into a CSV file. I have tried doing this using crystal but it says excel can only support 62000 records. Can anybody tell me how I can do this? Many Thanks

Thanks Guys.

Hi Jaxtell, Tried that but now get ERROR at line 3: ORA-00904: "SEARCH_NUMBER": invalid identifier any ideas? Thanks for your help

UPDATE SEARCH_TYPE SET PLANNING_HISTORY = 'N' where PLANNING_HISTORY IN (SELECT SEARCH.SEARCH_NUMBER, SEARCH_TYPE.PLANNING_HISTORY FROM LAND.SEARCH SEARCH, LAND.SEARCH_TYPE SEARCH_TYPE WHERE SEARCH.SEARCH_TYPE = SEARCH_TYPE.CODE AND SEARCH.SEARCH_NUMBER = '2008/01439')...

UPDATE SEARCH, SEARCH_TYPE SET PLANNING_HISTORY = ‘N’ where SEARCH.SEARCH_TYPE = SEARCH_TYPE.CODE AND SEARCH.SEARCH_NUMBER = '2008/01439'; ERROR at line 1: ORA-00971: missing SET keyword ----- UPDATE SEARCH_TYPE, SEARCH SET PLANNING_HISTORY = ‘N’ where PLANNING_HISTORY IN (SELECT...

Hi Guys I new to SQL plus and was wondering if anybody can help with the following query? The following query returns the information needed SELECT SEARCH."SEARCH_NUMBER", SEARCH_TYPE."PLANNING_HISTORY" FROM "SEARCH" SEARCH, "SEARCH_TYPE" SEARCH_TYPE WHERE...

Hi, I have just started teaching myself SQL plus and was wondering how I can update multiple records (application numbers that I can define) E.g. update application_table Set closed ='Y' where application_number = '20008121' What I would like to do is to be able to define multiple application...

There is only one decision field and a decision status filed that picks up the final or draft decision. I have set this to final see red SET ECHO OFF set pagesize 0 set feedback off set heading on set validate off set termout off set trimspool on set markup HTML on spool...

Hi Dagon, I would want to display the most recent entry on all fields. I think the duplication is caused by more that one decision. (E.g. there is also an draft decision). (The rest of the fields seem to be identical and only the decision is different. ) So if you can tell me how to amend...

Hi, I’ve got the following scrip (SQL Plus) that works like a charm but I have noticed that is duplication some records. SET ECHO OFF set pagesize 0 set feedback off set heading on set validate off set termout off set trimspool on set markup HTML on spool c:\ApplicationInfo.HTML SELECT...

Hi Guys I am trying to search a memo file in Crystal XI I have tried the following formulas {Description} like “Brown” {Description} like “*Brown*” {Description} like “ * Brown * ” But get no results? I know there are records with this in the description? Can you help?

Hi Dagon This has helped but the query still appears at the top of the HTML file?

Hi I have the following query that publishes the results to a HTMl file. How can I make this not publish the query at the top of the HTMl file? Also every 14 rows it publishes table headings e./g Application Number, Application type Development address etc? How can I only make it publish...

Hi SantaMufasa I have changed the query to SELECT "PA_VIEW"."APPLICATION_NUMBER", "PA_VIEW"."APPLICATION_TYPE", "PA_VIEW"."DEVELOPMENT_ADDRESS", "PA_VIEW"."DEVELOPMENT_DESCRIPTION", "PA_VIEW"."WARD", "PA_VIEW"."RECEIVED_DATE", "PA_VIEW"."SYS_STATUS" FROM "LAND"."PA_VIEW" "PA_VIEW" WHERE...