Which PeopleCode statement can be used to reference a single row of data in &SQL?

A SQL object is instantiated using the following statement:
&SQL = CreateSQL(“Select EFFORT_SPENT from PS _TASK_TBL
where TASK= :1″, TASK_RSRC.TASK);
Which PeopleCode statement can be used to reference a single row of data in &SQL?

A SQL object is instantiated using the following statement:
&SQL = CreateSQL(“Select EFFORT_SPENT from PS _TASK_TBL
where TASK= :1″, TASK_RSRC.TASK);
Which PeopleCode statement can be used to reference a single row of data in &SQL?

A.
&SQL.Get(&Var);

B.
&SQL.Next(&Var);

C.
&SQL.Fetch(&Var);

D.
&SQL.Select(&Var);

E.
&SQL.Create(&Var);

F.
&SQL.Execute(&Var);

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *