(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.