Search results

  1. H

    calculate the last day of the month

    What I'm using is: Function MonthEnd Returns Date ( Input inDate As Date): Return ((Date(Month(inDate),28,Year(inDate)) + 4) - Day(Date(Month(inDate),28,Year(inDate)) + 4)). End. Disp MonthEnd(Today).
  2. H

    Progress x Preactor

    Hi Rick, I worked on Preactor interface years ago. Let me check if I can find any code. Thanks, Hakan
  3. H

    Get table properties of a given database

    Hi Serge, try this: DEFINE VARIABLE i AS INTEGER. REPEAT i = 1 TO NUM-DBS: DISPLAY LDBNAME(i) FORMAT "x(40)". END.
  4. H

    How to use SQL select result in a 4GL procedure

    The question is not which one is better, it is how to put SQL SELECT statement's results into temp table. Yours is "real" suggestion.
  5. H

    Customer Orders Report

    Hi, can you try "Order Maintenance" screen "Reports=>Order Reports=>Order Item" report (CO02-R) ?
  6. H

    How to use SQL select result in a 4GL procedure

    Hi Popsin, As far as I understand you are looking for something like that: Define Variable iNum As Integer No-undo. Define Variable cName As Character No-undo. Define Temp-table ttCust Field tNum Like Sports2000.Customer.CustNum Field tName Like Sports2000.Customer.Name...
Back
Top