Search found 5 matches

by chunkiebone
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...
by chunkiebone
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...
by chunkiebone
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 ...
by chunkiebone
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...
by chunkiebone
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:...