Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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