[firebird-support] RE: How to transfer one fdb content to another?

2014-01-11 Thread dice_in_trouble
Well we have a database that we fill in with data every day. We were working fine, until last thursday I think (or someday this week) that someone on our team accidentally duplicated the .fdb file on our server, and then he updated one file and the other team member updated the second file at

[firebird-support] How to transfer one fdb content to another?

2014-01-10 Thread dice_in_trouble
Hi, I have a frebird database in which was copied and was updated at the same time. My questions is how can I transfer the content of one of the databases to another so that I can unify it and make it as a single file with all the contents of the 2 separated databases on it? They both

[firebird-support] Error in inputting content in a table

2014-01-08 Thread dice_in_trouble
Hello, We are currently having trouble entering data on one of our tables. We are trying to enter data on specific columns, but after refreshing it, the data is lost. Here is the outline of our table: CREATE TABLE PAYMENT ( PAYMENT_DATE Timestamp DEFAULT current_timestamp NOT

[firebird-support] Data transfer from one table to another

2014-01-08 Thread dice_in_trouble
Hi all, is it possible to transfer the content of a table to a new one? Thanks,

[firebird-support] Cannot edit fdb content.

2014-01-07 Thread dice_in_trouble
Hi we were encoding data yesterday on our fdb database, and after resting for the day we tried connecting again now but everytime we put a new entry it doesn't enter. We are using a delphi application and zeos as driver for it. What could be the problem here? Thanks.

[firebird-support] Can a Firebird database be hosted on a hosting site?

2014-01-04 Thread dice_in_trouble
Hello to all, I would like to host my firebird database on a provider, but don't have an idea on where to start. We currently have a firebird database in which is connected via lan. As our company grows, so its needs. We plan to expand on another branch which will be located on a different

[firebird-support] Re: how to use the same column from a single table to other tables?

2013-05-04 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, Ann Harrison aharrison@... wrote: On Fri, May 3, 2013 at 8:07 PM, dice_in_trouble dice_in_trouble@...wrote: You wrote: the client id also doens't auto increment. I asked How do you generate client identifiers? You

[firebird-support] Re: how to use the same column from a single table to other tables?

2013-05-04 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, nor...@dunbar-it.co.uk Norman@... wrote: Evening Cedris, When I'm in the office on Tuesday, ill send you some info. A crash course in Firebird. Cheers, Norm. Sent from my HTC [Non-text portions of this message have been removed]

[firebird-support] Re: how to use the same column from a single table to other tables?

2013-05-03 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, Norman Dunbar Norman@... wrote: On 02/05/13 11:15, dice_in_trouble wrote: Hi Cedris, Thank you for this wonderful post. Will try this now. Thank you again. You are welcome. I suggest you purchase a book on Firebird, as has been suggested

[firebird-support] Re: how to use the same column from a single table to other tables?

2013-05-03 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, dice_in_trouble dice_in_trouble@... wrote: --- In firebird-support@yahoogroups.com, Norman Dunbar Norman@ wrote: On 02/05/13 11:15, dice_in_trouble wrote: Hi Cedris, Thank you for this wonderful post. Will try this now. Thank you again

[firebird-support] Re: how to use the same column from a single table to other tables?

2013-05-03 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, Ann Harrison aharrison@... wrote: On Fri, May 3, 2013 at 2:16 PM, dice_in_trouble dice_in_trouble@...wrote: and btw how can I include formulas like from excel to my firebird database? I would like to sum up the total payments made

[firebird-support] Re: how to use the same column from a single table to other tables?

2013-05-02 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, Norman Dunbar Norman@... wrote: Morning dice_in_trouble, If I understand you correctly, you have or wish to have the following: CLIENT TABLE: CLIENT DATE BALANCE ADDRESS COLLECTIONS TABLE: TIMESTAMP PAYMENT CLIENT BALANCE

[firebird-support] Re: how to use the same column from a single table to other tables?

2013-05-02 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, Werner F. Bruhin werner.bruhin@... wrote: Hi, On 02/05/2013 10:47, dice_in_trouble wrote: ... Thanks Nrom for the reply. I also thought of this idea, wherein I make a separate table for the balance then link it up to the other 2

[firebird-support] Re: how to use the same column from a single table to other tables?

2013-05-02 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, Norman Dunbar Norman@... wrote: On 02/05/13 09:47, dice_in_trouble wrote: Thanks Nrom for the reply. I also thought of this idea, wherein I make a separate table for the balance then link it up to the other 2 tables. But I don't know how

[firebird-support] how to use the same column from a single table to other tables?

2013-05-01 Thread dice_in_trouble
I have 2 tables, namely clients and collection. I have on the client table the columns named client,date,balance and address respectively. The daily collection has a column named time stamp and payment. But it also need to have the list of client and balances from the clients table and I want

[firebird-support] building table relationships on a firebird database

2013-04-21 Thread dice_in_trouble
I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database. My masterlist contains the following columns:

[firebird-support] how to build a relationship between 2 tables in firebird?

2013-04-21 Thread dice_in_trouble
I have a Firebird database with 2 tables namely masterlist and daily collection. I used Zeos 7.0.3 to access my Firebird database. My masterlist contains the following columns: name date balance status My daily collection contains the following columns: date name payment balance I would like

[firebird-support] autodate and autofill columns

2013-04-20 Thread dice_in_trouble
hello i have a firebird database in which i have columns namely date, name, balance and payment i want my software to publish a list of the content with the date being adjusted daily and the content being the same, e.g. datenamebalance payment 20/4/13 client1 100 20/4/13 client2

[firebird-support] how to call 'commit' after you exit the cell being edited?

2013-04-19 Thread dice_in_trouble
i had this experience earlier in which i need to close the app for the db grid to update even i have these components: 1 zconnection 1 ztable 1 datasource 1 dbgrid 1 navigation bar if i press refresh on the nav bar, the entry on the other computer wont appear. i would like the dbgrid to

[firebird-support] Re: how to call 'commit' after you exit the cell being edited?

2013-04-19 Thread dice_in_trouble
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Fri, 19 Apr 2013 15:44:57 -, dice_in_trouble dice_in_trouble@... wrote: i had this experience earlier in which i need to close the app for the db grid to update even i have these components: 1

[firebird-support] firebird connection with zeoslib and delphi 7

2013-04-07 Thread dice_in_trouble
hello i am using zeoslib 7.0.2, firebird 2.5.2 and delphi 7. i have a app that connects to my firebird database locally. i have set it up and it connects. but when i tried connecting via the local network, there is always an error when i am connecting. i used a zconnection and put in the