Search results for query: *

Hi Steve, Cheers for your help, I had looked at the link before but working for a computer with no ability to download or unzip. The only script I can try is the following:- Datevar FirstDay:= Date({APPLIC_LIST_ENTRIES.ALE_STATUS_START}); datevar LastDay :=...

Hi Dave, Looks like it would have done the trick, unfortunately getting an error on the dbms_metadata.get_ddl and I don't think I can access the disks! Cheers for your help Sam

Hi All, Have tried both of the above formula's and am getting an error message saying a date-time is required here and the cursor hovers in before totext. Any ideas? Many thanks Sam

Hi All, I want a formula which will be datefield - datefield - workdays - any ideas? Cheers Sam

Hi Martin, Cheers for your help, the only thing is I am now trying to find the creation script of a table and not a view - do you know if this is stored anywhere? Cheers Sam

Hi all, I want to ammend a report in V7 which currently reads FieldA = Date(YYYY, MM, DD) -- and has a fixed date. to say FieldA = CurrentDate what is the correct way of doing this as I keep getting an error relating to needing a string! Many thanks Sam

cheers everyone for your help I've found what I thought was a view under all tables;-). Is there anyway of getting the creation script from here? Many thanks Sam

fantastic, only prob I now have is the view doesn't exist in user views or dbs_tables, is there anywhere else to check? Cheers Sam

Hi All, I know in Toad you can view the creation script of a view is there any way of doing this in sql plus? Cheers Sam

Hi All, What does the != function do? Cheers Sam

Fantastic - cheers both;-)

HI All, Realise this is a really dumb question, but I want to find a table where table_name like '%BLAH%' how do I do this? Cheers Sam

Hi All, Just converting a script someone else has written, am confused by the use of this ~ symbol?? What does it do?? Cheers Sam

Hi All, I'm curious to know if anyone has tried scheduling crystal reports to run either with v10 or using Enterprise? Many thanks in Advance Sam

Hi Dave, Worked a treat, needed to uncheck keep together in edit subreport! Many thanks Sam

Hey pgtek, The subreport is in the details section, any other ideas? Cheers Sam

Hi All, Please help, the subreport I've created brings back a few pages of data, the data does not start to display until page 2. Is there anyway of forcing it to start on page 1? Many thanks Sam

Hi All, I've set up a script that runs 3 seperate select statements. At the begining of the script there is a title using Ttitle left 'sadljkfdlk'. The title only appears above the 2nd set of results - any ideas why this is? also is it possible that I could have a different title for each of...

Hi All, Dima that was perfect, cheers all for help;-) Sam

Hey Both, Sorry about the errors, noticed as soon as I re-run, that the b aliases for the CASE's were wrong they should be a, b, c and d respectively. The results however are correct I do want to count those already counted in A in B, C and D too. The issue I'm having if I can't use aliases...