Powerbuilder Assignment Questions and Answers

Please send your comments to: Raghavan

Richard Hoofring wrote:

> > Dr. Raghavan,

I was working on the assignment you did in class on monday 10/21 and was unsuccessful. Below is the script I used in the clicked event of my tabular datawindow. dw_2 is the freeform datawindow.

• long ll_row
• ll_row = this.getclickedrow()
• string ls_itemid
• ls_itemid = this.getitemstring(ll_row,1)
• dw_2.retrieve(ls_itemid)

This is the error message I received. > > Datawindow Error > > Retrieval arguments provided but none expected!

Do you have any ideas as to what I am doing wrong?

> > Thanks > Richard Hoofring

Answer:

The seocond datawindow object (freeform) that you have attached to the second datawindow control must specify a retrieval argument; go back to redesign the datawindow (you can use the existing datawindow object and make the following changes):

1) Go to the datawindow object painter and bring up the datawindow in question.

2) Go the desing mode if you have by clicking the SQL button in the painter bar.

3) Go the menu item "OBJECT" "RETRIEVAL ARGUMENTS" and specify a retrieval argument variable such as ar_item; make sure it is of the "STRING" type.

4) In the same painter click "WHERE" tab at the bottom to specify a where clause - choose the appropriate column name, = as the operator, and under the column value - right click to bring up the retrieval argument you have specified in step 3 and paste it in the value area.

5) press the "SYNTAX" tab of the tabfolder to check whether your SQL syntax now includes a WHERE clause.

That should do it!

Please send your comments to: Raghavan

© Dr. Vijay V. Raghavan

BACK TO Table of contents

BACK TO DATABASE Main Page