Invalid Field Size Error

[1stdirect]

Okay Im completely new to Pervasive SQL I need help with this issue. I am trying to display a column that is the value of two other columns multiplied together (QTYORDERD * UNITPRICE). We use a product called DbNetGrid and the code looks like this. I know this workes in SQL but not sure why it doesnt in Pervasive SQL.

fromPart = "OEINVD"
orderColumn = "INVNUMBER"
columnPicker = "true"
view = "true"
selectPart = ["INVNUMBER","\"DESC\"","QTYORDERED","INVUNIT","UNITPRICE","QTYSHIPPED","(QTYORDERED * UNITPRICE)"];
headings = ["Invoice #","Item","QtyOrdered","Unit","Unit Price","QtyShipped","Total $"];


Any help would be very helpful.

 

[mirtheil]

What error are you getting? If you use the PCC and issue a "SELECT (QTYORDERED * UNITPRICE) FROM OEINVD", does it work? If so, then there's a problem with DbNetGrid.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com