| Subject | Re: [firebird-support] Consecutive values from different fields |
|---|---|
| Author | Lester Caine |
| Post date | 2019-01-24T14:37:41Z |
On 24/01/2019 07:50, 'Autoneer' myautoneer@... [firebird-support]
wrote:
easy enough to DISPLAY a week at a time working from a table that has
single day records. The one can more easily scan the data for
'consecutive days' and also make calculations on 'hours' so giving the
right breaks between driving sessions.
--
Lester Caine - G8HFL
-----------------------------
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk
wrote:
> I have never worked with a recursive cte before and have no idea on howPersonally I'd start by reordering the data to a single field ... It's
> to go about this.
easy enough to DISPLAY a week at a time working from a table that has
single day records. The one can more easily scan the data for
'consecutive days' and also make calculations on 'hours' so giving the
right breaks between driving sessions.
--
Lester Caine - G8HFL
-----------------------------
Contact - https://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - https://lsces.co.uk
EnquirySolve - https://enquirysolve.com/
Model Engineers Digital Workshop - https://medw.co.uk
Rainbow Digital Media - https://rainbowdigitalmedia.co.uk