Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scan not working in EXE but is fine in Debug
Message
From
20/02/2009 03:21:04
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01383020
Message ID:
01383024
Views:
58
>>I'm trying to update records that have been printed (the cursor "workorders" contains the work orders that have been printed). The records in the main table need to have a flag set so that they do not print again. The following code works perfectly when I'm debugging, however when running as an EXE nothing is updated, and it looks like the scan is not processing anything.
>>
>>
>>	select workorders
>>	go top
>>	scan while !eof()
>>		select WOMaster
>>		seek workorders.WONumber order tag WONumber
>>		if found()
>>			replace WOMaster.WOPrinted with .t.
>>		endif
>>		select workorders
>>	endscan
>>
>>
>>Any observations or suggestions would be appreciated!
>
>There is no need of
>GO TOP
>an SCAN WHILE NOT EOF()
>
>This is enough:
>
>select workorders
>SCAN
>
>....
>ENDSCAN
>
>
>Try this:
>
>select workorders
>SCAN
>   IF SEEK(workorders.WONumber,"WOMaster","WONumber")
>      REPLACE WOPrinted with .t. IN WOMaster
>   ENDIF
>ENDSCAN
>
Huh, why did I even bother replying... {g}.
Nothing passes by unanswered, by you, Sergey or Naomi - within 30 seconds of original post! ;0)
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform