How to update VIEW

[Tibor Karaszi]

Peter,

Are you doing SELECT * in the view definition? (Wild guess, really: If you
do, try without...)

--
Tibor Karaszi, Cornerstone Sweden AB
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Please reply to the newsgroup only, not by email.

Peter Cingel <cin...@dean4.jfmed.uniba.sk> wrote in message
news:#wGrnbVm$GA.302@cppssbbsa05...
> Hi there,
>
> I have created a simple view (consists from 2 tables) and I'd like to
update
> data using the view from my VB6 application. But anytime I was about to
> apdate data I got the message:
>
> "Insufficient key column information for updating or refreshing."
>
> Using regular T-SQL Update statement everything works fine. Please let me
> know, what do I have to do to fix the problem. I'd like to get stuck with
> VB6. Please advice soonest! Thanks in advance
>
> --
> Peter Cingel
> Head of Computer Center
> Jessenius Faculty of Medicine, CU
> MARTIN
> Slovak Republic
> cin...@dean4.jfmed.uniba.sk
> www.jfmed.uniba.sk
>
>
>