Search results for query: *

I have downloaded the .zip and extracted to a folder. I can run launchpad.exe and see the options. Every installation wizard launches fine except the one for the Application Server. It throws up a javascript prompt for the location of the WAS ND cd. I enter the path to the extracted files...

Crystal XI I have a report with a subreport, and am passing shared variables from the subreport to the main report. Obviously I had to place the shared variable in a section below the subreport on the main report to get them to display correctly (Group Header A and B). I underlayed Group...

I have a report that pulls data from 2 different tables. The join is left outer because I want to see every record in the base table, and only records that match from the other table. This worked fine until I had to add selection criteria on the second table...which of course kills the left...

I am connecting to an ORACLE database using ODBC. This database has a TON of tables in it, and I can't see them all in the database explorer. Is there a limit to how many tables will display?

Hi. We have 2 separate tablespaces for our data and our index. My question is, what causes the index space to grow (often times faster than the data tblspace)? For example, I have 2 separate Oracle instances (PROD and TEST) and we often truncate testdata and copy proddata into it. Everytime...

Is there a way to have a cron job kick off a script every other thursday? I couldn't figure it out using days of the week, so I was wondering if I scheduled on an "on" thursday and then had it run on 14 day intervals or something like that.

I have a form with several text objects in which the user can freetype. I am converting them to uppercase with an onchange event as shown below. My question: is there a simple way to also strip out any special characters either onchange or onblur? + '<tr><td align=left nowrap><strong>First...

We have a need to print multiple copies of a file to a UNIX print queue. Is there a way to collate the copies rather than having them print all the pages of the file once, then again twice, etc etc. What we want is all 5 copies of page 1, then all 5 copies of page 2, etc etc I saw the...

Hello. I am trying to write a report showing only records that meed certain criteria. I have a table with employee number and pay code for instance. The employee record is repeated for every pay code record. I have grouped by employee, and listed the paycodes in that group. The problem is...

Is there a way to control the text in an alert box? IE font size, bold, underline, etc....also is there a way to size the alert box itself? Thanks, JW

I'm using a MFCobol program in an interface to pick up a file ftp'd from another server for processing. Intermittently, I receive a 9 0018 error file status on that file (which equates to Read Error: Reached EOF before EOR or open in wrong mode). I'm guessing that because both of these jobs...

I have a textbox that is free text on a form. I want to append a '#' sign at the beginning of whatever the user types in this box. Could this be handled with an onchange event so that it happens as soon as the user clicks outside, or tabs away from this box? Or is there a better way? Thanks...

Hello all. I am trying to fill in records in a column via a formula. Basically, the spreadsheet was created from a text import that contained header records. I want to repeat that header value for each detail line, then when the header value changes, fill it in the next section. I've done...

I have a COBOL program that reads a DB and strings together a pipe (|) delimited flat file. Once the file creation is complete, it calls a section to invoke a shell script to move the file from one server to another. Something about the pipe delimiter causes the function to fail. Things to...

I would like to read a dataset and only show me the records where a particular field contains double quotes ("). The problem is, when trying to write the formula, it assumes I'm trying to encapsulate something in quotes and gives the error "the matching quote is missing for opening quotes"...

Hello all. I have a table where the records are set to autonumber. There is a form built that references that table. The problem is, when records are deleted from that table, the auto number doesn't resequence. Then the form that references that table shows blank lines where the deleted...

I have a process written in access that imports a text file, runs a make table query against the imported table (to do some reformatting, record selection, etc) then exports the made table to a fixed length text file. This works like a champ, and I will automate it with a VB module. The...

Hello all. I have a file with several records (all of which are 94 characters in length). The problem is that there are no carriage returns/line feeds in the file...sooooo when you view the file (in a text editor) it appears as one long record. Is there a piece of code that could import this...

I have a piece of VB code within an Access Database that imports a csv file, runs a make table query against the imported table, renames both tables, then exports the data to a fixed length text file. During the make table query, Access gives the standard &quot;you are about to paste xxx...

I have a program that reads a csv file and loads it to an Oracle database. The program works fine using a sample file that I created in Excel. However, in the real world, it needs to use a file extracted from another system. This extract encases every fields' value in quotes &quot; &quot...