problem with aggregating data
problem with aggregating data
(OP)
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
Talk To Other Members
RE: problem with aggregating data
My queries were:
select name, sum(max_size) total into #table1 from class where id > 100 group by name;
select * from "#table1"
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com