I am just learning how to us WF Maintain and am working through the tutorials. I have a HTML table which will be populated from an Oracle table. Set up the form, stacks but when the maintain deploys (on Dev Studio - localhost)no data is retrieved. I hav a focus exe that retrieves the same data OK.

Is this an oracle issue? Or am I missing something simple?

Maintain:

MAINTAIN FILE form_fse_insp

$$Declarations

Case Top
Infer form_fse_insp.FORM_FSE_INSP.FORM_FSE_INSP_KEY into FSEFormStack;
Winform Show Form1;
-* Replace the Winform Show command with the following code
-* when to display your form in a non-persistent state
-* Winform Show_and_exit Form1;
EndCase

Case GetFSEData
Reposition form_fse_insp.FORM_FSE_INSP.FORM_FSE_INSP_KEY ;
Stack clear FSEFormStack ;
For all next form_fse_insp.FORM_FSE_INSP.FORM_FSE_INSP_KEY into FSEFormStack ;
EndCase
END

master file description:
FILE=form_fse_insp, SUFFIX=SQLORA
SEGNAME=FORM_FSE_INSP, SEGTYPE=S0, $
FIELD=FORM_FSE_INSP_KEY, ALIAS=FORM_FSE_INSP_KEY, USAGE=P19, ACTUAL=P10, PROPERTY=KEY, $
FIELD=OPERATION_ID, ALIAS=OPERATION_ID, USAGE=P7, ACTUAL=P8, MISSING=ON, $
FIELD=LHU, ALIAS=LHU, USAGE=A2, ACTUAL=A2, MISSING=ON, $
FIELD=USERID, ALIAS=USERID, USAGE=A6V, ACTUAL=A6V, MISSING=ON, $
FIELD=DATE_MONTH, ALIAS=DATE_MONTH, USAGE=A2, ACTUAL=A2, MISSING=ON, $
FIELD=DATE_DAY, ALIAS=DATE_DAY, USAGE=A2, ACTUAL=A2, MISSING=ON, $
FIELD=DATE_YEAR, ALIAS=DATE_YEAR, USAGE=A2, ACTUAL=A2, MISSING=ON, $
FIELD=TIME_HR, ALIAS=TIME_HR, USAGE=A2, ACTUAL=A2, MISSING=ON, $
FIELD=TIME_MIN, ALIAS=TIME_MIN, USAGE=A2, ACTUAL=A2, MISSING=ON, $
FIELD=SERVICE, ALIAS=SERVICE, USAGE=A2, ACTUAL=A2, MISSING=ON, $

K,

Where do you Perform GetFSEData?

Kevin

If you do not have an Event on the form to PERFORM GetFSEData, you need to issue the command explicitly...for instance;

quote:

Case Top
Infer form_fse_insp.FORM_FSE_INSP.FORM_FSE_INSP_KEY into FSEFormStack;
PERFORM GetFSEData();
Winform Show Form1;
-* Replace the Winform Show command with the following code
-* when to display your form in a non-persistent state
-* Winform Show_and_exit Form1;
EndCase

Kevin is correct. The Infer command creates the stack but you need a NEXT command to load it. Place PERFORM GetFSEData(); before your WINFORM command in the TOP case you and will get your data.

quote:

PERFORM GetFSEData();

Thanks everyone, that worked.