Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Close Cursor

Use this command, in conjunction with the Fetch and Open Cursor commands, to close an open cursor.

Syntax:

Close Cursor CursorName

where:

  • CursorName is the name of the open cursor.

Syntax example:

Create Variable amountRow[] as String

Create DataTable EmployeeSalary Using AllSalaries.lvdtd

Download EmployeeSalary

Show DataTable EmployeeSalary

Open Cursor amounts Select "Employee ID, Entity, Amount" From EmployeeSalary

 

While $LVS_FetchStatus$ != -1

Fetch Next DataTableRow from amounts Into amountRow

If $LVS_FetchStatus$ EQ 0

Run Model TransferTableData.lvmod

End If

End While

 

Close Cursor amounts

Published:

Close Cursor

Use this command, in conjunction with the Fetch and Open Cursor commands, to close an open cursor.

Syntax:

Close Cursor CursorName

where:

  • CursorName is the name of the open cursor.

Syntax example:

Create Variable amountRow[] as String

Create DataTable EmployeeSalary Using AllSalaries.lvdtd

Download EmployeeSalary

Show DataTable EmployeeSalary

Open Cursor amounts Select "Employee ID, Entity, Amount" From EmployeeSalary

 

While $LVS_FetchStatus$ != -1

Fetch Next DataTableRow from amounts Into amountRow

If $LVS_FetchStatus$ EQ 0

Run Model TransferTableData.lvmod

End If

End While

 

Close Cursor amounts

For an optimal Community experience, Please view on Desktop