Hi,
Can anyone help me with the method to find the source table's row number when doing an SQL operation?
In previous version of FlexSim getquerymatchtablerow() command will solve the issue.
Regards,
Arun KR
You can include the special column ROW_NUMBER in your query:
Table result = Table.query("SELECT MyTable.ROW_NUMBER, MyTable.ID FROM MyTable");
int rowNumber = result[ 1 ][ 1 ]; int rowId = result[ 1 ][ 2 ];
I cant seem to find mention of this special column ROW_NUMBER anywhere in the documentation. Are there any other special rows or similar SQL features added with the dot-syntax?
Martin,
it is explained in the "Miscellaneous Concepts/SQL/Reference" section of the user manual at the very bottom.
Best wishes
Ralf
11 People are following this question.
