创建数据集
我们需要建立3个数据集:
1. 建立数据集CustomerId,所用SQL语句:select EBANK.CUSTOMER.CUSTOMER_ID,EBANK.CUSTOMER.CUSTOMER_NAMEfrom EBANK.CUSTOMERwhere EXISTS (SELECT EBANK.CONTRACTSUM.CUSTOMER FROM EBANK.CONTRACTSUM WHERE EBANK.CUSTOMER.CUSTOMER_ID = EBANK.CONTRACTSUM.CUSTOMER)
2建立数据集CustomerInfo:所用SQL语句:select EBANK.CUSTOMER.CUSTOMER_NAME,EBANK.CUSTOMER.TEL,EBANK.CUSTOMER.FAX,EBANK.CUSTOMERTYPE.TYPENAMEfrom EBANK.CUSTOMER,EBANK.CUSTOMERTYPEwhere EBANK.CUSTOMER.CUSTOMERTYPE=EBANK.CUSTOMERTYPE.TYPEIDand EBANK.CUSTOMER.CUSTOMER_ID = ?输入SQL语句后,还要在数据集编辑窗口选择Parameters选项。
双击默认参数Pram1或者选择“Edit”,弹出如下窗口: