Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Keys requirement for views with Send SQL updates
Message
From
27/04/2006 13:54:14
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01117191
Message ID:
01117195
Views:
14
Any of the SQL view operations require a key to work correctly.

>Hi all,
>
> I've not done this before and could/should experiment to get my answer but thought someone here might have had this experience...
>
> I'm considering building updateable Views into the tables of an old pre-existing app. I find that some of the old tables weren't designed to have any unique keys. This would seem to be a problem for the View's Key requirements when it performs an SQL update. Is this true? Would the 'Update using' options of "SQL DELETE then INSERT" versus "SQL UPDATE" make a difference in this case?
>
>Thanks,
>Steven-

(On an infant's shirt): Already smarter than Bush
Previous
Reply
Map
View

Click here to load this message in the networking platform