Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql command
Message
 
 
To
10/10/2009 11:41:26
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01428640
Message ID:
01428642
Views:
33
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform