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.
Repeat to end of update rowset.
Requery main rowset