see message#
1457675 >WHERE HDBK LIKE ?vp_in
>
>give no cursor
>
>AND i try without parameter and i have no records. ???
>
>
>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'
> ENDTEXT
>
>give 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
>>>
>>
>>>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...
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>>>>>I'm assuming that '%' is included into Vp_in already, because otherwise I don't see a reason for using LIKE and not = at all.
>>>>>>
>>>>>>In that case, there's no need to trim, is there ?
>>>>>
>>>>>No need to trim, you're right. I'm wondering why Bernhart insists on trimming.
>>>>
>>>>
>>>>Maybe the %'s aren't in after all
Gregory