[firebird-support] Re: Re: error during the registratione of data on 2.5 FB database. SOLVED

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He, Mark, You are reason (as always *_*)
I've made many changes in the source code, but the result is not changed.
After checking the default values for all the fileds in the table, I've
discovered that many fields of type smallint have a default setted to
'' (char void) rather then 0 (zero)... what a stupid!!!
The error is referred to fields not inserted in the comand line INSERT, for
which Firebird has considered the default '' rather then 0.
Thanks for interest. More attention from me would not have made lose 4 days
to me and precious time to you.
Best regards.

Antonio BIANCA

- - - - - - - - -

Il 04/04/2020 10:57, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] ha scritto:

>
> On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia..com
> [firebird-support] wrote:
> > He,
> > I've an error that I don't undestrand.
> > I use Delphi 7 environment to create my applications, Zeos components
> > for connections and Firebird 2.5 Superserver for database management.
> > To register the data, my App uses the processor component; the
> > Connection.Autocommit  parameter is set to False.
> > My App inserts numerous lines of data to be recorded in the Process
> > component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT
> > INTO ZXD...'; UPDATE FGH SET ...'; and so on);
> > at the end, it adds the command "COMMIT;", then call "PARSE", and 
> "EXECUTE".
> > The lines 4 and 5 of the processor script contains the data mistaken,
> > but I don't undestand where is the eror.
> > The exception raised by the server is:
> > ---
> > SQL Error:  conversion error from string "". Error Code: -413. Overflow
> > occurred during data type conversion.
> > The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ,
> > MESE, ANNO)
> > VALUES (30030003004601, 3, 46, 1, 03, 2020)
> > ;
> > --
> - - - - - - - - - - - - - - - - - -
> Do you have a trigger on the table? Given the STATO column has a default
> of '', maybe a trigger tries to convert that to a number somewhere?
>
> Also, are you absolutely sure this is the statement that causes the
> problem. Your trying to execute a script, which Firebird itself does not
> support, so your component is doing some transformations, which might
> mean that the error is not on the line that you think it is. Try
> executing a single statement instead of a script.
>
> I'd recommend trying to reproduce it in ISQL, and if possible provide us
> with a minimum reproducible example
>
> Mark
> -- 
> Mark Rotteveel
>
>






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error during the registratione of data on 2.5 FB database

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

No, there is not a trigger.

You say than the error is referred to another part (with mistaken value) 
of the entire script... but the compiler reports me the part that 
(maybe) run ok?!? How this is possible?

Ok, print the script and study it.

Antonio Bianca


Il 04/04/2020 10:57, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] ha scritto:
>
> On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia..com
> [firebird-support] wrote:
> > He,
> > I've an error that I don't undestrand.
> > I use Delphi 7 environment to create my applications, Zeos components
> > for connections and Firebird 2.5 Superserver for database management.
> > To register the data, my App uses the processor component; the
> > Connection.Autocommit  parameter is set to False.
> > My App inserts numerous lines of data to be recorded in the Process
> > component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT
> > INTO ZXD...'; UPDATE FGH SET ...'; and so on);
> > at the end, it adds the command "COMMIT;", then call "PARSE", and 
> "EXECUTE".
> > The lines 4 and 5 of the processor script contains the data mistaken,
> > but I don't undestand where is the eror.
> > The exception raised by the server is:
> > ---
> >
> > SQL Error:  conversion error from string "". Error Code: -413. Overflow
> > occurred during data type conversion.
> > The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ,
> > MESE, ANNO)
> > VALUES (30030003004601, 3, 46, 1, 03, 2020)
> > ;
> >
> > --
> > This is the table declaration:
> > --
> Do you have a trigger on the table? Given the STATO column has a default
> of '', maybe a trigger tries to convert that to a number somewhere?
>
> Also, are you absolutely sure this is the statement that causes the
> problem. Your trying to execute a script, which Firebird itself does not
> support, so your component is doing some transformations, which might
> mean that the error is not on the line that you think it is. Try
> executing a single statement instead of a script.
>
> I'd recommend trying to reproduce it in ISQL, and if possible provide us
> with a minimum reproducible example
>
> Mark
> -- 
> Mark Rotteveel
>
>

