Posted on 2011-04-28
I am new to powerbuilder. i am having problems passing and Retrieving values.
How do i pass the values to the datawindow where my SQL resides.
IF there is more than one row(result) i want to do something else.
I created a DataWindow. The datawindow has a sql statement.
SELECT test1, test2, test3 from product
WHERE (test1 = :test1 ) AND
( test2 = :test2 ) AND
( test3 = :test3 )
ORDER BY test3 DESC
Now in my code
i am assigning the dataobject
DW.DataObject = 'DW_update' this is my datawindow name
Here i am assigning the values for the sql statement the SQL gets three arguments
My question is how do i pass the values to the datawindow and if there are more than zero rows i want to do something else.