Search results

FrancoisL, That worked like a charm. Thank you very much.

Thank you for your response. I removed the "CHARACTER" from the SUBSTRING function and I still only get 8 characters.

I am attempting to extract a substring from an external file. I have an external .txt file which contains records of different lengths and type on each line. I import each line of the text file into a temporary table. Each line of text may be up to 200 characters long. I then use a FOR EACH...

I found that it was actually the NEXT statements I had in the routine. They just happened to fall on the last-of condition for that field. I replaced the next statements with some logic to either diplay or not display the record and then handled it later. Thanks for your replies.

Is there any way to sort by a calculated field other then creating temp-tables? I have a report that calculates Days Open, but only does this right before teh DISPLAY block. They want the report sorted by Days Open. With all of the toalling and summarizing going on in the report, I am afraid...

I am having problems with a report in that it is not hitting the IF statements based on the BREAK BY statements in teh FOR EACH block. Examples below. I am creating a report and my main FOR EACH block looks like the following: FOR EACH wo_mstr USE-INDEX wo_nbr NO-LOCK WHERE (wo_site >=...

I did try the code snippet. It seems to bypass the validation statement all-together regardless of the criteria I try to validate on. I am not sure why this is happening. I am going to validate it after the update statement for now. I agree that the wait-for would be better, I will have to...

Thank you all. I did end up using validation after the UPDATE statement in the form of an IF..THEN statement. I am still not sure why the VALIDATE statement was not working to begin with, and that still worries me, but it works and is fairly clean.

I added the code you provided because I did not think about the user leaving the fields blank, but that doesn't seem to help the problem. When I add the "or" conditions, the field does not validate at all, it accepts any value for edate1. If I simply have VALIDATE(edate1 >= edate) the...

I am trying to validate the input of a field during the UPDATE block. I have a simple date range and I want to make sure that the second date entered is greater than the first date entered. I have the followign code in place for the UPDATE, but it is not passing validation no matter what dates...

It was as simple as that Zee. Thank you very much. The simple things are often overlooked.

That does not work for some reason. I need to select all parts if the field is left blank, but the saved work table could still have values in it. I want to ignore the work table if the field is left blank.

I am working on a custom report that prompts the user for a range of locations, range of departments, allows the user to enter a list of "Hot" parts, a range of dates, etc. My prblem is that if the user blanks the parts list parameter out, I would like the report to find all the parts matching...

I think someone here actually found a solution. Below is an example of possibly how to use dynamic COLUMN-LABELs: define variable a as handle. define variable b as character. form b with frame dd width 80 down. assign a = b:handle in frame dd. assign a:label = "Bob"...

I am trying to use dynamic COLUMN-LABEL values. I have a report that displays values for the previous 6 months of the year. I would like to do this dynamically. I would like to figure out what month is to be displayed and use a variable in the COLUMN-LABEL tag instead of hard-coding the...

I am relatively new to QAD MFG/PRO, but I can try to help you out a little bit or at least try to add to what was already said. Without knowing where you want to pull the Unit Cost from, you can find the part number and the safety stock by using code similar to the following: FOR EACH pt_mstr...

Okay, I think I finally got it with everyone's help. I used logic to determine if the user wanted to export it to an Excel output file or display it on teh screen. After determining that, I converted the numeric fields that I was previously testing in the DISPLAY block into string variables...

It just must not be my day today. That didn't work either. I am getting teh same error when I try to run it. It doesn't seem to like any kind of conditional in the PUT block.

Thanks Eddiej, but I have also tried the PUT command. This doesn't work because I am using WHEN AVAILABLE after some fields in teh DISPLAY command. Here is my original DISPLAY block: DISP op_site COLUMN-LABEL "Location" op_dept COLUMN-LABEL "Dept" op_part COLUMN-LABEL "Part #" pt_desc1...

I don't think I can use IF..THEN..ELSE statements inside a DISPLAY command. Also, these fields are decimal fields so I can't just set them to "" outside of the DISPLAY command. This is one of those tricky situations for which I know there is a simple solution, but I just can't put my...