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??