Subject |
Re: setting default value of fields |
From |
Mervyn Bick <invalid@invalid.invalid> |
Date |
Sun, 7 Jul 2024 12:44:28 +0200 |
Newsgroups |
dbase.getting-started |
On 2024/07/07 10:49, Mustansir Ghor wrote:
> Dear Mervyn Sir, Ken Sir and Heintz
>
> Thank You all for you solutions but in my case I can not use it.
>
> The creation of table has 31 columns (days on month). I am using updateset object AppendUpdate method to either update or append records. The problem arises when the newly append records for a particular day are done. For these newly added records the other days fields gets null value. Hence for a particular record, to use its fields for calculations becomes difficult.
>
The updateset class can save one a lot of work but it only does what the
original programmer thought was necessary. If one wants something even
slightly different then one needs to write one's own code.
In this case, if the appendUpdate() method is updating existing records
without causing problems, you may be able use the update() method
instead of appendUpdate() to deal with existing records in the main
table. You would then only need to write code to deal with new records
which have to be added to the main table.
Go to first() in update rowset.
Scroll through the update rowset and findkey() the index key in the main
table rowset.
If found, skip.
If not found append record to main table.
Replace all fields with the required default.
Replace field in main table with field from update rowset with new data.
Save
Repeat to end of update rowset.
Requery main rowset
Mervyn.
|
|