Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed issue: Set Relation .vs. Set Filter .vs. Select &
Message
From
20/10/1997 23:27:10
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00055022
Message ID:
00055675
Views:
39
>There's no hard feeling here where we are all developers exchanging experiences :)

Thanks!

>I did look at my code, and the work area is selected before the select sql command, and RECNO() is called with no parameters.
>
>SELECT Child
>SELECT RECNO() FROM Child INTO CURSOR C_Child
>
>
>That is the code which is working, however, like you said, adding a parameter to the RECNO() could cause the function to not work correctly. I went with the assumptions that a parameter should work, so I was wrong to assume that.

There are at least 3 ways to break this code by a good VFP programmer using "good programming techniques": :)

1. "Fix" the above code by puting the alias in the RECNO().
2. Adding another table to select from, and... adding the param for RECNO().
3. Using the same code in a different place... just a little different.

:)

BTW, the SELECT Child is useless in your previous piece of code (ie: it doesn't change the result of the following query.)

Vlad
Previous
Reply
Map
View

Click here to load this message in the networking platform