richardleehl
Technical User
Hi, I seem to have problems aggregating data and then storing the data into a temp table for later viewing:
Ex:
select ticketnum, sum(priceextension) total
into "#table1"
from TICKHISD
where ticketnum=457117
group by ticketnum
trying to view the temp table:
select * from "#table1"
result:
ODBC Error: SQLSTATE = , Native error code = 0
A required ODBC entry point was not found. Make sure ODBC is installed correctly.
If i just do a simple data dump into the temp table without using an aggregate function the contents of the temp table displays correctly:
Ex:
select ticketnum, priceextension
into "#table1"
from TICKHISD
where ticketnum=457117
select * from "#table1"
results:
457117 22200.00
457117 30.00
any ideas why this is happening? I am running these queries through the Pervasive control center.
Thank you for any insight
Ex:
select ticketnum, sum(priceextension) total
into "#table1"
from TICKHISD
where ticketnum=457117
group by ticketnum
trying to view the temp table:
select * from "#table1"
result:
ODBC Error: SQLSTATE = , Native error code = 0
A required ODBC entry point was not found. Make sure ODBC is installed correctly.
If i just do a simple data dump into the temp table without using an aggregate function the contents of the temp table displays correctly:
Ex:
select ticketnum, priceextension
into "#table1"
from TICKHISD
where ticketnum=457117
select * from "#table1"
results:
457117 22200.00
457117 30.00
any ideas why this is happening? I am running these queries through the Pervasive control center.
Thank you for any insight