Udate SQL server using disconnected recordsets
That wont work for me. sorry, I needed to give more detail. I'm creating a
disconnected recordset in the business tier and matching the fields to those
of a table on sql server. after I populate the recordset with valid data
and try to connect it, I get an error msg saying something about not knowing
what table to reverence the recordset to. This makes perfect sence since
there is nothing stateing what table. Is there a good way to point it in
the right direction with out having to use data controls? It seems like
there should be a way we can define such things with just code.
Quote:
> Hi
> use
> rs.UpdateBatch
> SVETLI
> > I have a 3tier app running on NT4, VB6, and SQL Server 7. Normally to
> > update data I call stored procedures and pass parameters to them, but in
> > this case, I have a disconnected recoredset. I would like to reconnect
> the
> > recoredset to the server and update the list of records this way. I
found
> > one example in the ADO documentation where it says to use the
> > RDS.DataControl object. I don't use data controls and I manage
everything
> > through code. Isn't there another way to do this?
> > Thanks.
> > --
> > George Padvorac
