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