O$5 (& O$10.2) Updating tables and column definitions from library updates via notation?
andyh at totallybrilliant.com
Thu Mar 11 21:29:26 UTC 2021
In simple terms and pseudo code, lets say we want to add a new field to table A
So lets call this change number 1
So we have a table called (let’s say) ‘updatesapplied’
This has (again let’s say) one column : updatenumber
So when we start, we fetch the highest update number in our updatesapplied table…..
So to start we get a null……
That means our last applied change number was 0 - ok ?
So we have a maintenance method here to see what needs updating at start, something like this :
If lastappliedchange < 1
Update table A with whatever change is required
If that works
Add row to updatesapplied with updatenumber = 1
Repeat as updates get created
So next time we start, our lastappliedchange would be 1 so we can easily skip over the requirement to update that table
Does that make sense better ?
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com <http://www.totallybrilliant.com/>
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com
> On Mar 11, 2021, at 2:59 PM, Das Goravani <goravanis at gmail.com> wrote:
> Could you explain how the number update system works again, try to be clear what data is kept and how is it searched later to update people.. I missed it
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en