[firebird-support] error during the registratione of data on 2.5 FB database

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He,
I've an error that I don't undestrand.
I use Delphi 7 environment to create my applications, Zeos components 
for connections and Firebird 2.5 Superserver for database management.
To register the data, my App uses the processor component; the 
Connection.Autocommit  parameter is set to False.
My App inserts numerous lines of data to be recorded in the Process 
component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT 
INTO ZXD...'; UPDATE FGH SET ...'; and so on);
at the end, it adds the command "COMMIT;", then call "PARSE", and "EXECUTE".
The lines 4 and 5 of the processor script contains the data mistaken, 
but I don't undestand where is the eror.
The exception raised by the server is:
---

SQL Error:  conversion error from string "". Error Code: -413. Overflow 
occurred during data type conversion.
The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ, 
MESE, ANNO)
VALUES (30030003004601, 3, 46, 1, 03, 2020)
;

--
This is the table declaration:
--

CREATE TABLE ANA_DIPE_PRESORD
(
   COD_REC Bigint NOT NULL,
   ANNO Smallint DEFAULT 0,
   MESE Smallint DEFAULT 0,
   MATR Smallint DEFAULT 0,
   DATORE Smallint DEFAULT 0,
   POSIZ Smallint DEFAULT 0,
   STATO Char(1) DEFAULT ''
   CONSTRAINT PK_DIPPPREORD
     PRIMARY KEY (COD_REC)
);

CREATE UNIQUE INDEX IND_ANADPPREORD_COD ON ANA_DIPE_PRESORD (COD_REC);
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
  ON ANA_DIPE_PRESORD TO  SYSDBA WITH GRANT OPTION;

--

The Table has no trigger, no generators, no stored procedures connected. 
The data in "COD_REC" must be unique.

No data are sent as  '' (void string), neither any value is sent as 
"Quoted string",
because they are all of type smallint (and bigint).
I'm going crazy.
It's stupid, but I've changed the value for field 'MESE' from '03' to 
'3', but the result is the same.
What can be the reason?
Thanks for reply.

Antonio BIANCA








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] unsubscribe

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

What means this email?

I've not understood!!!

Antonio BIANCA


Il 07/05/2019 08:26, Brian Dunstan brian.duns...@health.telstra.com 
[firebird-support] ha scritto:
>
>
> 


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] Install a DB Firebird on a web site

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

Ok,

is a situation that I must consider
Thanks

Antonio

Il 28/03/2019 20:14, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] ha scritto:
> 28.03.2019 19:39, 'Stellarancia.com' ni...@stellarancia.com 
> [firebird-support] wrote:
>> My question wanted to be: a direct connection is possible (IP:alias)
>> through a router?
> Yes, it is possible but this is a) insecure; b) may be slow. If your 
> application is not
> ready to work over high-latency network, it will be unbearable slow.
>
>


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus

Re: [firebird-support] Install a DB Firebird on a web site

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He, Cornie,

what you suppose is true:

my intention is really that to directly connect a client on an internet 
computer to the server (computer) with Firebird through the router,  for 
me theoretically possible, and without the use of a VPN or webservice.  
With all the relative safety issues.

However it is a thing that can be done, if I've understood correctly:  
this was my doubt.

Then, my problem now is "how to set the forward router property": I 
don't know.

I must study this argument.

Thanks very much

Antonio BIANCA








