Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax
Message
 
To
12/03/1999 12:57:50
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Syntax
Miscellaneous
Thread ID:
00196908
Message ID:
00196912
Views:
23
Hi Jason,
Your question is a little unclear.
You can use the expression you gave just as is for a REPLACE:

REPLACE ExtPrice WITH unitprice*unitquant*(1-discount)/100)*100

I'm assuming the actual field names, here.
Mark

>Hello -
>
>I am designing my ORDERS table in my app and need to build an expression to add/multiply my fields to return a final payment price.
>
>My table name is: ORDERS DETAIL
>My field is EXTENDED PRICE:
>
>The field extended price will hold the exrpession.
>
>I want to build an expression for the following scenario>
>
>unitprice*unitquantity*(1-discount)/100)*100
>
>What is the proper syntax for this expression in order for FoxPro to understand?
>
>Thanks for any assistance
>
>Jason
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Previous
Reply
Map
View

Click here to load this message in the networking platform