Store Procedure

[beti]

Dear friends,

I'm a newer to PowerBuilder 7. I have some questions reqarding MS SQL Server store procedure.

1. How to I call a store Procedure(SqL server) from a datawindow.
2. if I need to reture a set of records from database..how do I do it? I am a Java programmer, I know we can use resultset and arraylist to store the records....but how about Pbscript?

if anyone can give me advice! Thanks

 

[mbalent]

1) Create your stored proc. Connect to the db in Powerbuilder. Create new datawindow using the wizard and choose 'stored procedure' as your datasource.

2) Once you have done #1 above, you have your record set when your call the retrieve method on the datawindow.