Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Entry Validation Form
Message
De
12/04/2003 08:59:54
Kiran Bajaj
Yes Bank Ltd
Mumbai, Inde
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Data Entry Validation Form
Divers
Thread ID:
00776925
Message ID:
00776925
Vues:
64
Can someone send across the code for a sample data entry form with validations,computed fields

Structure for table:D:\PSR MONITOR\UNFIXEDDEALSREGISTER.DBF
Number of data records: 1
Date of last update: 04/12/03
Code Page: 1252
Field Field Name Type Width Dec Category
1/A DATE Date 8 User Input
2/B DEALREF Character 50 User Input
3/C CUSTOMERCD Character 50 User Input
4/D CUSTOMER Character 50 User Input
5/E QTY Numeric 4 User Input
6/F QTYINOZ Numeric 7 3 User Input
7/G NOTIONALMR Numeric 6 2 User Input
8/H PREMIUM Numeric 4 2 User Input
9/I NOTIONALFX Numeric 5 2 User Input
10/J USDVALUE Numeric 20 2 Computed(6*(7+8))
11/K INRVALUE Numeric 20 2 Computed(10*9)
12/L CUSTOMSDUT Numeric 20 2 User Input
13/M OCTROIDUTY Numeric 20 2 User Input
14/N COMM Numeric 20 2 User Input
15/O SALESTAX Numeric 20 2 User Input
16/P DEALVALDTD Numeric 20 2 Computed(11+12+13+14+15)
17/Q AMTCOLL Numeric 20 2 Computed(16*110%)
18/R CURRMKTVAL Numeric 20 2 =((($P$2+G7)*E7*$P$4+K7+L7)+((($P$2+G7)*E7*$P$4+K7+L7)*1%))
19/S M2MLOSS Numeric 20 2 =IF(Q7>O7,Q7-O7,0)
20/T PSRUTIL Numeric 20 2 =IF((Q7*110%)>P7,(Q7*110%)-P7,0)
21/U MONIESCOLL Numeric 20 2 User Input
** Total ** 425

Computed Fields to be populated upon exiting from a user input field.

Can some one help with a from to
Add Records(option to clear all fields/cancel midway)
Modify Records
Delete Records
Fetch For Records based on a field input
Close Form


Thx & Rgds,

KB.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform