使用存储过程创建datawindow

今天饶有兴趣,对使用stored procedures创建datawindow作了学习分析,作笔记如下:
PowerBuilder Help 说明:
OLE DB Using database stored procedures in DataWindow objects

You can use database stored procedures as a data source for DataWindow objects. The following rules apply:

• Result set definition You must define what the result set looks like in the DataWindow painter. PowerBuilder cannot determine this information from the stored procedure definition in the database.
• Stored procedure arguments The DataWindow painter provides the arguments for stored procedures only if the driver you are using to connect gives PowerBuilder the required information. If the arguments for the database stored procedure are not provided, you must define them.
• DataWindow updates Updates are not allowed for stored procedures in a DataWindow object. Only retrieval is allowed.

说明:
①存储过程返回的结果集,如果存储过程有多个结果集,则填写对应的结果集序号,从1开始.
②这里是存储过程名称及组号,格式:存储过程名称;组号.

 

怎么以组号的形式创建存储过程?这里引用了来自~零度浪漫~的文章:以组号的形式创建存储过程

 

以组号的形式创建存储过程
      命名方式"create procedure procname;1",这里使用了分号,后面跟的是数字,"procname"是组名,1就是存储过程的名字了,这里名称只能使用数字类型,而且必须从组号为1的开始创建,没有组号1就不能使用大于1的组号;调用方式和调用普通的存储过程一样.

     总结:这种方式虽然方便,针对某个表的相关存储过程一看便知,但美中不足的是,如果以这种方式命名的存储过程过多,就不能以名称来分辨存储过程的功能了..........