Re: [firebird-support] Re: 2.5.9 - LOCALTIME

2019-08-05 Thread DougC d...@moosemail.net [firebird-support]
Try creating a view on the table that includes renaming the column to another name but otherwise includes all other columns in the table and nothing else (no joins, etc). Then reference that view in the connected code instead of referencing the actual table. On Mon, 05 Aug 2019 11:58:53

[firebird-support] Re: 2.5.9 - LOCALTIME

2019-08-05 Thread m-zs...@freemail.hu [firebird-support]
Hi Mark! Database dialect is 1 and changing the column name and the connected code is not an option either at the moment, unfortunately. Thanks for the answer though. Best regards Zsolt

Re: [firebird-support] 3.x - Check if DB exist using alias

2019-08-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-08-05 15:58, 'Zoran' zoran...@gmail.com [firebird-support] wrote: > What Dimitry said, or you can try this: > > > > > > function _GetAliasDBFName(alias): string; > > var > > sl: TStringList; > > begin > > result := ''; > > sl := TStringList.Create; > > try >

Re: [firebird-support] 3.x - Check if DB exist using alias

2019-08-05 Thread Elmar Haneke el...@haneke.de [firebird-support]
There are some important preconditions on this: 1. The Program has to run locally on the server 2. It does need read permissions to that file 3. You need to know where firebird server is installed Am 05.08.19 um 15:58 schrieb 'Zoran' zoran...@gmail.com [firebird-support]: > What Dimitry said,

Re: [firebird-support] 2.5.9 - LOCALTIME

2019-08-05 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-08-05 11:56, Zsazsi m-zs...@freemail.hu [firebird-support] wrote: > Hi Everyone! > > Can You recommend a simple workaround on the new LOCALTIME variable > when the very same name is used as column name in a table? Either rename the column, or use quotes around the column name. The latte

RE: [firebird-support] 3.x - Check if DB exist using alias

2019-08-05 Thread 'Zoran' zoran...@gmail.com [firebird-support]
What Dimitry said, or you can try this: function _GetAliasDBFName(alias): string; var sl: TStringList; begin result := ''; sl := TStringList.Create; try sl.LoadFromFile('C:\Program Files\Firebird\Firebird_3_0\databases.conf'); result := sl.Values[alias

Re: [firebird-support] 3.x - Check if DB exist using alias

2019-08-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.08.2019 14:05, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support] wrote: > Which is the best way to check if a database exist if my connection is alias > based? > > I have to try to connect and manage response? Yes, this is the only way. -- WBR, SD. -

[firebird-support] 3.x - Check if DB exist using alias

2019-08-05 Thread 'P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support]
I'm using Delphi. Which is the best way to check if a database exist if my connection is alias based? I have to try to connect and manage response? Is there another way? Fabio Codebue P-SOFT di Codebue Fabio Via Nuova n. 9 - 24060 Tavernola B.sca (BG) P.I. 03624950162 C.F. CDBFBA72A11C618

[firebird-support] 2.5.9 - LOCALTIME

2019-08-05 Thread Zsazsi m-zs...@freemail.hu [firebird-support]
Hi Everyone! Can You recommend a simple workaround on the new LOCALTIME variable when the very same name is used as column name in a table? Thanks in advance Regards Zsolt