Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error Indexing a Cursor
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00560265
Message ID:
00560288
Views:
16
>>Vin,
>>
>>Can you post the code?
>
>
>There are a few spots where it is happening. They are all remarkable straightforward. Here's one:
>
> SELECT D.lname, ;
> D.fname, ;
> D.dob, ;
> ROUND(S.score,2) AS RndScr ;
> FROM st_score S, st_demo D ;
> WHERE S.stdid = D.stdid ;
> AND NOT EMPTY(S.score) ;
> INTO CURSOR C_TotScr NOFILTER
>
> INDEX ON lname + fname TAG name && error here
>
>There's nothing special about the underlying tables (st_score and st_demo). The result set varies, but we have duplicated it with just a dozen or so records.
>
>Very strange. These lines of code were written months ago and, again, work on some of the machines just fine.
>

Name is a reserved word. Try renaming the tag to cName or something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform