Recent content by beckybear

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