Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to selectively delete records from a multi-table vie
Message
From
09/09/2007 21:27:39
 
 
To
09/09/2007 21:05:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01253279
Message ID:
01253324
Views:
20
SPT=SQL Pass Through. It is one technology to work with client/server data.

>Hi,
>
>This is also why I am still unfamiliar with the whole story on views. Years back, when I was starting out on my VFP programming, I found that views were too challenging for a beginner. This is why I used stand-alone tables in forms with individual relations built in them, and, interestingly, many of my forms still have them. I'm trying to now upgrade all my forms to views, and hence these threads!
>
>Sergey, when you say 'delete from a single table view or use SPT' could I also interpret it to be equal to locating the uniqueid in the parent table, deleting, and doing a requery? Could you tell me what is SPT?
>
>Thanks a lot,
>
>Steve
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform