We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Retrieve values

soorraj
soorraj asked
on
Medium Priority
378 Views
Last Modified: 2013-12-26
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.
Example
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
Test3="12/10/2008"
Test1=1
Test2= "cyto"

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.

Comment
Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
I'm assuming you have already assigned a transaction object to the datawindow control to connect it to the database e.g.

DW.SetTransObject(sqlca)

Open in new window

Author

Commented:
Thanks it worked
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.