I am trying to send select results to a grid, but the source data has decimal precision that I do not want to include. For example, the quantity field is defined in the table is a N(7,1). When I multiply it by a unit price, I get 3 places after my decimal. Here was my old code:

Select invpost.custno as [Customer], invpost.company as [Company], Sum(invitempost.qtyord) As [Ord], Sum(invitempost.qtyshp) As [Ship], ;
sum(invitempost.qtybo) As [BO], Sum(invitempost.qtyord * invitempost.unitpr) As [Ext_Price], ;
count(Distinct invpost.invno) As [Orders], Count(*) As [Lines] ;
FROM invpost INNER Join invitempost ;
ON invpost.invno = invitempost.invno ;
INTO Cursor curResults ;
&lcwhere ;
GROUP By Customer,Company ;
ORDER By Ord DESC

This works fine, but I get the bad decimals. So I thought I would create a cursor with data types and insert into it.

CREATE CURSOR curResults (Customer C(12), Company C(30), Ord N(7), Ship N(7), BO N(7), Ext_Price N(8.2), Orders I, Lines I)
INSERT INTO curResults (Customer, Company, Ord, Ship, BO, Ext_price, Orders, Lines) ;
Select invpost.custno as [Customer], invpost.company as [Company], Sum(invitempost.qtyord) As [Ord], Sum(invitempost.qtyshp) As [Ship], ;
sum(invitempost.qtybo) As [BO], Sum(invitempost.qtyord * invitempost.unitpr) As [Ext_Price], ;
count(Distinct invpost.invno) As [Orders], Count(*) As [Lines] ;
FROM invpost INNER Join invitempost ;
ON invpost.invno = invitempost.invno ;
&lcwhere ;
GROUP By Customer,Company ;
ORDER By Ord DESC

This only seems to give me one record. Any ideas?

Randy Wessels