YouarecreatingtheSAL_INFOdatablockontheEMP_QUERYform.TheSALARYfieldshouldonlybepopulatedif
A.ClicktheDataBlocksnodeintheObjectNavigatorandclickthecreatebutton.Choosetobuildthedatablockmanually.EntertheprocedurenameintheQueryDataSourceColumnspropertyandtheprocedurecodeintheQueryDataSourceArgumentsproperty.
B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasethedatablockonthecolumnsincludedintheprocedure.
C.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘Refcursor‘,andenterthenameoftheprocedureintheQueryDataSourceNameproperty.
D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.AltertheQueryDataSourceName,QueryDataSourceColumns,andQueryDataSourceArgumentspropertiestocreateastoredprocedurethatusesarefcursor.
E.LaunchtheDataBlockWizard,selectStoredProceduresasthedatasourcetype,andbasetheblockontheprocedure.