Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALLTRIM in a sql expression of cursoradapter
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01457654
Message ID:
01457688
Views:
35
Ouf ! Thank naomi
 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 (<<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...
>>
>>
>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
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform