How to update a table in Sql server from Navision.

Naaz
Naaz Member Posts: 6
edited 2009-04-06 in NAV/Navision Classic Client
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.

Comments

  • TonyH
    TonyH Member Posts: 223
    What version of SQL are you using and why not just use the tools available to you in SQL?

    t
  • Naaz
    Naaz Member Posts: 6
    Hi,
    Thanks for the reply...
    I am using Sql 2005.& which tools you are talking about?Can you please elaborate.
  • TonyH
    TonyH Member Posts: 223
    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

Categories