home *** CD-ROM | disk | FTP | other *** search
- SELECT A
- USE (LOCFILE("DATA_1.DBF","DBF","Where is data_1?"));
- ALIAS a ;
- INDEX DATA_1
- SET ORDER TO TAG LJNO OF DATA_1.CDX
- SELECT B
- USE (LOCFILE("DATA_2.DBF","DBF","Where is data_2?"));
- ALIAS b ;
- INDEX DATA_2
- SET ORDER TO TAG RKNO OF DATA_2.CDX
-
- SELECT A
- LOCATE FOR AT(GLOOK1,a.lj_cx) > 0 .OR. AT(GLOOK2,a.lj_cx) > 0
- IF EOF()
- WAIT "┐Γ─┌╬▐┤╦┼Σ╝■" WINDOW
- ELSE
- SELECT B
- SEEK a.ljno
- IF FOUND()
- SET RELATION TO LJNO INTO A
- BROWSE FIELDS a.lj_bm/8:H =" ▒α┬δ ", a.lj_xh/8:H =" ╨═║┼ ", ;
- a.lj_mc/8:H =" ├√│╞ ", kc_rq:H =" ╜°╗⌡╚╒╞┌ ", ;
- kc_sl:H =" ╚δ┐Γ╩² ", kc_cs:H =" ┐Γ┤µ╩² ", ;
- kc_jj:H =" ╜°╝█ ", kc_pf:H =" ┼·╖ó ", kc_ls:H =" ┴π╩█ ",;
- kc_dl:H =" ╚δ═° ", a.lj_yl:H =" ├┐│╡╙├┴┐ ", a.lj_cx:H =" ╩╩╙├│╡╨═ ",;
- a.lj_bz:H =" ▒╕╫ó " ;
- FOR (AT(GLOOK1,a.lj_cx) > 0 .OR. AT(GLOOK2,a.lj_cx) > 0) .AND. b.kc_cs > 0;
- FREEZE kc_dl;
- NOMENU;
- NOAPPEND;
- NODELETE;
- TIMEOUT 60;
- TITLE " ┐Γ┤µ┼Σ╝■▓Θ╤» ";
- PREFERENCE AA
- ELSE
- WAIT "┐Γ─┌╬▐┤╦┼Σ╝■" WINDOW
- ENDIF
- ENDIF
- CLOSE ALL
- RETURN