Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I want use SET FIELDS in complex mode.
Message
From
21/06/2003 06:47:59
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/06/2003 13:18:26
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00802315
Message ID:
00802561
Views:
25
>Hi,
>
>i use SET FIELDS in simple mode ( only on active workarea );
>- SELECT a workarea
>- set filters
>- set index
>- set key
>- set relations
>- SET FIELDS for define expression fields calcField=(field1+3*field2)
>- use fields
>- release FIELDS
>
>I want to bind SET FIELDS to a not active workarea in persistent mode to use calculate fields ;
>
>i can do it ?
>
>Someone has used this command?
>
>Thanks
>
>Fabio

See 'GLOBAL' in Set fields help.

ie:
Close All
set fields global
Use customer
Use orders In 0 order tag cust_id
Use orditems In 0 Order tag order_id
Set relation to cust_id into orders
Set relation to order_id into orditems in 'Orders'
Set Fields to cust_id, company, ;
  orders.order_id, orders.order_date, ;
  orditems.line_no,orditems.product_id, ;
  orditems.quantity,orditems.unit_price,;
  Price=orditems.quantity * orditems.unit_price
Set Skip to orders, orditems
Browse
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform