Table name req'd for adapter.update ?

  • Thread starter Thread starter mklapp
  • Start date Start date
M

mklapp

Hello,

I was trying to find out why a Sql Server table was
not getting updated. It was being updated by a stored
proc invoked from a web service. th SQLAdapter.update
call returned 0, but no errors. I checked a lot of stuff
and found that if I specified the table name in the
update call :

SqlAdapter1.update(ods,"VISITS")

Everything works nicely.

All my adapters have an explicitly named datatable,
but all of them do not need the tablename in
the ".update" invocation.

mklapp
 
Hello,
They are all configured using the Data Adapter
Configuaraion Wizard. All use (new) Stored Procedures.
Some have update commands genned and others do not.

They all have a custom table specified in the Fill
statement. Some are able to update the DB though the
Update method without the table name. Others need it.

I have not identified the crucial difference here. I
can get it to work by specifying the table name.

Now, if only I can get an answer to my codegen problem.

mklapp
 
Hi,

I guess wizard deducted that table from select sp for some of them while for
others it couldn't.
Is for those sp which doen't work table listed as first table in FROM list?
Anyway, it is easier to pass table in Fill method as you do now.
 
Back
Top