Re: D7 errors with complex dataset command text

"Keith G Hicks" <krh@xxxxxxxxxxx> wrote in message
news:44621599$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Thanks for the info Kevin. That helps. I have a feeling it's some MDAC
thing. I did try changing this to a view but SQL won't let me update it if
it's a view. I need the dataset to be editable. So I tried indexing the
view
and the subqueries I'm using won't allow for that. So I couldn't get any
of
that to work either. TBetterADO solved the problem so far.

You can have updatable views by using Instead Of triggers (see Books Online)
or use TClientDataSets (2-tier model)

http://community.borland.com/article/0,1410,22571,00.html
http://community.borland.com/article/0,1410,20847,00.html

<shameless plug>
Our web site's, http://www.midwayusa.com , shopping cart underlying data
access is all done through views updated through a 2-tier model.
</shameless plug>

Good luck,
krf


.

Relevant Pages

  • Re: Help constructing View
    ... elementary and genious level. ... the base of the ladder, or the top of the ladder. ... {{begin shameless plug}} ... I like SQL FOR SMARTIES for people heading for the top end, ...
    (microsoft.public.sqlserver.programming)
  • Re: Help constructing View
    ... Besides Joe Celko's books, I would also advice reading SQL Server Magazine ... >> {{begin shameless plug}} ...
    (microsoft.public.sqlserver.programming)
  • Re: Help constructing View
    ... I bought and use your Advanced SQL Programming... ... I have moments of clarity when I completely understand what is happening, ... > {{begin shameless plug}} ...
    (microsoft.public.sqlserver.programming)