Video Screencast Help

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 ( ).

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.



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.

cyberdive's picture

Hi Reecardo,

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