Search results for query: *

Sorry, I hit submit before I proofread. The error message is "The handle is invalid", and it's generated at the GetExitCodeProcess statement.

I have two VB programs provided by a vendor that call ExitProcess to return a code. I also have a test program that calls these two executables in succession that utilizes exactly the above set of steps to get the return codes. When I recompiled all three of these on my Win2K professional...

I believe that LONG and LONG RAW are different in that the first is character and the second is binary data. My field is a LONG field.

If I haven't said it already, thanks to both of you for all your time and help. I really do appreciate it. I tried the INSTR('CP/-hello world','CP/',1,1) and it worked. Then I tried just putting one of my varchar database fields in an SQL expression and this worked fine...

I opened the SQL expression editor and create an expression called getComplaint. This is the text I pasted in it: Cast(Rtrim(SUBSTR(PRO_WARRANTS."NARRATIVE", INSTR(PRO_WARRANTS."NARRATIVE",'[',1,1),(...

I appreciate all the work you've done on this, but I don't quite understand why it doesn't apply to my report. Even when using the driver you listed, I'm getting ODBC errors that I have invalid functions (Cast, Instr, and Substr are not recognized). So I tried just using the convert function...

Sorry for the lack of information the first time. I have a long/memo/blob text field in the database. I need to check for the pattern "CP/" at the beginning of the text. If that's found, then following that will be text between two brackets []. I need that text. Thanks again for...

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.

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...

Thanks for the advice. I did a "Show Query SQL" and tried the sql through sqlplus and it didn't work. The datetime sql that CR 8.5 was spitting out couldn't be handled by my ancient ODBC driver. I updated my client and ODBC drivers to Oracle 8 and everything's working fine.

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...

Thanks for your help. I must have been blind to miss that option on the menus. Need more caffeine, I guess.

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...

Thanks for everyone's help. It's working now. I ended up putting in blank date criteria and seeing that it indeed wanted DateTime(#,#,#,#,#,#) as input - thanks k

One more note: I just realized that my subreport didn't exactly work perfectly like I said. Even though my select expert formula says {TABLE.ENTRYDATE} <= {?Pm-@endDate}, the actual SQL (under Show SQL Query) is shown as TABLE.&quot;ENTRYDATE&quot; < ? Am I going crazy? If I have less...

to synapsevampire Thanks for the information. I tried something similar to what you said and neither date criteria (start or end date) is used properly. Do I need some kind of evaluation time specified? @startDate: DateTime(Minimum({?dateRange}),Time(0,0,0)) @endDate...

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 &quot;Show SQL Query&quot; is chosen...

Actually, it's not redundant and selects only the 'HOME' records or returns nulls. I was hoping there would be a solution other than editing the sql directly, since someone less technical than I am will be maintaining the report. Guess I'll just have to go beat up on someone to get permission...

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...

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...