Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT and executing command afterwards!
Message
From
24/08/1998 15:29:50
 
 
To
24/08/1998 15:23:20
Koos Veel
Gamma Research
Aruba
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00129440
Message ID:
00129444
Views:
24
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform