Re[2]: [firebird-support] Scalability of connection numbers of client-server solution with Firebird 3.0?

Hi First let me tell that I'm not Firebird expert, I can only share my experience. In one system I have desktop application based on IBObjects with concurrent users around 80-90 and REST service (for mobile application) based on ZEOS with around 10 concurrent connections. All is serverd by Xe

Re: [firebird-support] How do I limit an SQL search list to 10 records?

Hi SELECT FIRST 10 * FROM A_TABLE Should work Cheers Marcin -- Wiadomość oryginalna -- Od: "Clyde Eisenbeis cte...@gmail.com [firebird-support]" Do: firebird-support@yahoogroups.com Data: 12.12.2019 19:59:44 Temat: [firebird-support] How do I limit an SQL search list to 10 records

Re[2]: [firebird-support] Link system tables to trigger

Olaf If you use same firebird user for all application users, I assume that you have some list of users within your database. Then you can set a variable for connection named i.e. my_current_user, fill it from the application and then use it in i.e triggers in the same manner that you would us

Re: [firebird-support] Firebird vs. PostgreSQL

Alexey I can confirm that it is possible to 'compile' SP with error that will appear during SP execution. Probably the most annoying thing in the world for Firebird users ;-) I hate it. Marcin -- Wiadomość oryginalna -- Od: "Alexey Kovyazin a...@ib-aid.com [firebird-support]" Do: fir

[firebird-support] Security per database - migrating from FB 2.5

Hi I'm trying to migrate my FB 2.5 database to FB 3. First step went ok - I have restored backup file with FB3 gbak and my application works ok. Now I would like to have "security per database". So I added following entries to databases.conf zt1 = /db/zt1.fb3 { SecurityDatabase = zt1 } Apparen

[firebird-support] Left join derived table

Hello All I'd like to ask how to get below statement working: SELECT A.FIELD_1, A.FIELD_2, D.FIELD_D1, D.FIELD_D2 FROM TABLE_A A LEFT JOIN (SELECT FIRST 1 FIELD_D1, FIELD_D2 FROM TABLE_D D WHERE D.FIELD_3 = A.FIELD_3 ORDER BY D.ID DESC) D ON (1=1) Firebird complains that A.FIELD_3: Column does

Re[2]: [firebird-support] deploy Windows Application to access Firebird database

Alain Just a simple question - does your client system know that it should look "compaq-proliant' under address 192.168.1.125? Try to replace name with IP address and see if client connects Marcin -- Wiadomość oryginalna -- Od: "Alain Bastien alainbast...@gmail.com [firebird-support]"

Re[2]: [firebird-support] 'Invalid expression' error in GROUP BY when field based on a SQL statement is used in SELECT field list

Of cousre it should be Group by 1, 2 Fingers too quick - sorry Marcin -- Wiadomość oryginalna -- Od: "'Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support]" Do: firebird-support@yahoogroups.com; firebird-support@yahoogroups.com Wysłano: 18.01.201

Re: [firebird-support] 'Invalid expression' error in GROUP BY when field based on a SQL statement is used in SELECT field list

Steve Try : Grou by 1,2 instead of GROUP BY ReceiptID, Service Marcin -- Wiadomość oryginalna -- Od: "stevef...@yahoo.com [firebird-support]" Do: firebird-support@yahoogroups.com Wysłano: 18.01.2016 09:50:08 Temat: [firebird-support] 'Invalid expression' error in GROUP BY when fiel

[firebird-support] Creating proper index

Hi I have a table that has (among others) two fields: BL_PREFIX VARCHAR10 BOOKING_NO INTEGER Column BL_PREFIX will have two, maximum three values I need that following statement should be as fast as possible: SELECT MAX(BOOKING_NO) FROM BOOKINGS WHERE BL_PREFIX = :BL_PREFIX Is the compound des