Il 27/03/2019 16:46, Cornie corni...@gmail.com [firebird-support] ha 
scritto:
>
> On 2019/03/27 17:10, Mark Rotteveel m...@lawinegevaar.nl 
> [firebird-support] wrote:
>
>> On 27-3-2019 13:01, 'Stellarancia.com' ni...@stellarancia.com
>> [firebird-support] wrote:
>> > Good morning,
>> > My clients use an application written with Delphi that use a Firebird
>> > Database 2.5 (business accounting).
>> > Necessity has risen to access the same database from more subjects that
>> > uses the same application.
>> > I was thinking of moving the database Firebird from the computer to a
>> > Web site, to allow all one connection directed by app.
>> > Ithink this is possible for Firebird, but I have not succeeded in
>> > finding the way to install Firebird on a site or to find a site 
>> that can
>> > manage the Firebird driver.
>> > Obviously I could move the database to a MySql or similar already
>> > existing on a site, but it should be managed with Php and medium 
>> Web pages.
>> > Is the question first of all: it is possible to install Firebird on
>> > Web?And how? Looking for documentation, I have found only instructions
>> > of installation and problem list of connection, but for local computer
>> > or in an intranet.
>> > Does documentation exist related to my problem?
>> > I thank for a possible answer.
>> > Antonio BIANCA
>>
>> You don't install Firebird on a website (nor do you install MySQL on a
>> website for that matter). A website is a thing accessed through HTTP.
>>
>> Given your application uses Delphi, you either need to allow those
>> multiple parties to be able to securely access your Firebird server (eg
>> through a VPN), or maybe you need to build a webservice that replaces
>> your direct database access.
>>
>> Building a webservice to replace direct database access is an extremely
>> broad topic, where accessing the Firebird database is probably the least
>> of your worries.
>>
>> In any case, your question is quite vague to actually answer. You may
>> want to clarify exactly what you're looking for and why.
>>
>> Mark
>>
>> -- 
>> Mark Rotteveel
>>
> Mark is 100% correct, but I think I understand your question.  You 
> want to access FB database remotely from applications.
> To do that on your "website" which are actually just a virtual pc that 
> provides certain services like a "website", will imply that you need 
> access to that "pc", install Firebird and and configure FB and the Pc 
> to allow remote access, etc.  There are many pitfalls this way.  Web 
> providers regular change their rules, antivirus etc and any one of 
> them may suddenly prevent access to your DB.
>
> After many trails, I found that are only two solutions that work.  A 
> virtual server  provided by a service provider where you can install 
> your own software and manage it.  Due to a lack of knowledge, I only 
> use Windows based servers, but I see no reason why Linux will not 
> work.  The second option is open your Firebird server for remote 
> access.  This has nothing to do with Firebird and general means you 
> have setup your internet router to forward request on port 3050/3060 
> to your FB Server with a few changes to Firebird.conf.  That server 
> must have a fix local IP and router internet connection must have a 
> fix IP or you can use DDNS.
>
> Clearly there are security issues with this, as it gives people with 
> the right info direct access to your DB's from virtually any software 
> that can access a FDB database.
>
> Cornie
>
>
>
> 


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus

Re: [firebird-support] Install a DB Firebird on a web site

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He,

My intention is to connect clients (apps) directly with the firebird 
database via the Internet, without VPN or Webservice.

My question wanted to be: a direct connection is possible (IP:alias) 
through a router? (Cornie talks about forwarding the router...)

Antonio




