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:
00587448
Views:
33
>Is it the same question?

Yes, sorry about repetative messages. Each time, I tried to save, it gave me 404 error, so I thought, my messages were not saved. Apparently, they did.

>>
>>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?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform