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.

Copy

Syntax

Close Cursor CursorName        

where:

  • CursorName is the name of the open cursor.
Copy

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.

Copy

Syntax

Close Cursor CursorName        

where:

  • CursorName is the name of the open cursor.
Copy

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