Mensaje
 
a
28/03/2010 11:18:08
General information
Foro:
Visual FoxPro
Category:
Programación, sintáxis y comandos
Miscellaneous
ID de la conversación:
01457654
ID del mensaje:
01457681
Views:
32
>>>>
>>>> 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
Previous
Next
Responder
Mapa
Ver