Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax
Message
 
À
12/03/1999 12:57:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Syntax
Divers
Thread ID:
00196908
Message ID:
00196912
Vues:
29
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform