Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Create a record in a MsSql database thru generator

Created: 25 Feb 2013 • Updated: 25 Feb 2013 | 2 comments
cyberdive's picture
This issue has been solved. See solution.

Good Morning everybody,

My test envirronment is : Windows 2008 R2 64 bits, CMS 7.1 (Version 7.1.8400)  Core I5, 16 Gb ram, SSD 128)

I'm a beginner to workflow, and I would like to connect to an external database to add a record in a simple table (  http://0101.nccdn.net/1_5/1bf/2c8/048/IT-L13---Bui... ).

When I arrive at the step 1-11, the system should propose me to generate the component "Write Records", but on my test server I have less options.

Does anyone have an idea why I don't have the full list of components ?

Thanks in advance for your help.

Regards

Patrick

Operating Systems:

Comments 2 CommentsJump to latest comment

reecardo's picture

a Primary Key is required on a database table to get the ReadRecordsByKey, DeleteRecordsByKey, and WriteRecords component in the Table generator.

If adding a Primary Key to the table isn't an option, you can get around this by using the Query/Script generator and just using an INSERT statement for the script.

SOLUTION
cyberdive's picture

Hi Reecardo,

Thanks a lot for the help, I have, again, learned something ;-)

Regards

Patrick