vp_in ='%/F1/F4/%' 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' ENDTEXTgive no record ?
vp_in ='%/F1/F4/%' 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 ?vp_in ENDTEXT>try
>>vp_in ='%/F1/F4/%' >> 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 ?vp_in >> ENDTEXT >>>
>> TEXT TO .SELECTCMD NOSHOW TEXTMERGE PRETEXT 15 >> SELECT HDBK, Hid , HDOCNO, HAMOUNT, STR( HDOCDATE ) AS 'DATEDOC',CREATEDBY, >> STR(Createdon) AS 'createdon' , hremint FROM <<.TABLES>> >> ENDTEXT >>>>
>> 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/ ' >> ENDTEXT >>>>This command give NO record and in do'nt understand the reason...