Recent content by melmckee72

Interesting idea, but haven't been able to find anything about accumulating totals and subtotals in a dynamic query. How would I go about that?

I'm working with a program which creates a report with multiple output displays. All the same data but sorted differently in each iteration. I've got a temp-table created with all the data necessary, and trying to do the different sortations. I defined some variables as sortfield1, sortfield2...

Thank you so much. These were exactly the problems, one last thing I had to do was add a view frame statment before the "return no-apply" and bingo it works.

working in 9.1a chui environment working with updateable browse and having trouble with 2 things. first - if on leave trigger finds available record can not leave the browse (F1 does not send me to the next block of code) second - if on leave trigger does not find available record I get...

This is my first time using browse and query to search for and allow updating of fields within a table. I've gotten to the point where I've got the query working properly. I'm displaying 2 fields and have all enabled for updating. Problem is I can't get to the second field in the...

I am writing a program in which a user can update information within a table. I have a one to many relation between two tables within the database. I would like to be able to display all the records which meet the user's search criteria and then allow them to go through the fields one by one...

I'm working on a report that includes a field that I want to wrap at 30 chars wide. I've set up the variable as an editor. If I use size 30 by 2 it works perfectly except that on those lines when there is only 1 line of text filled, it inserts a blank line. If I set it to 30 by 1 all...

OK - that took care of my page break between the 1st and 2nd frame, but I still have a page break between the 2nd and 3rd. Any ideas?

I'm creating a report output, in which I am going through particular records and creating a temp-table. I'm then doing a for each loop on the temp-table to accumulate some fields data and create the display. I have several frames defined, and using first-of and last-of statements to...

Thanks for the info. removing the column specification worked.

Is there a limit to the size of the label when defining a frame layout? I'm creating a report layout in which I have 3 frames defined (so far). The first two are done with side-labels. My problem is that the second frame is cutting off the label to align the colons between the 1st and second...

Thanks Mike - that worked.

Question: I've defined an input variable using the view-as editor command and set it to an extent of 20. def variable mcampnotes as char view-as editor size 50 by 4 extent 20 no-undo. I've got a loop going through multiple times creating records, and when I get to the prompt-for...