>Hi gregory,
>
>I put a picture with attachment.
>
>(Private)
>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>>
> ENDTEXT
>
>
>This 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/ '
> ENDTEXT
>
>This command give NO record and in do'nt understand the reason...
>
>
Are you looking for F1, F4, FC records? If yes, then
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 IN ('F1','F4','FC')
ENDTEXT
If it's not broken, fix it until it is.
My Blog