Recent content by jbeale

Tom, Lunker, Glenn: Thank you all for your helpful advise. Based on your answers, I now understand the use of EVALUATE using ALSO. With this in mind, I will use what I have already coded, and will keep your responses in my TEK-TIPS folder. Jody

I read about the EVALUATE statement in the COBOL/370 Language Reference Guide and am having a difficult time understanding some of the ways to use ALSO. For example, the following is straight forward: EVALUATE ISS-STATE WHEN '22' PERFORM 22-PROCESSING WHEN '32' PERFORM...

Thank you for your information. I have the VB side of the code but the TrackRecord side is puzzling. I can't seem to get the contents of the field to be placed in the VB form. In TrackRecord, the screen that you fill out has 2 fields: 1) File name for the executable 2) Parameter control string...

I am trying to pass the contents of a field in Compuware's TrackRecord to a VB6 executable. The information below the line states the Help text in TrackRecord: ---------------------------------------------------------- Executable Button Properties Administrators can add a button to a type to...

Here are the answers as best as I can do for now...I thought (maybe ignorantly) that since everything worked when setting up the select expert in Crystal Reports (the SQL it generated looked very simple), I wouldn't have too much trouble setting up the SQL in VB. Answer to obvious question: I'm...

I am pulling information from 3 tables to place in a recordset then print to a text file. When I scale back and only request info from 1 table, I am successful. However, when I try to pull from the 3 tables that I need, I am unsuccessful. Here is the way the tables relate: T20 T03...

Thank you very much for your help. I tried to open the file. Acrobat sent a message back saying there was an error opening the file. Said file did not begin with %PDF- . I tried to detach it and rename it - that did not help so I sent it to my home email and will try it there. I'll let you know...

Brief history: I have created a form in VB which gives Users a chance to select the Userids they wish to report on. Their selection is collected in a listbox. I use a loop to create the record selection. I then want to pass this information to the report viewer, log on to the server, select the...

The only reason I am using Crystal Reports is that is the way the original project was presented to me. I don't actually present reports to the users until I have processed on the mainframe & those are created with EZ+. I am more than willing to get the information to build a txt file using...

Snaggs, Thank you for your help with the code. I do understand how to build the text file, what I do not understand how to do (yet!) is how to refresh the information based on the newly selected Userids. Here is an example of my selection criteria...but how do I refresh the infomation before...

I have thought of letting VB create the report for me; however, I do not know how to do this...Can you help? I still need a text file with information positioned the way I have it so the mainframe COBOL program can recognize it. I am VERY new to VB and am trying to teach myself. Someone had...

Brief history: We are gathering information using Crystal Reports 7.0 and exporting it as a text file. This information is FTPd to the mainframe for further processing. We needed a simple way for the users to select the Userids they need for the Crystal Report, then run the report & export...

Oddly enough, I have proof of the file keeping the extra spaces. That's why I created the file on the Mainframe side the way I did. For example, the policy number is 10 characters long. When I browse data in CR, its type is string, its length is 21 (11 blanks to the right). If I open this file...

I have recently had some trouble exporting a report as a CSV to a disk file. The process works great. My trouble is once I FTP this file to the Mainframe, the string data is compressed which makes it difficult for my COBOL program to deal with the fields. A couple of weeks ago, I did the same...