Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate & Continue
Message
From
07/01/2009 13:08:16
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Locate & Continue
Miscellaneous
Thread ID:
01371809
Message ID:
01371809
Views:
56
Hi All,

I'm having an issue where an error occurs on the continue statement after a locate call, something like:
 LOCATE FOR (PI.pe_dtstart<>CTOD("") .AND. (PI.pe_leavedt=CTOD("") .OR. PI.pe_leavedt>=DATE()))
DO WHILE FOUND()
	* lots of processing 
  SELECT PI
  CONTINUE **** errors here 
ENDDO
One thing to add is that this is processing a view of a sql table.

Now I know its something in the "lots of processing" part thats causing the issue but as yet I havent figured out what.

When debugging I have made sure that:
the correct alias is selcted
the record pointer is sat on the same record
the same number of records are in the table
the filter on the table is the same
the order on the table is the same

Basically I'm after any pointers as to what make a continue command fail, the error it brings back seems to be meaningless.

Any pointers greatly appreaciated.

Thanks

Jon

p.s. - oops I forgot my manners - happy new year to you all.
Next
Reply
Map
View

Click here to load this message in the networking platform