Il 27/03/2019 16:42, 'Louis van Alphen' lo...@nucleo.co.za 
[firebird-support] ha scritto:
>
> My approach was to set up a Windows VM on Azure / AWS and install the app
> there. Then use RDP clients to access the app in the cloud. Users can 
> access
> the app from pretty much any device that has RDP client software. Mac 
> / Win
> / iPAD etc.
>
> Then at least your DB access from app is local to the VM and nice and fast
> as well as your DB is not open to the outside world.
>
>
> -Original Message-
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Sent: Wednesday, 27 March, 2019 17:32
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Install a DB Firebird on a web site
>
> On 27/03/2019 12:01, 'Stellarancia.com' ni...@stellarancia.com
> [firebird-support] wrote:
> > I was thinking of moving the database Firebird from the computer to a
> > Web site, to allow all one connection directed by app.
> > Ithink this is possible for Firebird, but I have not succeeded in
> > finding the way to install Firebird on a site or to find a site that
> > can manage the Firebird driver.
>
> If your delphi application is designed for multiple clients to access the
> same database, then it is just a matter of making the database 
> accessible on
> the internet. That does not involve a website, but it does open the 
> database
> to scrutiny by anybody else on the internet.
>
> My own websites use Firebird as a tool to store the data that is displayed
> on the website, but is only accessible by the local copy of PHP, while
> another application has BuilderC clients spread across multiple locations
> all accessing the one copy of Firebird one a closed network.
>
> As Mark says, what are you actually trying to achieve?
>
> --
> Lester Caine - G8HFL
> -
> Contact - https://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - https://lsces.co.uk EnquirySolve -
> https://enquirysolve.com/ Model Engineers Digital Workshop -
> https://medw.co.uk Rainbow Digital Media - 
> https://rainbowdigitalmedia.co.uk
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu
> there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
> 


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: ODP: [firebird-support] Using Union and Join (of two tables residing in different databases)in a Query

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

Good morning,

you make a real hit!

/>The database for Company A should have all the tables used by the 
users in Company A, including the low-volatility ones like your/

/>Municipalities table. If Comapny B needs Municipalities, it should 
have its own copy. //_
_/

/_>You can create a DML script _//for this low-volatility table and run 
it over each database.../

You have answered to the question that I have turned some days ago, but 
I don't know how to do.

What it means "low-volatility"? without "consistency"? To create a 
temporary "vew" to utilize as a table to join? Can you explain me the 
concept, even with an example? I think that the problem (always for me) 
is to utilize the table of the second database in the same transaction 
of the table of the first database...

I thank for the devote time, perhaps the question is "a little banal"... 
(^_^)

I cordially greet

Antonio BIANCA


