Search results

take a look at this thread http://progresstalk.com/showthread.php?t=103174

My pleasure :spiny:

try to change it with: FIND Customer WHERE Name = (GET-VALUE("user_name")) AND CustNum = integer(GET-VALUE("custNum")) NO-LOCK NO-ERROR. GET-VALUE() returns character and your CustNum field is (most probably) numerical

ON CHOOSE OF BUTTON-1 IN FRAME DEFAULT-FRAME /* Button 1 */ DO: define variable i as integer no-undo. do i = 1 to 10: message "yohn" view-as alert-box. end. END.

Hello, I have never used progress less than 9.1, but there are some nice and really easy to use reporting utilities. You have to start your app builder (of course, if progress 8.3 has such a thing), then go from Tools Menu to Data Administration. In Data Administration, from Database menu...

from Progress help on scrollable attribute: If the SCROLLABLE attribute is TRUE, the frame or dialog box can be bigger than the display space allotted to it (that is, it is scrollable). If SCROLLABLE is FALSE, the frame or dialog box must fit within the allotted display space; it cannot be...

This code produces exactly your output. define variable i as integer no-undo. define variable j as integer no-undo. output to "c:\crosstab.txt". do i = 1 to 4: do j = 1 to 4: if i eq 1 then put unformatted j " ". else if j eq 1 then put unformatted i " "...

Could you be more specific with what you need? Export from where to where?

Post your source code here and tell us exactly what you need.

Hi, Your approach can't do the job, because the &scoped-define SORTBY-PHRASE BY lh:NAME is evaluated at compile time and not at run time. You have to use the query asociated with the browse. Here is my suggestion: DEFINE VARIABLE ColumnName AS CHARACTER NO-UNDO. DEFINE VARIABLE hColumn AS...

Have you tried doing a CREATE <ttName> just before inserting the second record?

DEFINE VARIABLE cSalesRep1 AS CHARACTER NO-UNDO. DEFINE VARIABLE cSalesRep2 AS CHARACTER NO-UNDO. ASSIGN cSalesRep1 = "" cSalesRep2 = "". FOR EACH customer NO-LOCK WHERE cust-num > 10 GROUP BY sales-rep: cSalesRep1 = customer.sales-rep. IF cSalesRep1 <> cSalesRep2 THEN...

on the LEAVE trigger of the field, do the validation and if the input is invalid do a: APPLY "ENTRY":U TO <field-name>. Here is no need to specify the frame in which the field is. When you have several fields, do the same thing on every LEAVE trigger of each field.