Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with code
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00587201
Message ID:
00587310
Views:
27
The code looks fine to me. What the actual problem is?

>
>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