Il 18/09/2018 00:27, Helen Borrie hele...@iinet.net.au 
[firebird-support] ha scritto:
>
> Antonio,
>
> > I don't understand as you have been able to believe that I have treated
> > a database as was a spreadsheet!!! I know what is a table, a database
> > (database as "set of tables", database as "file of type database"), a
> > relation, a key, an inedex, a... I've studied on your book.
>
> > When I speak "to draw a table" for a program, I intend to set various
> > "tables" with the appropriate fields (name and type) and the
> > relationships with the fields of other "tables": so the database is the
> > whole organized of these "tables" and relations. Right?
>
> So far, so good.
>
> > if it is not correct, I go to be a carpenter...
> > else
> > - a client ask me to write a program for a  single scope, the archives
> > (the "tables" in the database!) must be able to contain the data related
> > to that type of activity and I draw (create, write) a dabatase with the
> > correct tables;
>
> Yes, one client (Company A) one database
>
> > - different clients ask me different types of programs: FOR ME, a
> > database must be created (drawn) for each type of program;
>
> For everyone else, a database is created for each client organisation
> (one database for Company A, one database for Company B, and so on.
>
> > - two or more programs can have some identical "table" (e.g.
> > municipalities);
> > - (1) I can create apart a unique database of "common tables" for the
> > "tables" used by all the programs;
>
> The database for Company A should have all the tables used by the
> users in Company A, including the low-volatility ones like your
> Municipalities table. If Comapny B needs Municipalities, it should
> have its own copy. You can create a DML script for this
> low-volatility table and run it over each database; or use a
> replication tool if it is called for.
>
> > (2) the same "table" can be repeated
> > in all the databases;
>
> That is what I referred to as "spreadsheet". Those old-style desktop
> fielsystems predated spreadsheets and lent themselves to that model of
> application, due to explicit table locking. That does not make it a
> sensible or correct approach for a transactional RDBMS such as
> Firebird.
>
> > - it could be created an only database for all the programs; for every
> > new program, new "tables" can be added in this unique database, while
> > the "table" existing can be used by the new program;
>
> No, all tables should be available to all progrms and to one another.
> If you have the same data in more than one table, you have redundancy,
> the big enemy in data management. Related to this, if you are using
> actual data as keys, you have intrinsic redundancy.
>
> If you want to prevent certain USERs or ROLEs from accessing certain
> tables, you use SQL privileges.
>
> > - if you write dozens of programs (very small, normally, very great),
> > the only database becomes not manageable, *but it doesn't behave 
> problems*.
> > "not manageable" FOR ME as administration of the variations to the
> > single fields: Firebird is able of to manage millions of tables and
> > relationships, I can't, is its purpose!!
>
> Firebird is designed to ensure the ACID rules (Atomicity, Consistency,
> Isolation, Durability). it won't prevent you from breaking those rules
> but it won't heal your wounded data for you, either.
>
> > You pursue a purpose of general relations, that is the purpose of DBRMS;
> > I pursue a purpose of management USING Firebird and its capability to
> > relate: it is not the same thing! FOR ME, naturally!!
>
> Actually, every database is part of a management system of one kind or
> another, so you are not alone in this world. You can design a system
> to store data according to rules and structures that make it safe and
> smart: THAT is the purpose of a RDBMS. Apparently, you want to follow
> the spreadsheet model, in which a single set of data is exclusive to a
> single application. So - you maintain multiple instances of the same
> data by hand and say your prayers.
>
> > From this my 

Re: ODP: [firebird-support] Using Union and Join (of two tables residing in different databases)in a Query

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He, Helen,

I don't understand as you have been able to believe that I have treated 
a database as was a spreadsheet!!! I know what is a table, a database 
(database as "set of tables", database as "file of type database"), a 
relation, a key, an inedex, a... I've studied on your book.

When I speak "to draw a table" for a program, I intend to set various 
"tables" with the appropriate fields (name and type) and the 
relationships with the fields of other "tables": so the database is the 
whole organized of these "tables" and relations. Right?

if it is not correct, I go to be a carpenter...
else
- a client ask me to write a program for a  single scope, the archives 
(the "tables" in the database!) must be able to contain the data related 
to that type of activity and I draw (create, write) a dabatase with the 
correct tables;
- different clients ask me different types of programs: FOR ME, a 
database must be created (drawn) for each type of program;
- two or more programs can have some identical "table" (e.g. 
municipalities);
- (1) I can create apart a unique database of "common tables" for the 
"tables" used by all the programs; (2) the same "table" can be repeated 
in all the databases;
- it could be created an only database for all the programs; for every 
new program, new "tables" can be added in this unique database, while 
the "table" existing can be used by the new program;
- if you write dozens of programs (very small, normally, very great), 
the only database becomes not manageable, *but it doesn't behave problems*.
"not manageable" FOR ME as administration of the variations to the 
single fields: Firebird is able of to manage millions of tables and 
relationships, I can't, is its purpose!!
You pursue a purpose of general relations, that is the purpose of DBRMS; 
I pursue a purpose of management USING Firebird and its capability to 
relate: it is not the same thing! FOR ME, naturally!!
 From this my problem is born, but I can change my formulations.

I need to think.
Thanks for the devote time : you must also work...
Best regard
Antonio BIANCA



Il 15/09/2018 07:16, Helen Borrie hele...@iinet.net.au 
[firebird-support] ha scritto:
>
> Antonio,
>
> > I'm agree with you: all tables in a unique firebird file is the best 
> choice.
>
> > My problem is that I've numerous programs that utilize one firebird file
> > each.
>
> That problem is easy to solve. Place all of the tables in one
> database and use an alias for that database in every application.
>
> > There are tables that are drawn for a specific program, but there are
> > some tables that are "common" to all programs (example:
> > "municipalities").  An user can utilize one program, two programs, four
> > programs, and so on, on the same computer and each program hav its
> > database.fdb: if I must vary a value of one "common tables", I must send
> > an update for every program and to each user; but if the "common tables"
> > are in a unique, separate database, I can update one file only.
>
> This is not a database design. You are treating "database" and
> "spreadsheet" as though they were the same animal. Very definitely,
> they are not the same.
>
> Think "relational", because Firebird is a relational database system.
> Tables (a.k.a. relations) can be *related* to one another by way of
> foreign keys. Data from tables containing compatible fields (columns)
> can be connected during run-time queries by JOINs or UNIONs.
>
> > There are also "static" tables containing storical movements, and is not
> > necessary periodically to back-up them.
>
> At the same time, it does no harm for them to be included in the
> backup of your current data. It makes sense for them to be in the
> same database as the active tables if you need to refer to them from
> your applications.
>
> > These are the reasons that push me to look for a solution, I hope to
> > have been clear.
>
> The thing that seems clear to me is your confusing "tables" with
> "databases". The whole point of using a relational database is to
> have all of the interrelated data available to each individual client
> connection.
>
> > For release 2.5 and not 3.o, I have been studyng Firebird for some
> > months, and I've not experience: I now plan the job to develop, later I
> > will verify the new releases.
>
> The question of whether you use 2.5 or 3.0 is not relevant to your
> problem. Spend some more time understanding how a relational database
> works - and forget your preconceptions from previous work you have
> done using spreadsheets or fiel-based data storage systems.
>
> Helen
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com
>
> 


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus

Re: ODP: [firebird-support] Using Union and Join (of two tables residing in different databases)in a Query

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He,

I'm agree with you: all tables in a unique firebird file is the best choice.

My problem is that I've numerous programs that utilize one firebird file 
each.

There are tables that are drawn for a specific program, but there are 
some tables that are "common" to all programs (example: 
"municipalities").  An user can utilize one program, two programs, four 
programs, and so on, on the same computer and each program hav its 
database.fdb: if I must vary a value of one "common tables", I must send 
an update for every program and to each user; but if the "common tables" 
are in a unique, separate database, I can update one file only.

There are also "static" tables containing storical movements, and is not 
necessary periodically to back-up them.

These are the reasons that push me to look for a solution, I hope to 
have been clear.

For release 2.5 and not 3.o, I have been studyng Firebird for some 
months, and I've not experience: I now plan the job to develop, later I 
will verify the new releases.

Best regards

Antonio BIANCA




Il 12/09/2018 23:42, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] ha scritto:
>
> Hi,
>
>  1. Why not single Firebird database with all tables?
>  2. Why not recent Firebird which is FB3 not FB2.5?
>
> Pozdrawiam,
>
> Karol Bieniaszewski
>
> 


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus

