Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALLTRIM in a sql expression of cursoradapter
Message
De
28/03/2010 11:12:05
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01457654
Message ID:
01457678
Vues:
27
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform