Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create a calculated field
Message
From
01/10/2002 13:51:28
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Create a calculated field
Miscellaneous
Thread ID:
00706493
Message ID:
00706493
Views:
66
I would like to create a calculated field that is based on 2 other fields in a table. The table is included in a database.

For example.
I have 2 fields lets say numerics with data in them.

I add a third field to my table.

Everytime someone updates one of the first 2 fields i'd like the third field to change also.

for simplicity lets say Field1 x Field2 = Field3

3 x 2 = 6

Whats the best way to do this, would I utilize the update trigger and a stored procedure?
Next
Reply
Map
View

Click here to load this message in the networking platform