question

Arun Kr avatar image
0 Likes"
Arun Kr asked Ralf Gruber edited

Equivalent command for getquerymatchtablerow() command

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

FlexSim 17.1.2
sqltable
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Mischa Spelt avatar image
4 Likes"
Mischa Spelt answered Ralf Gruber edited

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 ];
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

martin.j avatar image martin.j commented ·

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?

0 Likes 0 ·
Ralf Gruber avatar image Ralf Gruber ♦ martin.j commented ·

Martin,

it is explained in the "Miscellaneous Concepts/SQL/Reference" section of the user manual at the very bottom.

Best wishes

Ralf

1 Like 1 ·