[Firebird-odbc-devel] Is this a job for ROLLUP?

2012-05-08 Thread Maury Markowitz
I have a table called PARTS and another called KITS. Joining the two is a fkey table, KITPARTS. A single part can be in more than one kit. I'd like to make a report like this... KIT PARTS Kit 1Part One Part Two Kit 2Part

[Firebird-odbc-devel] Driver returns -1 rows for every query?

2012-07-19 Thread Maury Markowitz
Hey guys... I'm using the Mac 64 bit driver and trying to retrieve the results row count for basic fetch. The code I'm using works with other ODBC drivers, including MySQL and SQLite (yes, there's an ODBC driver for that...) However, in Firebird it always returns -1. Here's the code, for what

Re: [Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

2012-11-28 Thread Maury Markowitz
On 2012-11-27, at 7:27 AM, Peter Stalpers wrote: 1. The department bought an application for preparing pharmaceutical medication and this application only supports Firebird as its backend database. 2. The department also bought logistcal module and this application only supports Progress