Try this with Beta15 (I just released it) and let me know quickly.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of mspencewasunavailable
> Sent: Saturday, January 20, 2007 2:44 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] TIBOQuery doesn't return aggregate value
>
>
> (Version 4.7 Beta 14)
>
> TIBOQuery doesn't return any data for this query:
>
> SELECT SUM("Tax") as "Tax" FROM QTABLE
>
> The IB_Monitor output follows, and I can see that the correct data
> is being returned, but the TIBOQuery object reports a recordcount of
> 0 even thought recordcountaccurate is true. Also, fieldcount is 0.
>
> This seems like a bug to me.
>
> Here's the IB_Monitor output for the query:
>
>
> /*---
> [ 1/20/2007 4:33:44 PM ]
> PREPARE STATEMENT
> TR_HANDLE = 4
> STMT_HANDLE = 5
>
> select sum("Tax") as "Tax" from QTABLE
>
> PLAN (QTABLE NATURAL)
>
> FIELDS = [ Version 1 SQLd 1 SQLn 30
> [TAX] = <NIL> ]
>
> SECONDS = 0.016
> ----*/
> /*===
> [ 1/20/2007 4:33:44 PM ]
> //>>> STATEMENT PREPARED <<<//
> TIB_Statement.API_Prepare()
> TIBOInternalDataset: "IBOQuery1.IBOqrIBOQuery1" stHandle=5
> ====*/
> /*---
> [ 1/20/2007 4:33:44 PM ]
> EXECUTE STATEMENT
> TR_HANDLE = 4
> STMT_HANDLE = 5
> PARAMS = [ ]
> ----*/
> /*---
> [ 1/20/2007 4:33:44 PM ]
> FETCH
> STMT_HANDLE = 5
> FIELDS = [ Version 1 SQLd 1 SQLn 1
> [TAX] = 74 ] <====== This is in fact the correct value
> ----*/
>
>
> Michael D. Spence
> Mockingbird Data Systems, Inc.