AW: AW: [firebird-support] Converting with parameters stored in variables?
Helle Karol, thank you, now it works and it is more easier. I have modified this: SELECT lpad(cast(TRUNC(x.a) as integer), :i_anz, '0') || '.' || lpad((X.A-TRUNC(X.A))*X.B, 3, '0') FROM (SELECT cast(:z_str as double precision) AS A, POWER(10,:i_anz2) AS B FROM RDB$DATABASE) X Without cast as integer I get the 100 to the left (100.300) (11.3), without casting as double precision, I get an error, cannot work with strings. Thanks again 😊 Von: firebird-support@yahoogroups.com Gesendet: Samstag, 31. August 2019 09:20 An: firebird-support@yahoogroups.com Betreff: ODP: AW: [firebird-support] Converting with parameters stored in variables? >>Trunc instead of pow? I only mean that you do not need to operate on strings to separate number. A = 123.45 – numeric not a double A1 = TRUNC(A) A2 = (A-A1)*POWER(10,3) Then A1 = 123 A2 = 450 SELECT LPAD(TRUNC(X.A), 10, '0') || '.' || LPAD((X.A-TRUNC(X.A))*X.B, 3, '0'), FROM (SELECT 100.12 AS A, POWER(10,3) AS B FROM RDB$DATABASE) X Regards, Karol Bieniaszewski
Re: [firebird-support] FB3 Embedded Firedac Error
Thank you all for the replies. All your questions are above together: 1. Is it Windows application? Yes. 2. Is it 32 bit application or 64 bit? 32 . 3. Which version of Delphi? Last one, 10.3.2 Rio. 4. How your Firedac connection params looks like? Database=D:\Desktop\Server\DB.FDB CharacterSet=UTF8 User_Name=sysdba Password=masterkey DriverID=FB (Embedded property of FDPhysFBDriverLink is set to True) 5. This error occurs when you are using a 'fbclient.dll' that doesn't have access to 'plugins/engine12.dll'. 5b. This error can occur if your application is 32 bit and the Firebird files are 64 bit (or vice versa), then at runtime it could loads a different fbclient.dll. ==About my installation and Fbclient.dll== \Windows executable installer/ https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3..0.4.33054_0_Win32.exe: C:\Program Files (x86)\Firebird\Firebird_3_0\fbclient.dll \Zip kit for manual/custom installs/ https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3..0.4.33054-0_Win32.zip: D:\Desktop\Server\EDBMS\fbclient.dll Both are the same file: 3.0.4.33054 and both with 1.369.088 bytes. 6. You could use sysinternal procmon to check which files actually get loaded and used. Apparently, there's no need and I even don't know how to do it. 7. In firebird.conf, what is the setting for Providers? #Providers = Remote,Engine12,Loopback But i also tried only: #Providers = Engine12 I also need to say that I did it following steps on ibphoenix tutorial:https://www.ibphoenix.com/files/Embedded_fb3.pdf Em segunda-feira, 2 de setembro de 2019 03:56:03 BRT, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] escreveu: Â Hi 1. Is it Windows application?2. Is it 32 bit application or 64 bit?3. Which version of Delphi?4. How your Firedac connection params looks like? Regards,Karol Bieniaszewski #yiv0035744217 #yiv0035744217 -- #yiv0035744217ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0035744217 #yiv0035744217ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0035744217 #yiv0035744217ygrp-mkp #yiv0035744217hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0035744217 #yiv0035744217ygrp-mkp #yiv0035744217ads {margin-bottom:10px;}#yiv0035744217 #yiv0035744217ygrp-mkp .yiv0035744217ad {padding:0 0;}#yiv0035744217 #yiv0035744217ygrp-mkp .yiv0035744217ad p {margin:0;}#yiv0035744217 #yiv0035744217ygrp-mkp .yiv0035744217ad a {color:#ff;text-decoration:none;}#yiv0035744217 #yiv0035744217ygrp-sponsor #yiv0035744217ygrp-lc {font-family:Arial;}#yiv0035744217 #yiv0035744217ygrp-sponsor #yiv0035744217ygrp-lc #yiv0035744217hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0035744217 #yiv0035744217ygrp-sponsor #yiv0035744217ygrp-lc .yiv0035744217ad {margin-bottom:10px;padding:0 0;}#yiv0035744217 #yiv0035744217actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0035744217 #yiv0035744217activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0035744217 #yiv0035744217activity span {font-weight:700;}#yiv0035744217 #yiv0035744217activity span:first-child {text-transform:uppercase;}#yiv0035744217 #yiv0035744217activity span a {color:#5085b6;text-decoration:none;}#yiv0035744217 #yiv0035744217activity span span {color:#ff7900;}#yiv0035744217 #yiv0035744217activity span .yiv0035744217underline {text-decoration:underline;}#yiv0035744217 .yiv0035744217attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0035744217 .yiv0035744217attach div a {text-decoration:none;}#yiv0035744217 .yiv0035744217attach img {border:none;padding-right:5px;}#yiv0035744217 .yiv0035744217attach label {display:block;margin-bottom:5px;}#yiv0035744217 .yiv0035744217attach label a {text-decoration:none;}#yiv0035744217 blockquote {margin:0 0 0 4px;}#yiv0035744217 .yiv0035744217bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0035744217 .yiv0035744217bold a {text-decoration:none;}#yiv0035744217 dd.yiv0035744217last p a {font-family:Verdana;font-weight:700;}#yiv0035744217 dd.yiv0035744217last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0035744217 dd.yiv0035744217last p span.yiv0035744217yshortcuts {margin-right:0;}#yiv0035744217 div.yiv0035744217attach-table div div a {text-decoration:none;}#yiv0035744217 div.yiv0035744217attach-table {width:400px;}#yiv0035744217 div.yiv0035744217file-title a, #yiv0035744217 div.yiv0035744217file-title a:active, #yiv0035744217 div.yiv0035744217file-title a:hover, #yiv0035744217 div.yiv0035744217file-title a:visited {text-decoration:none;}#yiv0035744217 div.yiv0035744217photo-title a, #yiv0035744217 div.yiv0035744217photo-title a:active, #yiv0035744217 div.yiv0035744217photo-title a:hover, #yiv0035744217 div.yiv0035744217photo-title a:visited {text-decoration:none;}#yiv0035744217 div#yiv0035744
Re: [firebird-support] FB3 Embedded Firedac Error
On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > /5. This error occurs when you are using a 'fbclient.dll' that doesn't have > access to 'plugins/engine12.dll'./ > /5b. This error can occur if your application is 32 > bit and the Firebird files are 64 bit (or vice versa), then at runtime > it could loads a different fbclient.dll./ > > *==About my installation and Fbclient.dll==* > *\Windows executable installer/* > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054_0_Win32. > > exe: > C:\Program Files (x86)\Firebird\Firebird_3_0\fbclient.dll > > *\Zip kit for manual/custom installs/* > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0_Win32.zip: > D:\Desktop\Server\EDBMS\fbclient.dll > > *Both are the same file: 3.0.4.33054 and both with 1.369.088 bytes.* > /6. You could use sysinternal procmon to check which files actually get > loaded and used./ > > *Apparently, there's no need and I even don't know how to do it.* Why is there "no need"? If you want to solve your problem, it is good to know which libraries get loaded by your application. I have only ever seen this error when plugins\engine12.dll is either not present in the folder with fbclient.dll, or with different bitness between application and client, or client and engine12.dll. > /7. In firebird.conf, what is the setting for Providers?/ > > *#Providers = Remote,Engine12,Loopback > *But i also tried only:* > * > *#Providers = Engine12* When it is prefixed with a # it is a comment, if you want to try with Providers = Engine12, then you need to remove the #. Mark -- Mark Rotteveel
Re: [firebird-support] Restore from .bak
On 28-8-2019 15:14, william short bshort1...@yahoo.com [firebird-support] wrote: > Hopefully I am posting this to the correct group. I am backing up a new > Firebird database with SQLServerBooster (version 2.3.15). Windows Server > 2012 R2. It creates a .zip with a .bak inside. I would like to test > restoring from that to make sure it works. I have no idea how to do that. If it is using gbak to create the backup, you can use check the gbak documentation: https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak.html If it is using nbackup, see https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/nbackup.html Mark -- Mark Rotteveel
Re: [firebird-support] FB3 Embedded Firedac Error
Thanks, Mark! It worked! I also notice something very interesting during my tests: 1. No matter if you use Firebird if a Service or Application, even without installing the guardian:Stop the Service or do Shutdown of the Application on tray icon has zero effect! It stays working normally on Delphi, IB-Expert and in your Applications.You really need to completely uninstall Firebird on Windows Settings. 2. Delphi (Firedac at least) in Design Time uses BY DEFAULT Firebird installed on your machine, whatever if it is stoped or running (explained above).On Runtime it will use the settings that you have, to use Embedded. So, stay alert: You can't use Embedded in Design Time if you have Firebird installed on or machine. You need a complete uninstall to do it. Anyway, it works! Thanks again. Em terça-feira, 3 de setembro de 2019 02:00:25 BRT, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] escreveu:  On 3-9-2019 05:38, Elton Fadel galdari...@yahoo.com.br [firebird-support] wrote: > /5. This error occurs when you are using a 'fbclient.dll' that doesn't have > access to 'plugins/engine12.dll'./ > /5b. This error can occur if your application is 32 > bit and the Firebird files are 64 bit (or vice versa), then at runtime > it could loads a different fbclient.dll./ > > *==About my installation and Fbclient.dll==* > *\Windows executable installer/* > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054_0_Win32. > > exe: > C:\Program Files (x86)\Firebird\Firebird_3_0\fbclient.dll > > *\Zip kit for manual/custom installs/* > https://github.com/FirebirdSQL/firebird/releases/download/R3_0_4/Firebird-3.0.4.33054-0_Win32.zip: > D:\Desktop\Server\EDBMS\fbclient.dll > > *Both are the same file: 3.0.4.33054 and both with 1.369.088 bytes.* > /6. You could use sysinternal procmon to check which files actually get > loaded and used./ > > *Apparently, there's no need and I even don't know how to do it.* Why is there "no need"? If you want to solve your problem, it is good to know which libraries get loaded by your application. I have only ever seen this error when plugins\engine12.dll is either not present in the folder with fbclient.dll, or with different bitness between application and client, or client and engine12.dll. > /7. In firebird.conf, what is the setting for Providers?/ > > *#Providers = Remote,Engine12,Loopback > *But i also tried only:* > * > *#Providers = Engine12* When it is prefixed with a # it is a comment, if you want to try with Providers = Engine12, then you need to remove the #. Mark -- Mark Rotteveel #yiv0610135399 #yiv0610135399 -- #yiv0610135399ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0610135399 #yiv0610135399ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0610135399 #yiv0610135399ygrp-mkp #yiv0610135399hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0610135399 #yiv0610135399ygrp-mkp #yiv0610135399ads {margin-bottom:10px;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad {padding:0 0;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad p {margin:0;}#yiv0610135399 #yiv0610135399ygrp-mkp .yiv0610135399ad a {color:#ff;text-decoration:none;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc {font-family:Arial;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc #yiv0610135399hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0610135399 #yiv0610135399ygrp-sponsor #yiv0610135399ygrp-lc .yiv0610135399ad {margin-bottom:10px;padding:0 0;}#yiv0610135399 #yiv0610135399actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0610135399 #yiv0610135399activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0610135399 #yiv0610135399activity span {font-weight:700;}#yiv0610135399 #yiv0610135399activity span:first-child {text-transform:uppercase;}#yiv0610135399 #yiv0610135399activity span a {color:#5085b6;text-decoration:none;}#yiv0610135399 #yiv0610135399activity span span {color:#ff7900;}#yiv0610135399 #yiv0610135399activity span .yiv0610135399underline {text-decoration:underline;}#yiv0610135399 .yiv0610135399attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0610135399 .yiv0610135399attach div a {text-decoration:none;}#yiv0610135399 .yiv0610135399attach img {border:none;padding-right:5px;}#yiv0610135399 .yiv0610135399attach label {display:block;margin-bottom:5px;}#yiv0610135399 .yiv0610135399attach label a {text-decoration:none;}#yiv0610135399 blockquote {margin:0 0 0 4px;}#yiv0610135399 .yiv0610135399bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0610135399 .yiv0610135399bold a {text-decoration:none;}#yiv0610135399 dd.yiv0610135399last p a {font-family:Verdana;font-weight:700;}#yiv0610135399 dd.yiv0610135399last p span {margin-right:10px;font-family:Verdana;fon