topic No problem! Glad I could help in Product Forum

Unable to add values in Nested Collection

Anonymous — Thu, 14 Sep 2017 11:51:00 GMT

Any idea on how to add row in nested collection? ( I'm using collection having name Email and in that collection I have one another collection called Attachments(having one field called Path (I want to store path of all the attachments in this field) PROBLEM : Whenever I'm trying to add row in Email.Attachment collection, getting error--- "Internal : Failed to find any collection stage with name 'Email.Attachments') How to fix this issue??

An suggestion is to make a

joakimeklund — Thu, 14 Sep 2017 12:24:00 GMT

An suggestion is to make a new collection, add new rows then the attachments like you would usually do repeat as many times as necessary. Then you use a calculation stage to replace the collection within the collection with the one you have made. So it would be like this: 1. Make Collection ""Attachments"" 2. Add new row and value to ""Attachments"" 3. Keep doing step 2 until satisfied then move onto step 4 4. Use a calculation stage to store the collection ""Attachments"" in the collection ""Email"" 5. If you need to do this on multiple rows in the collection ""Email"", just surround all these steps with a loop of the collection ""Email"". Good luck and have fun

Thanks joakimeklund :)

Anonymous — Thu, 14 Sep 2017 13:15:00 GMT

Thanks joakimeklund 🙂

No problem! Glad I could help

joakimeklund — Fri, 15 Sep 2017 11:56:00 GMT

No problem! Glad I could help!

Hi ,

RameshKonka — Fri, 15 Sep 2017 14:16:00 GMT

Hi , I am trying to access Sybase database through blue prism. I am getting the below error. Please provide the solution any one. Internal : Could not execute code stage because exception thrown by code stage: An OLE DB Provider was not specified in the Connection String. An example would be, 'Provider=SQLOLEDB;'. Thanks venkat

To execute an oledb query you

John__Carter — Fri, 15 Sep 2017 14:39:00 GMT

To execute an oledb query you need to specify the correct connection details. connectionstrings.com is a useful site. The oledb driver you specify also needs to be on the local machine.