row(index).column("ABC") and row().row().row().column("ABC") always referring to row 0 itself

[bhargavkumar-65]

Hi,
I am trying to read the value at ROW index 3 and column ABC, when i execute below code, getting below error message.
Source source = new Source("jdbc:sqlserver://localhost;database=KMSupportShipping_Office;encrypt=true;trustServerCertificate=true;integratedSecurity=True","","");

      String Query1 = " select * from bu_customer where id='I15910'";
      Table TABLE_BU_Customer = new Table(source, "bu_customer");
              assertThat(TABLE_BU_Customer)
                      .row(3)
                      .column(7)
                              .value().isEqualTo("700");

Error:

java.lang.AssertionError: [Value at index 0 of Column at index 7 (column name : AMOUNT) of bu_customer table]
Expecting:
<"100000.0000">
to be equal to:
<"700">

[VanRoy]

Hi @bhargavkumar-65 Do you facing always to this issue ?