3/25/2024 11:14 AM | |
Joined: 1/21/2013 Last visit: 4/26/2024 Posts: 2714 Rating: (440)
|
Hi Nico, The result of an SQL SELECT statement, called a result set, is organized in a tabular format. This means that the values are arranged in rows and columns, even if your result contains only a single value. Therefore, you usually need to parse your result. However, if you know the exact location and are sure it will not change, you can access the value directly. If your SELECT statement always returns a single value called "rMax" (or an error instead), you can access this value using results.Results[0].Rows[0].rMax. If you want to execute multiple SELECT statements, you can call the "Execute" method multiple times. Or, you can combine multiple SELECT statements into a single method call by separating them with a semicolon. However, in this case, an error in any of the SELECT statements will cause the method call to reject the entire promise. Kind regards |
This contribution was helpful to1 thankful Users |
3/25/2024 2:10 PM | |
Joined: 8/3/2009 Last visit: 4/26/2024 Posts: 12869 Rating: (1641)
|
Hello Nico I think in this new FAQ there are also a few information to this topic https://support.industry.siemens.com/cs/de/en/view/109806573 bye Murof |
If this Information really helps, you could use the Rate function |
|
Follow us on