Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

if !file(filename-".ext") how to

Status
Not open for further replies.
agoodrich

agoodrich

MIS
Jul 13, 2004
37
US
If I open a dbf with a list of file names with out the extension how do I do this?

Do while NOT End of file
If the file+".ext" exist Then
do this code
Else
do this code
End do

Thanks.
 
Sort by date Sort by votes
Use Youfile.dbf
sele Yourfile
scan
cFile = rtrim(FieldName)+'.ext'
&& Fieldname is the name of the field in your dbf file that contains the data about the file name you are looking for.

if File(cFile)
do this code
else
do this code
endif
Endscan


Ali Koumaiha
Wireless Toyz
Farmington Hills, Michigan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kyletreyfield
  • Locked
  • Question
VFP9 won't start because of "insufficient memory"
Replies
15
Views
469
Piotr Czekalski
Piotr Czekalski
TheLazyPig
  • Locked
  • Question
If an Excel file already exists in the folder... 1
Replies
2
Views
485
igorsandler
igorsandler
Piotr Czekalski
  • Locked
  • Question
How to set font size and type in TXT file thru VFP6/9 3
2 3
Replies
57
Views
2K
Piotr Czekalski
Piotr Czekalski
Mandy_crw
  • Locked
  • Question
How to get contents of notepad file? 8
2
Replies
26
Views
627
Mandy_crw
Mandy_crw
dmusicant
  • Locked
  • Question
Running Visual Foxpro on local Windows 10 machines, what if any adjustments are needed if I upgrade to Windows 11? 1
Replies
8
Views
789
tomk3
tomk3

Part and Inventory Search

Sponsor

Back
Top