>Hi everyone.
>New to the board, and to computer coding. Of course, I have run into a problem.
>I am building a form that calls a data table.
>I have a filter set to scan through the table to find a part number. Once all records of that particular part number have been found, I want to populate a cursor with those records.
>I can browse my table and see the cursor on my specified part number. That seems to be ok but, when I try to put the desired information into my cursor, it places ALL of the table's records into the cursor.
>What might I be doing wrong?
>Any help is greatly appreciated!
Hi Chad,
Instead of filter and scanning why not do simple SQL SELECT
SELECT * from mytable WHERE part_number = some_particular_part_number INTO CURSOR myparts
Or, you could have parameterized view of your mytable with the same condition as a parameter, then change the parameter for a part number you need and REQUERY() the view.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison