TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15 SELECT HDBK, Hid , HDOCNO, HAMOUNT, STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY, STR(Createdon) AS 'createdon' , hremint FROM <<.TABLES>> ENDTEXTThis command give 42000 RECORDS...
TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15 SELECT HDBK, Hid , HDOCNO, HAMOUNT, STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY, STR(Createdon) AS 'createdon' , hremint FROM <<.TABLES>> WHERE HDBK LIKE '/F1/F4/FC/ ' ENDTEXTThis command give NO record and in do'nt understand the reason...