Search results

it's too complicated to me. I use calling .i instead finally. Anyway, thank for your suggested solution.

Thank for your answer.

Is it possible to write a dynamic for each loop to display records on different sorting fields based on variable conditions?? i.e. when condition 1: for each table1 by field1: disp field1 field2. end. when condition 2: for each table1 by field2: disp...

oh yes, it works now, thx 2 chris. By the way, how long can the string PROPATH be? Moreover, is it true text replacement can't use varible?? table1 = "company". {getaddr.i &table-name = table1}. the upper does not work, any solution? Thank alot.

when I try to include a file, it always says .i was not found even I change the path already. I don't want to hard-code the path, how can I specify the path in a dynamic way?? start-up = "c:\library". RUN SetCurrentDirectoryA (INPUT start-up). {getaddr1.i &table-name = "company"}.

Thx chris. You're really a expert.

Can anyone tell me if I can use SQL statement in Progress? For example, I tried writing the follow statement aiming at find the number of records in a table but can't compile. def var a as int. a = select count(*) from table table_a. But it is okay just to type select count(*).....to...

I am too careless to ommit the case of 29 Feb. thx for all coding providers. I never think of calculating age could be so complicated.

finally I wrote this lines and I think should be perfect. staff-age = YEAR(today) - YEAR(pol-staff.date-birth). birth-this-year = DATE(STRING(MONTH(pol-staff.date-birth)) + "/" + STRING(DAY(pol-staff.date-birth)) + "/" +...

I also think of it but it still has small discrepancy.

Any smart guy can suggest how to caluculate the age in a smart way? I think of the follows but it has discrepancy when there are leap years between the birthday and today. age = (today - birthday) / 365.

Dear all, While I am browsing around the internet, I often find that some pics can't be loaded and red crosses come out at these positions. Anyone can tell me why and is there any recommendation? Thanks.

Hello all, This is an indispensible website for progress developers all around the world. I find so much treasurious information here!!. :chat:

Hi all guys, Is there a way to define an input parameter as optional in progress? Thanks, Kenneth