Re: [firebird-support] group by and sub-selects

2013-12-26 Thread Roberto
Kelly,  If I understood what you want, you wanna do something like a decision cube. I would take your query and change it to... select x.ownername, x.location, x.RVYear, x.RVMonth, ( select count(1) from reliefd r    where r.plantkey=x.uniquekey and    r.manufacturer=’The Manufacturer I want’) R

Re: [firebird-support] linker error in VS 2005

2013-12-26 Thread Roberto
sgcoutts, Maybe you have biblios compiled not with Win7, and this may be causing your problem. The solution could be to get the code for these bibliotecs and compile them at your machine. You seem to be programming with C. If yes, I think you could try C# - also from VS - with ODBC connection.

[firebird-support] RE: group by and sub-selects

2013-12-26 Thread avert
Hi-- Thanks for the reply. You've got a handle on what I want to return and the industry. The query I'm still not clear on. I did clean it up a bit and it ran: select x.ownername, x.location, x.RVYear, ( select count(1) from reliefd r where r.plantkey=x.uniquekey ) RV_Mfg_Eve

[firebird-support] RE: group by and sub-selects

2013-12-26 Thread avert
I'll rephrase as i know i could put a grid of owners/plants date’s grouped by or /MM then have a detail grid that is the counts that i want using the master grid’s PlantKey + date-group. But that’s 2 grids. somehow I need to join those two queries. I need a master-det

[firebird-support] [Mac][mavericks] build firebird server through macports?

2013-12-26 Thread jul_bsd
Hello, I'm trying to build a Portfile of Firebird 2.52 for macports (latest on 10.9.1) so it can handle update and deps (next step will be dbd::firebird hoping it will be easier; saw previous post on that) As for now, my main problem are building errors. There are a lot of warnings and 2 error