Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bobhagan
  • Content: Threads
  • Order by date
  1. bobhagan

    ODBC vs OLEDB date difference?

    I am translating a group of reports from CR.8.0 to CR.NET. Several use ... AND {STATUS.STATUS_DT} >= {?StartDt} AND {STATUS.STATUS_DT} <= {?EndDt} in the query. In the CR8 version the query returns data from the day of EndDt. The CR.Net version returns only up to the day BEFORE; as if the...
  2. bobhagan

    STOP: 0x0000000&E on running XP Setup

    I'm trying to reinstall the basic XP files to a SATA drive, but get this error: 0x0000000 (0x80000003,0x809F1575,0xF79C5840,0xF79C5540). I have done this several times witout problem. I have gotten the teh same message while trying to install a new SATA drive. The only reference I find to the...
  3. bobhagan

    Missing Example.dbf halts startup

    I recently had a machine crash and wipe out my Oracle install. I have copies of the admin and oradata directories and was able to restore them. The example.dbf must be damaged. Startup goes as far as mounting, then errors when it tries to open. ORA-01122 database file 5 failed verification...
  4. bobhagan

    loop was evaluated more times than allowed

    WhilePrintingRecords; DateVar LastReferDt; DateVar Last3603Dt; DateVar Next3603Dt; // hardcoded for test Last3603Dt := DATE(2005,4,1); LastReferDt := DATE(2001,1,1); Next3603Dt := DATE(1999,1,1); IF Last3603Dt > DATE(0,0,0) THEN While Next3603Dt < Last3603Dt Do (...
  5. bobhagan

    Holiday Array Error

    I pretty much copied this straight from Ken H's FAQ: BeforeReadingRecords; DateVar Array Holidays := [ Date(2005,05,30), Date(2005,07,4), etc ]; It gives an error saying, "The result of a formula cannot be an array" on both CR8.0 and CR.Net. I'm using CR syntax. Ideas? Thanks Bob Hagan
  6. bobhagan

    Nested Query Works in 9 and not 8?

    I created a stored procedure with a query containing a nested subselect: SELECT C.CLIENT_NM, C.CLIENT_ID, Max(decode(substr(s.STATUS,1,2),'N-', s.Status_dt, null)) "LastRefer_Dt", Max(decode(substr(e.ENC_TYPE,1,4),'INIT', e.END_DT, null)) "LastInitVisit_Dt", [COLOR=red] (select...
  7. bobhagan

    Typed Ref Cursor for Crystal Report

    I've seen several questions about this that refer to a Crystal White paper. The example uses TYPE REFCURSOR cursorblah RETURN basetable%ROWTYPE; and then SELECTS * from that table. I'm using Oracle 8i and CR.NET. I need to SELECT some fields from a parent table and then a set of dates from...
  8. bobhagan

    One Section Landscape, Another Portrait?

    I have a report where my details section has so many elements it needs to display in landscape, but the summary must be in portrait to follow a pre-exisitng layout. Is this possible? Bob Hagan
  9. bobhagan

    Invalid field name in on ASP.net server

    I have a group of reports I'm converting from CR 8.0 to web CR.NET. All the reports but one convert and run from my machine as localhost and when copied to our server. One report works on my machine, but gives an "invalid field name" error when run from the server. This report is slow (15...
  10. bobhagan

    Install FC1 on Shuttle with SATA

    I'm trying to set up a Shuttle SB62G2 with an F62 motherboard. This has a SATA controller with an ICH5R chipset, and both an onboad Intel graphics chip and an added Asus GeoForce Fx5200 graphics card. I'm using whatI think is FC1 from the book, "Linux for Non-Geeks". When I try to install from...
  11. bobhagan

    Exception Rpt: Show all of set with any error

    I have an exception report with a group header that looks for missing client information (SSN,DOB etc) and then in details, a set of status records (Referred, Opened, Transferred, Closed) that must be in this order. I want to suppress all clients with no errors, but show all the records for...
  12. bobhagan

    Unable to Load Dll (oci.dll)

    I work for a group that's been using 8i and is converting a Windows/ASP app to ASP.NET. I tried running 8i on a new Pentium4/XP machine at home. It died frequently so I downloaded 10g personal. Now the application, which worked when 8i did says, "can't load oci.dll". How do I get this...
  13. bobhagan

    Update SP from VB.Net

    I'm trying to run an update from an ASP.net application, using the MS Oracle Provider. The stored procedure is generated from a CodeSmith template. I'm getting an Oracle error "Wrong number or type of parameters" For test purposes I reduced the table to two fields, the primary key - client_id...
  14. bobhagan

    Further Pentium 4 Problem?

    I installed Oracle 8.17 on a Pentium 4/WIN XP box following the instructions here. However, I can't keep it running. If I shut down the machine, the next time I try to restart DBA_Studio, etc., I get a no listener message. The listener and the database services are on automatic and are...
  15. bobhagan

    Performance w/ Parameter-Based Grouping

    I have a report where I need to select for and display running totals on a group level for Worker, Supervisor, Boro, and City. I thought that changing the group with a parameter was the ideal solution (otherwise I need to maintain multiple versions of the report). However the run goes from...
  16. bobhagan

    Performance w/ Parameter-Based Grouping

    I have a report where I need to select for and display running totals on a group level for Worker, Supervisor, Boro, and City. I thought that changing the group with a parameter was the ideal solution (otherwise I need to maintain multiple versions of the report). However the run goes from...
  17. bobhagan

    One Conditional Formula Depends on Another

    I have a table that records contacts with clients. The filter is contacts for the last month. There are groupings by client, worker, supervisor, site and a total. For each client I have one formula that records successful contacts and and one that records unsuccessful attempts. (There is...
  18. bobhagan

    SQL Expression UCase()

    I did a SQL Expression fn UCase({staff.staff_name}) and used it on an Oracle table: {%staff_nm} startswith UPPERCASE(?staff_nm) What's very strange is that it always fails the first time - whether using mixed, upper or lower case - and always works on any subsequent run of the report. If you...
  19. bobhagan

    Parameters &amp; Report Viewer

    We have some old reports where we added a parameter to search records by worker. The report is CR 8.0 and is used in a third-party application that calls the report viewer. the report works fine in Crystal, but when run in the application, the parameter dialog comes up only at the very end...
  20. bobhagan

    SUM on conditional in a SELECT ?

    I'm trying to calculate clients' age ranges and then sum them. CREATE VIEw V_FOODROLLUP (ENC_DT, ELDER) AS SELECT e.enc_dt, SUM(IIF (((current_date - c.CLI_BDATE)/365) > 65 ,1,0)) FROM encountr e, client c wHERE c.client_id = e.client_id GROUP BY e.enc_dt I...

Part and Inventory Search

Back
Top