>*Form Load >SELECT cn_name, cn_port, cn_printer FROM lcontrol ; > WHERE lcontrol.cn_name IN ; > (SELECT ctrlname FROM ctrlset WHERE UPPER(ALLTRIM(ctrlset.ctrlname))="CONTRACT"); > INTO TABLE (hdir+"TEMPLCONTROL.DBF") >>
>*option 1 of option group >USE IN templcontrol >SELE 0 >SELECT cn_name, cn_port, cn_printer FROM lcontrol ; > WHERE UPPER(ALLTRIM(lcontrol.cn_name))="RECEIPT" ; > INTO TABLE (hdir+"TEMPLCONTROL.DBF") >SELE TEMPLCONTROL >PRIVATE lSuccess >lSuccess=CURSORSETPROP("Buffering", 5, "TEMPLCONTROL") >IF lSuccess != .T. > =MESSAGEBOX("ERROR! Could not set buffering mode on temporary table!",0,"Please exit this form and try again.") >ENDIF >THISFORM.GRID1.RECORDSOURCE="" >THISFORM.GRID1.RECORDSOURCE='TEMPLCONTROL' >THISFORM.GRID1.REFRESH() >>
*option 1 of option group THISFORM.GRID1.RECORDSOURCE="" USE IN templcontrol SELE 0 SELECT cn_name, cn_port, cn_printer FROM lcontrol ; WHERE UPPER(ALLTRIM(lcontrol.cn_name))="RECEIPT" ; INTO TABLE (hdir+"TEMPLCONTROL.DBF") SELE TEMPLCONTROL PRIVATE lSuccess lSuccess=CURSORSETPROP("Buffering", 5, "TEMPLCONTROL") IF lSuccess != .T. =MESSAGEBOX("ERROR! Could not set buffering mode on temporary table!",0,"Please exit this form and try again.") ENDIF THISFORM.GRID1.RECORDSOURCE='TEMPLCONTROL' THISFORM.GRID1.REFRESH()Tom