Re: [firebird-support] Using Union and Join (of two tables residing in different databases) in a Query

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

Dear Svein,

the problem is not the greatness of the database, but its 
administration: the problem borns for a few tables that are utilized by 
others tables (master/detail), and for many records passed to "storical" 
(these movements become static). These tables don't have need to 
periodically be saved.

I menage 11 softwares that utilize 11 different databases.fdb (each 
database have different tables). The consumer can utilize one software, 
four software, etc.  on the same computer.

If I replicate this few tables in all databases, every maintenance for a 
single common table must be done in every database. If I put these few 
tables in a single database (e.g. Common.fdb), these few table are in a 
single, unique file, then...

I am agree with you: the most obvious and elegant solution is to put all 
the tables in a unique database. But I will try to create two separate 
query, each connected to separate database.fdb, then create a relation, 
for example a lookup master/detail via OnCalcFields. It is not the same 
thing of a JOIN, still less than a UNION, but I'll try in some manner.

I'm using BDE from 22 years (very ok, but obsolete), but with Win10 it 
is not possible to use it;  now, from two months I'm using Firebird and 
I don't have great experience yet.

Thanks anyway.

Antonio BIANCA




Il 13/09/2018 10:46, Svein Erling Tysvær setys...@gmail.com 
[firebird-support] ha scritto:
> dBase supported tables, and databases was not a separate concept. 
> Firebird also supports tables, but as a very different concept from 
> databases. A Firebird database can contain about 32000 tables and 
> joining tables within a database is easypeasy. Although possible 
> (through EXECUTE STATEMENT... ON EXTERNAL DATA SOURCE...), it does 
> make things a lot more difficult if you have to do things across 
> databases.
>
> If you've been asked to transfer 967 tables to Firebird, the normal 
> and simple solution would be to have one database containing all 967 
> tables, not a lot of different databases that should be joined to each 
> other. If you can separate things that doesn't talk to each other, 
> then you can split into several databases, but probably a few 
> databases, not 967. If there are a few tables that are common lookup 
> tables, you could consider having one master database with these and 
> then copy/replicate the tables to other databases (I would assume 
> zipcodes and municipalities to be rather static, so these are good 
> candidates for having a master in a separate database, but then 
> copy/replicate these tables to all databases that uses them).
>
> You may of course have good reasons for importing these .dbx tables 
> into databases of their own (e.g. if there are some kind of strange 
> legal requirements), but I'd say that is a decision that you should 
> only take after carefully considering alternatives.
>
> HTH,
> Set
>
> Den ons. 12. sep. 2018 kl. 22:05 skrev 'Stellarancia.com' 
> ni...@stellarancia.com  
> [firebird-support]  >:
>
> I'm transferring many tables (967) from single BDE .DBF files (old
> driver DbIV) to Firebird 2.5.
>
> I utilize Delphi 7 as environment and ZEOS components to Firebird
> connections: the work is enough easy.
>
> A large number of old queries contain UNIONS and JOINS of tables (->
> single files .DBF), but now the old .DBF tables are transferred in
> different Firebird Databases. For example, with the two tables
> Municipalities.Dbf and ZipCodes.Dbf, I can write with BDE a query
> "SELECT * FROM MUNICIPALITIES.DBF a INNER JOIN ZIPCODES.DBF b ON
> ()...
> WHERE..."; now the first table is in WorkCom.fdb database, and the
> second table is in the TabCom.fbd database: how to join to day
> the  tho
> tables? My program utilizes this queries and I would want  to find
> solutions that give a fast result as BDE.
>
> I know that is not possible for Firebird to join tables that
> "resides"
> in different databases (.fdb), but I must find a solution as
> elegant as
> possible to join the same FB tables previously joined with .DBF files.
>
> Do you have any suggestion as to how to solve this problem?
>
> Thanks in advance.
>
>
> ---
> Questa e-mail è stata controllata per individuare virus con Avast
> antivirus.
> https://www.avast.com/antivirus
>
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the
> left-side menu there.
>
> Also search the knowledgebases at
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
>   

