INSERT into a view on joined tables in VFP

I

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…

Add comment

About Craig

I'm the co-host of HubShots and the CEO of XEN - helping mid-large B2B companies with their digital marketing and lead generation.

Craig Bailey

Archives

Posts

BERT