Sure, just use: execute block returns ( consecutivedays integer ) as ... .... where drivernr = 697
Den man. 28. jan. 2019 kl. 08:54 skrev 'Autoneer' [email protected] [firebird-support] <[email protected]>: > > > 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:* [email protected] [mailto: > [email protected]] > *Sent:* 27 January 2019 11:50 > *To:* [email protected] > *Subject:* Re: [firebird-support] Consecutive values from different fields > > > > > > On 27/01/2019 08:03, 'Autoneer' [email protected] [firebird-support] > wrote: > > Thank you much appreciated, I would agree with Lester’s approach however > > this an inherited DB. > > You need a ';' after the wd2 ... I think > > 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 > > > > >
