February 17, 2023, 9:06pm
Hello everyone! I would like to know if when I use the activity of extracting a table from a database using a query to it, the allowed size of the columns in the datatable object that is generated is the same as that established in the database.
Thank you so much!
February 17, 2023, 9:12pm
The maximum number of columns allowed in a DataSet, across all its tables, is
16,000 columns . According to MSDN DataTable Class “The maximum number of rows that a DataTable can store is 16,777,216”
February 17, 2023, 9:28pm
Hello! It’s not what I meant. I would like to know what maximum size of characters could enter a cell of a datatable that was extracted from a database.
For example, if “Column 1” is configured as VARCHAR(50) in the database, when it is extracted from the UiPath as data table, would this field also have a maximum capacity of 50 characters too?
February 17, 2023, 9:48pm
Use below code to get the maximum char allowed for that particular column
February 24, 2023, 1:45pm
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.