Re: [firebird-support] CTE Question

2017-04-28 Thread setysvar setys...@gmail.com [firebird-support]
Hi Olaf! First, SQL doesn't like unknown columns, you need to know at least the maximum possible number of properties to support. Having said that, you could try something like: select B1.Property, B2.Property, B3.Property, B4.Property from TableA A1 join TableB B1 on A1.ID = B1.ID_TableA left

[firebird-support] Re: FirebirdSQL 3 VMWare Windows

2017-04-28 Thread as...@yahoo.com [firebird-support]
Thank you so much Vlad for pointing me to the direction :) I've read it multiple times. So after I create another user as co admin, I can connect to the employee db using the ip address notation using the new user. But to be frankly, I still have no clue why I can not do it with SYSDBA.

Re: [firebird-support] FB3 - Limbo and consistency check

2017-04-28 Thread Gabor Boros mlngl...@bgss.hu [firebird-support]
Hi All, > record from transaction x is stuck in limbo Source of this is an IBX transaction handling problem which already fixed in SVN: https://svn.mwasoftware.co.uk/viewvc/public?view=revision=63

[firebird-support] CTE Question

2017-04-28 Thread 'Olaf Kluge' olaf.kl...@satron.de [firebird-support]
Hello, in advance, many thanks! I would like to combine all properties like this: Property1 Property2 Property3 Property4.. IP54 Yellow With lamp 30W IP20 Blue Without lamp

[firebird-support] complicated recursion or other option?

2017-04-28 Thread 'Olaf Kluge' olaf.kl...@satron.de [firebird-support]
Hello, in advance, many thanks! I would like to combine all properties like this: Property1 Property2 Property3 Property4.. IP54 Yellow With lamp 30W IP20 Blue