[firebird-support] Re: Explicit Login with Windows Domain username

2020-04-19 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello, I posted a similar question on 20. September 2017 how to login with a windows domain username without using trusted authentication. At this time the answer was: ist not possible or you have to In the meanwhile I have some customers with FB 3.x and recognized that trusted authentication

AW: [firebird-support] Offtopic: Trigger before Insert: Firebird vs. MS SQL

2019-07-08 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
: Firebird vs. MS SQL 08.07.2019 16:55, 'Nikolaus Kern' parzival1...@gmx.at [firebird-support] wrote: > Is it possible that this works totally different in MS SQL? Yes, it works totally different in MS SQL. Yes, only AFTER and INSTEAD OF triggers are available there. Besi

[firebird-support] Offtopic: Trigger before Insert: Firebird vs. MS SQL

2019-07-08 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello all, I was looking into a very simple question on MS SQL (from a Firebird users point of view): Before INSERT I need to modify the incoming data: Example: INSERT INTO CUSTOMERS (NAME, AGE) value ('Test', 50); The trigger should simply decrease the age by 1 year. In Firebird it

AW: [firebird-support] Explicit Login with Windows Domain username

2017-09-20 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello Karol, do you suggest that I actually do the windows login to impersonate this user and then do a trusted authentication? Niko Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Mittwoch, 20. September 2017 16:53 An:

[firebird-support] Explicit Login with Windows Domain username

2017-09-20 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello, I am using trusted authentication with FB 2.5.x and it works very fine. Beside the desktop client I am using a windows service to connect to the database. In this scenario the username and password are provided by the login process of the mobile app that works with this windows service.

AW: [firebird-support] find a string records in all my tables

2017-01-11 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello, out of curiosity: Is this a one time search or should it happen regulary? If ist regulary – maybe the design should be reviewed? What are the requirements to run such a search? Is fulltextsearch an option? Niko Von: firebird-support@yahoogroups.com

AW: [firebird-support] Sorting CTE for List()

2016-04-26 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello Set, thank you very much for your support! I was aware of the fact, that LIST() is unsorted, but I did not expect the problem I described in this posting. It works very nice. Thanks again Niko -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com

[firebird-support] Sorting CTE for List()

2016-04-16 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello, I am using Firebird 2.5.5. and see following behaiviour: 1. One table is used to get the weekdays in a list 2. The other table is joined to identify those working schedules for these days 3. If the second table has a value in the field ANMERKUNG the sorting order

[firebird-support] Silent Installation SuperClassic

2016-01-26 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello all, is there a parameter to run a silent server installation for SuperClassic? I did not find it in the documentation, simply putting into the components list did not work. Firebird-2.5.5.26952_0_x64.exe /SILENT