Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with TABLEUPDATE()
Message
From
11/02/2002 11:22:12
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
11/02/2002 09:52:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00615959
Message ID:
00618384
Views:
31
Hi Bernard,
All what I see are the following fields
>           Field      wrecid
>                      *KeyField        TRUE
>                      *Updatable       TRUE
>                      *UpdateName      dbfinal!whymove.rec_id
>                      *DataType        C(8)
>           Field      widnr
>                      *KeyField        TRUE
>                      *Updatable       TRUE
>                      *UpdateName      dbfinal!whymove.idnr
>                      *DataType        N(6)
>           Field      frecid
>                      *KeyField        TRUE
>                      *Updatable       TRUE
>                      *UpdateName      dbfinal!finaltable.rec_id
>                      *DataType        C(8)
>           Field      fidnr
>                      *KeyField        TRUE
>                      *Updatable       TRUE
>                      *UpdateName      dbfinal!finaltable.idnr
>                      *DataType        N(6)
As far as I know this construction is valid as long as the tables "whymove" and "finaltable" are unique with "rec_id" and "idnr" together.
If Rec_id is candidate or primary index of this tables idnr shall not be a keyfield.

Or to look from the other side:
KEYFIELD in view points to the primary index in table. Any other field is not a KEYFIELD.

HTH

Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform