INSERT into a view on joined tables in VFP

Posted on April 4, 2005. Filed under: Visual FoxPro |

You can insert and delete records on a view that is a join of two tables.

Not sure why I thought you couldn’t do this but I got myself confused over views. I thought you could only insert into views on a single table.
But you definately can insert and delete on joined tables. In my case its on a 1:1 join. I need to investigate if this is the case with 1:M tables too…

Advertisements

Make a Comment

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: