Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ALLTRIM in a sql expression of cursoradapter
Message
 
 
À
28/03/2010 11:18:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01457654
Message ID:
01457681
Vues:
31
>>>>
>>>> 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 % %
>>
>>Why? I want the first character to be F and the next to be 1,4 or C.
>
>
>I understand - but since we don't know what that field may contain, the % may be necessary
>
>It may contain something like
>
>C1/F4/P7
>
>
>
>In any case - there's not enough information to judge

Right - I assumed that we wanted to extract records with F1 or F4 or FC for the HdBk by looking at the results provided in the screenshot.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform