This is my Table in SQL want to get the total number of rows from this table i.e, 12
This is my logic behind this, but its giving the output as : “1”
from docu we see:
Output
- DataTable - The output of the SQL command wrapped in a DataTable variable.
with the assumption of Output is the result of the query returned by the activity
- set a breakpoint on the disconnect activity
- debug and get paused
- inspect the variables as mentioned here:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum
e.g. immediate panel and outputing the Output variable
Yeah i tried to add write range activity after excute query…
i am getting proper output here… but i am not getting how to print it inside the message box
but we asked for checking it within debug and panels
as a datatable is returned we would assume that Output.Rows(0)(0).toString would work, but can be crosschecked within the debug / analysis run
Yeah i checked in Local panel, In there “output” variable stored this value “[Column112]”
Thanks , Output.Rows(0)(0).toString is working
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.