Re: Editing a view
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Tue, 26 Apr 2005 20:00:34 -0500
>Using D6 and SQl Server. I have a many levelled
>master-detail-detail-detail set of data I am trying to make the
>editing easier for the lowest level. I created a view with
>multiple joins that shows me exactly what I want. How should I
>edit the data in the view? I have tried working on the
>underlying tables, getting the correct keys, posting the table
>record, closing the query and reopening but no luck.
>
>Firstly, am I approaching this in the right way - I am used to
>dbisam and paradox and perhaps I am not understanding the
>limitations of ADO. Is there some way more simple to make the
>view editable?
Joins in ADO normally are editable. Using Paradox is just a poor choice of
databases for ADO. Switch to Access or better yet SQL server and your joins
should be editable.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- References:
- Editing a view
- From: P . S . Bell
- Editing a view
- Prev by Date: Re: Master / detail with TADODataset?
- Next by Date: Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Previous by thread: Editing a view
- Next by thread: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Index(es):
Relevant Pages
|
