Incrementing a date field in a table frame

Incrementing a date field in a table frame

Post by Kuo-Sheng (Kas » Fri, 26 Aug 1994 10:02:36

: I am working in Paradox 4.5 for Windows and had someone ask me how they could
: increment a date field in a table frame.  Basically, the user wants to be able
: to enter an initial date in the first record of the table frame on a form and
: have Paradox fill in the dates for the rest of the week.  The form consists of
: a Person table which is keyed by some form of Person ID and a second table
: which is used as a work schedule for a week.  Each record in the table frame
: represents a different date.  The table frame will show only seven records.  
: Is there a good way to let the user enter a date in the first record of the
: table frame and then have the remaining dates in the week calculated from
: that?  

You will need to write some OPAL code (I assume you are using Windows,
PLEASE indicate version number in the Subject line next time).

There's a DATE data type in OPAL, which is the same as the Date Field
type.  You can increment the Date Data Type (EnteredDate=EnteredDate+1),
then do this multiple times with InsertRecord.


||   (the rest of this .sig is under construction...)                       ||


1. Table frames linked to table frames in a report

Is it possible to create a report which contains two linked tables e.g.
projects and estimates such that the report contains two table frames
with the estimates table being shown when there are estaimtes associated
with the project.

Project Project description
1       Blah                    
2       Blah2                  
3       Blah3                  

        Estimate        Description     Cost    }
        1               Test Est        $100    }linked to estimate 3
        2               Test Est 2      $200    }

Project Project description
4       Blah                    

        Estimate        Description     Cost
        1               Test Est 1      $200    

Project Project description
4       Blah                    
5       Blah2                  
6       Blah3                  

2. Programmers/Analysts for NY/CA locations

3. frame-field frame-file

4. Error in Q171146

5. Hiding a field in a Table frame?

6. How to print bar-code labels from DBF

7. Removing Fields from a Table Frame on a Form

8. PL/SQL - Procedure Builder

9. OPAL problems with unassigned values in table frame fields

10. P4Win, Summary fields in Table Frames?

11. Passing table field rows to an ABF frame

12. how tro create two auto-increment fields in one table

13. Incrementing a field in a table