General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only