Subject Re: [firebird-support] Re: SQL statement with multiply function
Author Alexandre Benson Smith
majstoru wrote:
> Hi Adam,
>
> Thanks for yours very fast reply!
>
> But I need this function for a printing a stickers, sometime a qty
> number can be very very large and this is a main reaso why I would
> like to just pass some SQL script and get a resultset that I need!
> Yours idea is a great, but how can I do this on client to spare
> network traffic and to be more eficient in n-tier setup?
>
> Thanks again!
>
Just

select Id, Name, Qty from Articles order by ID in your cliente app, then
do a loop for the qty value and print N labels.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br