Informix nonupdatable cursors – PB Docs 2019

Informix
nonupdatable cursors

Declaring a cursor is similar to declaring a variable; a cursor is a
nonexecutable statement just like a variable declaration. The first step
in declaring a nonupdatable cursor is to define how the result set looks.
To do this, you need a SELECT statement. You must associate the result set
with a logical name so you can refer to it in subsequent SQL
statements.

Example

Assume the SingleLineEdit control sle_1 contains the state code for
the retrieval:

The script for the Clicked event for the CommandButton Cb_Extract
is:

// Declare cursor emp_curs for employee table.
// retrieval

DECLARE emp_curs CURSOR FOR
   SELECT emp_id, emp_name FROM Employee 
   WHERE emp_state = :sle_1.text;

// Declare local variables for retrieval.
string   emp_id_var
string   emp_name_var

// Execute the SELECT statement with 
// the current value of sle_1.text.
OPEN emp_curs;

// At this point, if there are no errors, 
// the cursor is available for further processing.

// Declare cursor emp_curs for employee table.

// retrieval

DECLARE emp_curs CURSOR FOR

SELECT emp_id, emp_name FROM Employee

WHERE emp_state = :sle_1.text;

// Declare local variables for retrieval.

string emp_id_var

string emp_name_var

// Execute the SELECT statement with

// the current value of sle_1.text.

OPEN emp_curs;

// At this point, if there are no errors,

// the cursor is available for further processing.

Document get from Powerbuilder help

Thank you for watching.

Powerbuilder Documentation 2019

August 21, 2023

Was this article helpful?

Connection Information

Informix nonupdatable cursors – PB Docs 2019

Informix
nonupdatable cursors

My Website Links