Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SQLPStatement.setParam

> Sets the value of an SQL statement’s input parameter to the specified value (a literal, procedure variable, or procedure input parameter). This method is common to the `SQLCursor`, `SQLIStatement`, and `SQLPStatement` classes.

> ##### Format

> `public void setParam(int` `f``, Object` `val``)`

> ##### Returns

> None

> ##### Parameters

> `f`

> An integer that specifies which parameter marker in the SQL statement is to receive the value (`1` denotes the first parameter marker, `2` denotes the second, and so on).

> `val`

> A literal or the name of a variable or input parameter that contains the value to be assigned to the parameter marker.

> ##### Throws

> `DhSQLException`

> Example

> This code fragment illustrates `SQLPStatement.setParam`:

>     CREATE PROCEDURE sps_setParam()

>     BEGIN
>     // Assign local variables to be used as
>     // SQL input parameter references
>          Integer ins_fld_ref   = new Integer(1);
>          Integer ins_small_fld = new Integer(3200);
>          Integer ins_int_fld   = new Integer(21474);
>          Double  ins_doub_fld  = new Double(1.797E+30);
>          String  ins_char_fld  = new String("Athula");
>          String  ins_vchar_fld = new String("Scientist");
>          Float   ins_real_fld  = new Float(17);
>          SQLPStatement insert_sfns1 = new SQLPStatement ("INSERT INTO sfns
>           (fld_ref,small_fld,int_fld,doub_fld,char_fld,vchar_fld)
>           values (?,?,?,?,?,?)" );

>          insert_sfns1.setParam(1,ins_fld_ref);
>          insert_sfns1.setParam(2,ins_small_fld);
>          insert_sfns1.setParam(3,ins_int_fld);
>          insert_sfns1.setParam(4,ins_doub_fld);
>          insert_sfns1.setParam(5,ins_char_fld);
>          insert_sfns1.setParam(6,ins_vchar_fld);
>          insert_sfns1.execute();
>     END

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095