Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ALLTRIM in a sql expression of cursoradapter
Message
From
28/03/2010 11:12:05
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01457654
Message ID:
01457678
Views:
26
>>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...
>>
>>
>>
>Alternatively, try
>
>
> 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 '[F][14C]'
>		      ENDTEXT
>
Assuming that this syntax is supported, you may still need the % %
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform