Update method overwrites with "blank" values (Dynamic SQL)

  • 2 February 2010
  • 0 replies
  • 0 views

Badge +3

Hey.


I have made a smartobject build on a Service instance connected to a SQL server 2005.
The database is shown fine under the servicetype in the smartobject tester, and under the Service Instance i can see the table.


If I expand the table node and the Methods node, i can see five methods, Create, Read, Update, Delete and List. That's okay.


I have created the smartobject by right clicking on the table node and then clicked "Create Smart Object".  The SmartObject is created with no errors.


When testing the smartobject I Create a new record, and that works fine. Lets say my created record is ID (Autonum),Firstname, Lastname, Age so i put in Mickey, Mouse, 30. The record get created with ID 1. That's fine.


Now I test the update method. I use 1 as id, and update the age to 35.  If I now execute the List method i get one record (as expected) but the only value I can se is the age 35 and the id 1. Firstname and lastname is blank.


WHY??



 


 


 


0 replies

Be the first to reply!

Reply