I’m trying to automatically populate the rows of a table with data that I call in using the @DBCommand. Here is the code I use to retrieve the data:
@DbCommand(“ODBC”:“No Cache”;“Oracle”;“name”;“password”;“Select team from employee where office=”+OfficeID+" group by team"))
This code pulls in a different number of records depending on the OfficeID entered. Here is sample data that it retreived:
3;2;7;3;2;1;4
Any ideas on how I can get this data to automatically populate the rows of a table? Thanks.