, . . . .
, , . , .T. .F. . , .T., ! .. , .
, , , . , - , .
:
( Fields Table Designer); , ;
( Table ); , .
.
. . Fields Field validation ( ) . (.38)
Rule (, ) , Message () , , False.
. Products TestData. , unit_cost, $100.
Rule
IIF(products.unit_cost>$100,.F.,.T.) && IIF() VFP, IFENDIF ; , ;
&& , ; ;
&& , Currency ().
Message :
$100
, . Compare the rules against existing data Yes. .
, Products unit_cost $100, , . .
|
|
42. .
Orders TestData. , File → New . New Report, Wizard.
, Wizard Selection ( ), Report Wizard ( ) One-to many ( ) .
. , . (Step 1), , , . , , ,
(.40, 41) . . , , 1, .
, Summary option, . VFP :
SUM ;
AVG ;
COUNT ;
MIN ;
MAX .
SUM AVG .
Summary Option , , . (Detail and Summary), (Summary only) (No total). Grouping option . .
, 3, . 4 , : . , . , , 2, . , , , Preview. Print Preview (.42) : ; ; . , , Finish. .frx. .frt.
, , Add . , (New).