| Subject | RE: [firebird-support] Consecutive values from different fields |
|---|---|
| Author | Autoneer |
| Post date | 2019-01-28T07:54:40Z |
Thank you Lester, Omacht and Set
Sorry a simple oversight on my side it now works 100%.
Can this be run without having the end user input the variable i.e. :drivernr?
I want to programmatically provide the driver nr as I only need the result to populate a field in another table ?
Regards
Stef
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 27 January 2019 11:50
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Consecutive values from different fields
On 27/01/2019 08:03, 'Autoneer' myautoneer@... [firebird-support]
wrote:
> Thank you much appreciated, I would agree with Lester’s approach howeverYou need a ';' after the wd2 ... I think
> this an inherited DB.
Before we have CTE functions it was common to create temporary tables to
reformat the data and create triggers to copy data from the 'legacy'
tables to ones that make reporting easier. I'm still using some of the
same legacy stuff 20 years on ;) Creating the SQL for a CTE query is
often easier if one 'designs' the table one actually needs and then work
out how to build it much like the execute block is doing ...
--
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