jolly
VIP Member
Hi All,
Has anybody got this API to work? It always fails for me and I get the following error logged:
7792/6460 WRK:Starting jdeCallObject Wed Mar 21 10:25:59.724000 Jdb_exef.c6475
JDB98000055 - Failed to swap column list to requested columns. Check whether table is opened with all the columns.
If I use the simple JDB_FetchAggregate I get the correct answer so everything else seems correct. I suspect the problem is somehow in the select list for the table open vs the lpStruct passed to fetch the columns into.
In my 8.12 code set, there is not one single example of a JDB_FetchColsAggregate and there are no specific references to the function on the KG or Google!
It is documented in the API help file as follows:
Syntax
JDEDB_RESULT JDB_FetchAggregate (HREQUEST hRequest, void * lpStruct, void * lpAggregateValue)
Parameter
Notes
Usage
hRequest
Valid request handle.
This is the request handle by which JDB will identify all requests made to the particular table.
lpStruct
Pointer to ordinary column results structure or NULL
If no structure is to be used then pass NULL
lpAggregateValue
Pointer to aggregate results structure or NULL
If no structure is to be used then pass NULL
Return Value
Returns JDEDB_PASSED when the API succeeded or JDEDB_FAILED otherwise.
H have attached the source and include files for the business function.
Any ideas. Am standing by to kick myself but have been staring at this for way to long and can no longer see forest for trees!
Thanks
JohnO
Has anybody got this API to work? It always fails for me and I get the following error logged:
7792/6460 WRK:Starting jdeCallObject Wed Mar 21 10:25:59.724000 Jdb_exef.c6475
JDB98000055 - Failed to swap column list to requested columns. Check whether table is opened with all the columns.
If I use the simple JDB_FetchAggregate I get the correct answer so everything else seems correct. I suspect the problem is somehow in the select list for the table open vs the lpStruct passed to fetch the columns into.
In my 8.12 code set, there is not one single example of a JDB_FetchColsAggregate and there are no specific references to the function on the KG or Google!
It is documented in the API help file as follows:
Syntax
JDEDB_RESULT JDB_FetchAggregate (HREQUEST hRequest, void * lpStruct, void * lpAggregateValue)
Parameter
Notes
Usage
hRequest
Valid request handle.
This is the request handle by which JDB will identify all requests made to the particular table.
lpStruct
Pointer to ordinary column results structure or NULL
If no structure is to be used then pass NULL
lpAggregateValue
Pointer to aggregate results structure or NULL
If no structure is to be used then pass NULL
Return Value
Returns JDEDB_PASSED when the API succeeded or JDEDB_FAILED otherwise.
H have attached the source and include files for the business function.
Any ideas. Am standing by to kick myself but have been staring at this for way to long and can no longer see forest for trees!
Thanks
JohnO