Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql command
Message
De
10/10/2009 11:54:36
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
01428640
Message ID:
01428643
Vues:
38
I see. May I ask what's the value of cTableFox2x?

>>Why the '/' ?
>
>
>Because /20/  <>   /200/  <>  /2000/
>
>>cvcondit = " !TempCrystal.ltransfert and  ALLTRIM( TRANSFORM( TempCrystal.telephid ) )  $ oPrivatecParamCR.Condit "
>>
>>>Hi all,
>>>
>>>I have a problem with the syntax for a sql command.
>>>
>>>
>>>oPrivatecParamCR.Condit = "/20/26/38/39/40/42/51/70/1071/1450/1707/1936/"
>>>
>>>cvcondit = " TempCrystal.ltransfert = .F. and '/' +     ALLTRIM( TRANSFORM( TempCrystal.telephid ) ) + '/' $ oPrivatecParamCR.Condit "
>>>
>>>
>>>SELECT * FROM ( cTableFox2x ) INTO TABLE ( cTableToPrint  ) ;
>>>  WHERE &cvcondit
>>>
>>>
>>>
>>>This command give me no result and it is not true !
>>>I think that the reason is perhaps the & ?
>>>
>>>How can i have a just result ?
>>>
>>>Thank in advance for help.
>>>
>>>Bernhart
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform