Search found 5 matches
- 05.05.2013, 05:19
- Forum: Firebird
- Topic: is it possile to select columns from 2 different tables?
- Replies: 1
- Views: 1509
is it possile to select columns from 2 different tables?
Hello I was just wondering if it is possible to select data from 2 tables using the zquery? I have tried this sql statement: select * from "table1" union select * from "table2" But it always gets an error. I was hoping that I can display on a TDbgrid data from 2 tables. I am usin...
- 22.04.2013, 10:13
- Forum: Firebird
- Topic: zeos sql query on firebird
- Replies: 4
- Views: 2058
Hi Jan, Thank you very much for the information you gave me. I just wonder where I could start. I am a total newbie when it comes to firebird and coding, and I dont even know how to build table relationships in firebird. btw I'm using flamerobin app to make it easier for me to manage my firebird dat...
- 22.04.2013, 01:38
- Forum: Firebird
- Topic: zeos sql query on firebird
- Replies: 4
- Views: 2058
hello jan, basically what i want to do is that the column in the masterlist be updated when i insert a payment on the daily collection. because the daily collection would have dates everyday with payments from other clients, while the masterlist will hold the profile of the clients and will just be ...
- 21.04.2013, 16:17
- Forum: Firebird
- Topic: zeos sql query on firebird
- Replies: 4
- Views: 2058
zeos sql query on firebird
hello i have 3 tables, namely masterlist and daily_payments masterlist has columns named client, address and balance daily_payments has columns named date, payment, client and balance. i would like the data on the balance same on both tables and when updated on either table, i will update on the oth...
- 08.04.2013, 01:45
- Forum: ZeosLib 7.0 Stable Forum
- Topic: tzconnection help
- Replies: 2
- Views: 626
tzconnection help
hello i have an app which accesses a firebird database locally on my computer. i want to try to access it on another computer within the network using the tzconnection of zoes and i put the following on the repective boxes in the object inspector: database: "my servers ip" 192.168.254.1:c:...