Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem in code
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00587207
Message ID:
00587311
Views:
34
Is it the same question?

>
>In BatchCntrl table I have an index in Bintoc(DsID)+ExtrYear+ExtrWeek.
>
>I'm passing DsID as a parameter in a form method. Here is a piece of code:
>
>   lcIssue = .ThisIssue
>    select BatchCntrl
>    lcOldOrder = order()
>    set order to DsIDWeek
>*    BINTOC(dsid)+extryear+extrweek
>    lcFor = iif(vartype(m.tnDsID)="N", ;
>            [for bintoc(DsID)+extryear+extrweek=bintoc(tnDsID)+lcIssue], ;
>            [for State+ExtrYear+ExtrWeek=']+ m.lcStateWeek+['])
>	scan &lcFor
>This doesn't seem to work. Originally I have
>
[for bintoc(DsID)+extryear+extrweek="]+bintoc(tnDsID)+lcIssue+["], ;
>which gave me error on SCAN line. lcFor contains some symbols, which probably & can not recognize.
>
>What can I do here? Change it to separatly use DSID and ExtrYear, ExtrWeek (e.g. don't use DsIDWeek index). I probably can add two more indexes in my table to still use Rushmore optimization.
>
>Still, I'm cursious, is there a way around my problem?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform