"Lars Gr?tteland" <lars@bas.no> wrote in message
news:f74582e5.0311182351.7d4d10a2@posting.google.com...
> Hello!
>
> Is it possible to update records being shown in a grid when using an
> advanced SP, or do I have to create another SP to update the record?
>
> Using ADO to update, but that shouldn't be a problem I hope.
>
>
> - lars

"Tomislav Kralj" <tomislav.kralj1@zg.tel.hr> wrote in message
news:bpf82h$uhc$1@sunce.iskon.hr...
> It should be possible in cases of simple query inside the sp. If you use
> query that make joins to other tables you might not be able to update data
> in the grid. One solution might be to create INSTEAD OF trigger on the
> tables referenced in query (the ones that you update through grid). Do you
> get any errors ?. Please post errors you get when you try to update the
> grid.
>
>
> --
> Regards,
> Tomislav Kralj
> tomislav.kralj1@zg.tel.hr
>
>
> "Lars Gr?tteland" <lars@bas.no> wrote in message
> news:f74582e5.0311182351.7d4d10a2@posting.google.com...
> > Hello!
> >
> > Is it possible to update records being shown in a grid when using an
> > advanced SP, or do I have to create another SP to update the record?
> >
> > Using ADO to update, but that shouldn't be a problem I hope.
> >
> >
> > - lars
>
>

"Lars Grøtteland" <lars@nospam> wrote in message
news:%23YugFUnrDHA.2244@TK2MSFTNGP09.phx.gbl...
> thanks
>
> It's a pretty advanced table with six joins inside it so you answered my
> question - thanks!
>
> --
>
>
> - Lars
>
>
> "Tomislav Kralj" <tomislav.kralj1@zg.tel.hr> wrote in message
> news:bpf82h$uhc$1@sunce.iskon.hr...
> > It should be possible in cases of simple query inside the sp. If you use
> > query that make joins to other tables you might not be able to update
data
> > in the grid. One solution might be to create INSTEAD OF trigger on the
> > tables referenced in query (the ones that you update through grid). Do
you
> > get any errors ?. Please post errors you get when you try to update the
> > grid.
> >
> >
> > --
> > Regards,
> > Tomislav Kralj
> > tomislav.kralj1@zg.tel.hr
> >
> >
> > "Lars Gr?tteland" <lars@bas.no> wrote in message
> > news:f74582e5.0311182351.7d4d10a2@posting.google.com...
> > > Hello!
> > >
> > > Is it possible to update records being shown in a grid when using an
> > > advanced SP, or do I have to create another SP to update the record?
> > >
> > > Using ADO to update, but that shouldn't be a problem I hope.
> > >
> > >
> > > - lars
> >
> >
>
>

"Lars Gr?tteland" <lars@bas.no> wrote in message
news:f74582e5.0311182351.7d4d10a2@posting.google.com...
> Hello!
>
> Is it possible to update records being shown in a grid when using an
> advanced SP, or do I have to create another SP to update the record?
>
> Using ADO to update, but that shouldn't be a problem I hope.
>
>
> - lars