Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local views created with free tables -- cannot update ta
Message
From
01/05/2002 17:26:27
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
01/05/2002 17:04:45
Angela Haws
Seminole County Tax Collector
Debary, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00651068
Message ID:
00651626
Views:
19
>Yes, I have a customer number as the primary key, and fields under the primary key are marked updateable.

Open your view, and try this:
?DBGetProp('{view name here}.{key field name here}', 'Field', 'KeyField')
It should return .t.; if it doesn't, you should open it again in the view editor (or just run a corresponding DBSetProp() to set it to .t.) and mark the checkbox to the left of the "updateable" checkbox on that field's line, that should make it a key.

If it still doesn't update after that...

Actually, you say "fields", you have a composite key? Didn't really try it that way, but you should probably mark each field as a key, so in the Update statement the generated SQL would look like "update ... where cKey1=?cValue1 and cKey2=?cValue2 ..." or something to that effect.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform