#cdt I am using a cdt that has an auto generated id. I am writing this to

chrish433 over 9 years ago

#cdt
I am using a cdt that has an auto generated id. I am writing this to a table and then having to manipulate data. Due to complexity of manipulation I am using a stored procedure and trying to repopulate this cdt with the result set but it doesn't pass back the id, it passes a null, even though the result set says to populate it.

Is there anyway of manually populating an auto generated id or is it a case of having a mirror cdt and populating it that way?

Discussion posts and replies are publicly visible

0 PhilB
A Score Level 1
over 9 years ago

Does your stored procedure contain updates or inserts? If so, try switching on SET NOCOUNT (or whatever the equivalent for your database is). The stored procedure node may be trying to map the "n rows affected" reply from the stored procedure to the result set rather than the reply you actually want.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel