How to update a table in Sql server from Navision.

Naaz

HI Experts,

I want to update a table in Sql server from Navision. When i use the method as

sqlstmt:= 'update tableA set name=''textname'' where no=''codeno''; where i get the textname & codeno from navision.
adoRS:=adoConnectionExecute(sqlstmt);
adoRS2.Update();
it gives me an error message that "the call to the memeber Update Failed".
But when i check the tableA the value is updated in Sql server using(Select * from TableA) but the result is shown as
codeno name
2000 textname

Plaese tell me where i m going wrong.

TonyH

What version of SQL are you using and why not just use the tools available to you in SQL?

t

Naaz

Hi,
Thanks for the reply...
I am using Sql 2005.& which tools you are talking about?Can you please elaborate.

TonyH

SSIS is the new DTS in SQL2005.

These tools will move data from one table to another, with the agent running you can set them up as jobs too.

t