Re: [Firebird-devel] Database in use when dropping database

2013-11-16 Thread Mark Rotteveel
On 13-11-2013 08:26, Dmitry Yemanov wrote: > 12.11.2013 22:11, Mark Rotteveel wrote: > >> Should I just file a bug? > > Feel free, we can always reject it > > Do you have a simple test case for this error? You said it was happening > in specific tests, so it should be reproducible. I will write u

[Firebird-devel] Subquery more then 1 field

2013-11-16 Thread liviuslivius
Hi,   many times i need to return more then one field from subquery  but this is not possible and then i must do some join and group by or write stored proc or other trick like concat fields by "||"   My question is "Is this because of SQL standard or this is not simple to develop?"     sample  

Re: [Firebird-devel] Subquery more then 1 field

2013-11-16 Thread Mark Rotteveel
On 16-11-2013 12:52, liviuslivius wrote: > Hi, > many times i need to return more then one field from subquery > but this is not possible and then i must do some join and group by or > write stored proc or other trick like concat fields by "||" > My question is "Is this because of SQL standard or t

[Firebird-devel] Odp: Subquery more then 1 field

2013-11-16 Thread liviusliv...@poczta.onet.pl
May be in FB4.0 :) Regards, Karol Bieniaszewski - Reply message - Od: "Mark Rotteveel" Do: "For discussion among Firebird Developers" Temat: [Firebird-devel] Subquery more then 1 field Data: sob., lis 16, 2013 15:47 On 16-11-2013 12:52, liviuslivius wrote: > Hi, > many times i need t

Re: [Firebird-devel] Subquery more then 1 field

2013-11-16 Thread Leyne, Sean
> many times i need to return more then one field from subquery but this is > not possible and then i must do some join and group by or write stored proc > or other trick like concat fields by "||" > > My question is "Is this because of SQL standard or this is not simple to > develop?" > > > s