[firebird-support] Dividing one column by another

2016-12-09 Thread Russell Weetch russ...@smxi.com [firebird-support]
I am trying to divide one column in table A by another in table B, but it just gives me null values. The query is SELECT A.AMOUNT, B.VALUE, A.AMOUNT/B.VALUE FROM TABLE1 A JOIN TABLE2 B ON A.URN = B.URN any ideas gratefully received. Russell

[firebird-support] Firebird 3 and Encryption

2015-11-02 Thread Russell Weetch russ...@smxi.com [firebird-support]
Hi Not sure whether I have been looking in the right place, but is data encryption included in Firebird 3? Also, any estimate of when the release candidate will be available? Thanks Russell SMXi

Re: [firebird-support] Re: Firebird 3 and Encryption

2015-11-02 Thread Russell Weetch russ...@smxi.com [firebird-support]
Many thanks for the update *Russell Weetch*SMXi – *the heartbeat of your business* *T: *+44 (0)20 7100 6010 *M:* +44 (0)7879 816084 *W:* http://smxi.com *E:* russ...@smxi.com [image: Linked In]

Re: [firebird-support] Configuring Firebird for high transaction through put

2014-09-11 Thread Russell Weetch russ...@smxi.com [firebird-support]
What type of access (read vs. write mix) are you expecting? Mainly write What mix of small vs. large queries are you expecting? the queries are based on single order ids (primary keys) and about 4 tables involved How many simultaneous connections are you expecting? that's the big question we are