>Hello,
>
>We are using VisualFoxPro 5.0b.
>
>We would like to review a table and then record for record execute a command on a record. Just like a while eof() loop routine.
>
>So for instance we have a table which containts filenames. We would like to see if all these filenames exist and if not create them.
>
>How do we go about doing this with VisualFoxPro?
>
>Thanks in advance for your time and examples!
>
>Greetings,
>Michiel Willems
>Using the account of Koos Veel.
You can SCAN table and check for FILE(). You can also use SELECT-SQL:
Select FILE(table1.filename) AS fileexist From Table1
Edward Pikman
Independent Consultant