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 TouchToneTommy 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: beckybear
  • Content: Threads
  • Order by date
  1. beckybear

    manipulating oracle long field

    Is there any way at all to do anything with an oracle long data field besides display it? I have an oracle long data field used for text input that I need to parse for a name. Is there no way to do that in Crystal? Thanks.
  2. beckybear

    no main report data means subreport is not executed

    I have a main report with a single subreport. The subreport is placed in the report footer. The main report is linked to the subreport by start date and end date parameters (entered by the user for the main report and passed to the subreport). The main and subreport use the same tables, but...
  3. beckybear

    upgraded to 8.5, get odbc error for dates now

    I just upgraded from Crystal 7.0 to Crystal 8.5. I opened some reports to an Oracle 8.1.7 database. When I try to run them, I get an ODBC error "ORA-01830: date format picture ends before converting entire input string". Then I get a dialog box that says "Error detected by...
  4. beckybear

    can I change data source name globally?

    Is there any way to change a table name globally? I have a set of reports that use a certain table and I want to change the reports to use a view with the same field names, but obviously a different table name. Is there any way to do this aside from recreating the reports with the new view...
  5. beckybear

    select expert date criteria not being used in query

    Hi all. I have a report in crystal 7 going to an oracle database. Within the select expert, I've set up a few criteria and also have set up date criteria for a date range. The problem is that the report does not use this criteria, nor does is show up when "Show SQL Query" is chosen...
  6. beckybear

    outer join with string value

    I am running crystal 7 with oracle 8.1.7 and would like to put the following type of query in a crystal report: select a.name, b.street from a, b where a.key = b.key (+) and b.type (+) = 'HOME' I understand how to do the outer join with the field linking, but I don't know how to do it in the...
  7. beckybear

    Oracle Stored Proc IN/OUT parm using ADO - get garbage

    Sorry this is posted in a few places - I'm new and trying to find the right forum for this problem. I have a VB6 program that is calling an Oracle stored procedure. The problem is that the IN/OUT parameter is returning the correct string, but with garbage on the end of the string up to the...
  8. beckybear

    Problem with IN/OUT parameter for stored procedure

    I'm not sure if this post belongs here or in the VB forum, but haven't heard anything in VB, so here I am... I have a VB6 program on a Win2000 box which is calling an Oracle stored procedure. The problem is that the IN/OUT parameter is returning the correct string, but with garbage on the end...
  9. beckybear

    Problem with parameter returned from Oracle stored procedure.

    I have a VB6 program on a Win2000 box which is calling an Oracle stored procedure. The problem is that the IN/OUT parameter is returning the correct string, but with garbage on the end of the string up to the buffer size. This code was works fine with 7.3.4, but does not work with 8.1.7...

Part and Inventory Search

Back
Top