AW: AW: [firebird-support] Converting with parameters stored in variables?

2019-09-02 Thread 'Check_Mail' check_m...@satron.de [firebird-support] 
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

2019-09-02 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support] 
 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

2019-09-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
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

2019-09-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support] 
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

2019-09-02 Thread Elton Fadel galdari...@yahoo.com.br [firebird-support] 
 
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