fld1 flag
001 .t.
001 .f.
* this will give you two records>SELECT cn_name, cn_port, cn_printer FROM lcontrol ; > WHERE !EMPTY(lcontrol.cn_name) .and. lcontrol.cn_name IN ; > (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .T.); > INTO TABLE (hdir+"tTEMPLCONTROL.DBF") >>
>SELECT cn_name, cn_port, cn_printer FROM lcontrol ; > WHERE !EMPTY(lcontrol.cn_name) .and. lcontrol.cn_name IN ; > (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .F.); > INTO TABLE (hdir+"tTEMPLCONTROL.DBF") >>
>SELECT cn_name, cn_port, cn_printer FROM lcontrol ; > WHERE !EMPTY(lcontrol.cn_name) .and. lcontrol.cn_name NOT IN ; > (SELECT ctrlname FROM ctrlset WHERE ctrlset.printform = .T.); > INTO TABLE (hdir+"tTEMPLCONTROL.DBF") >>