[firebird-support] Using Union and Join (of two tables residing in different databases) in a Query

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

I'm transferring many tables (967) from single BDE .DBF files (old 
driver DbIV) to Firebird 2.5.

I utilize Delphi 7 as environment and ZEOS components to Firebird 
connections: the work is enough easy.

A large number of old queries contain UNIONS and JOINS of tables (-> 
single files .DBF), but now the old .DBF tables are transferred in 
different Firebird Databases. For example, with the two tables 
Municipalities.Dbf and ZipCodes.Dbf, I can write with BDE a query 
"SELECT * FROM MUNICIPALITIES.DBF a INNER JOIN ZIPCODES.DBF b ON ()... 
WHERE..."; now the first table is in WorkCom.fdb database, and the 
second table is in the TabCom.fbd database: how to join to day the  tho 
tables? My program utilizes this queries and I would want  to find 
solutions that give a fast result as BDE.

I know that is not possible for Firebird to join tables that "resides" 
in different databases (.fdb), but I must find a solution as elegant as 
possible to join the same FB tables previously joined with .DBF files.

Do you have any suggestion as to how to solve this problem?

Thanks in advance.


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Hallo world

['Stellarancia.com' ni...@stellarancia.com [firebird-support]]

He,

now I enter in the Firebird group.

Good morning to all.

Antonio BIANCA


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus