ODP: Re: [firebird-support] How to add previous column value to current value?

I can't. sql is generated dynamicly Wysłano ze smartfonu Sony Xperia™ Użytkownik Michal Kurczabinski michk...@gmail.com [firebird-support] napisał >  > >Try this: > >select t.name, t.data, coalesce(t.data -(select data from t1 d where d.id = >t.id -1),0) from t1 t > >-- >regards,

RE: [firebird-support] How to add previous column value to current value?

let's assume that I have 2.5.3 Pozdrawiam Piotr Olszewski -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Tuesday, March 29, 2016 11:45 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] How to add pre

[firebird-support] How to add previous column value to current value?

date3-date2 sql is generated dynamically and it's quite complicated so i can't use procedure to do this. Regards Piotr Olszewski

ODP: Re: [firebird-support] Subquery and returning "0"

Hej Jak poprzednicy do końca nie wiem o co Ci chodzi. Może zamiast case when wykorzystaj funkcję COALESCE, która zwraca pierwsza wartość nie Null. Chyba ze po prostu zapytanie nie zwraca Ci żadnych pozycji wówczas będziesz miał zawsze null. Jeśli Ci nie za bardzo pomogłem lub potrzebujesz w

[firebird-support] Number list without table

Hi I need to get list of number (f.e 1,2,3,4,5) as rows but using only SQL query (without extra table or view). Something what after running query looks like: List_of_numbers --- 1 2 3 4 5 Any ideas?? Piotr [Non-text portions of this message have been r

Re: [firebird-support] Delphi XE2. Migrating from IBX components

I worked with delphi 6 with IBX components and FB database. Now i have RAD Studio XE2 and i'm still working with IBX components included in XE2. Works great. Dnia 2013-03-11 16:54 Precious So napisał(a): >Try to use the dbexpress. Its built in delphi xe2 and already has support >in firebird. >O

Re: [firebird-support] UDF 64 bits

Hi again... One question about UDF on 64-bits Firebird server, do I need to recompile dll's with 64 - bits RAD?? or can I use compiled with 32 bits Delphi 2007 Piotr Dnia 2012-12-05 00:56 Slavomir Skopalik napisał(a): >Hi, typical problem with "unable to load" is dependency on another dll. >Y

Re: [firebird-support] UDF 64 bits

Hello Maybe the problem is that we have to re-compile our dll's as 64 bits. Piotr Dnia 2012-12-04 15:56 Sergio H. Gonzalez napisał(a): >Hello... I think I've posted this question before, but now can't find >the thread... Anyway I still have the problem... > >An UDF that worked f

[firebird-support] Problem with sorting string field like nuber field conteins numbers at the begining and sometimes letters after number.

d it works when field conteins only numbers. When i try to use with a letter on the end it doesn't work correctly. f.e 12 13 15 .. .. .. 139 13a 140 i need: 12 13 13a 14 15 Any ideas?? Pozdrawiam Piotr Olszewski [Non-text portions of this message have been removed]