Support > Forums > OpenBots Studio > DataRow in (text to set) is not acceptable.
while using for each loop i added Output collection variable as vDataRow as Type DataRow which is not acceptable under Action Parameter the section Text to set do not accept/acknowledge {vDataRow.Emp ID}--> coming from DataTable vData. By any chance the version is unstable, because i had looked in tutorial videos its working fine i am using version 1.5.
Thanks in advance.
This forum has 317 topics, 687 replies, and was last updated 4 months ago by Nataly Alvarado...
Nishant,
OpenBots Studio v1.5.2 uses C# programming language syntax and formatting across all fields. For example, in order to extract a value from a datarow variable, you'll need to use the following C# expression:
vDataRow["Emp ID"]
If the cell value is not a string, you can convert it by using the following expression:
vDataRow["Emp ID"].ToString()
Also, keep in mind that strings should be concatenated using C# rules as well. For instance:
"this is a hardcoded string " + vData
Let me know if you have further questions!
Hello Nataly, i am using version OpenBotsStudio_v1.5.2.exe and the format says |"data" || vData || vOutputVariable| "data" works fine. in case of VOutputVariable as {vDataRow.Emp ID} from Excel it is not accepting and the box flashes in red. i am stuck.
Hi Nishant,
which version of Studio are you using? The input format will vary depending on the version, since updates where included after v1.5.0.
i am woking on FrontEnd, and it is in openbot.exe. need a viable solution. this is the latest version after 1.5.2 need support
In version 1.5.1 I have
"$type": "OpenBots.Core.Script.ScriptAction, OpenBots.Core",
"ScriptCommand": {
"$type": "OpenBots.Commands.Loop.LoopCollectionCommand, OpenBots.Commands.Core",
"v_LoopParameter": "vDataTable.Rows",
"v_OutputUserVariableName": "vDataRow",
"CommandName": "LoopCollectionCommand",
"SelectionName": "Loop Collection",
...
},
where type of vDatatable is DataTable VdataRow is DataRow
You are not authorized to reply, please click here to login and add your reply to this topic.