On 21-12-2017 03:06, FSPAPA INCA Team i...@foodstuffs-si.co.nz
[firebird-support] wrote:
> I reckon this change to src/remote/server/server.cpp in commit
> 2fdb281759299f24d47349246f3c800ec78971cc introduced an unintended effect:
I think you're right. I'll create a ticket in the tracker for
I reckon this change to src/remote/server/server.cpp in commit
2fdb281759299f24d47349246f3c800ec78971cc introduced an unintended effect:
@@ -1715,11 +1814,8 @@ static bool accept_connection(rem_port* port, P_CNCT*
connect, PACKET* send)
for (const p_cnct::p_cnct_repeat* const end =
Hmm, that’s interesting thanks Mark… when connecting to a Firebird 3.0.1
server, I see this in mon$attachments (where mon$system_flag=0):
MON$REMOTE_PID MON$REMOTE_PROCESSMON$REMOTE_PROTOCOL MON$REMOTE_VERSION
-- -----
Hello Helen
I understand that we shouldn't mess up with IDENTITY column, as you said. I
have the same problem as original poster and I'm using this code
SELECT G.RDB$GENERATOR_NAME
FROM RDB$RELATION_FIELDS AS G
WHERE G.RDB$RELATION_NAME = 'CUSTOMER'
AND G.RDB$FIELD_NAME = (SELECT
On 19-12-2017 04:32, FSPAPA INCA Team i...@foodstuffs-si.co.nz
[firebird-support] wrote:
> I’ve been testing a set of apps that use the InterBase 7.5.1 client
> library against Firebird 3.0.2 and have found them to be sufficiently
> compatible (with minimal changes). However after updating a
As I answer you on your first time question - use this query to get next ID.
Then supply this ID in your next INSERT query.
select
gen_id(GEN_TABLENAME, 1)
from RDB$DATABASE
Where GEN_TABLENAME - generator for your A.ID column. In this case you not need
to declare you column as IDENTITY.
2017. 12. 19. 21:13 keltezéssel, setysvar setys...@gmail.com
[firebird-support] írta:
> Why would you want collate AFTER containing? I must admit I haven't
> tried your queries in Fb 3.0 (I'm still on 2.5), but I'd say the
> sensible way to specify what you want, would be
>
> SELECT * FROM