How do I change a 'read only' file in Foxpro ver 8
I wish to modify structure in a read only file in Foxpro. How do I change file status in order for me to modify field order. I do have source codes. I am not a programmer but can do simple Foxpro manouvres so please explain in laymans terms if indeed it can be done
Thank you
Ian
Thank you
Ian
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Cyril Joudieh
http://www.berezniker.com/content/pages/visual-foxpro/how-change-file-attributes-programmatically
Also:
http://www.news2news.com/vfp/?example=103&function=-1&xpg=13
and one from Microsoft:
http://support.microsoft.com/kb/184525
or Foxite...
http://www.foxite.com/archives/vfp-6-and-attributes-file-0000037650.htm
Simply use Google :-)
I would say more important is the fact above routines do not help if it is read-only cursor...
http://www.news2news.com/vfp/?example=103&function=-1&xpg=13
and one from Microsoft:
http://support.microsoft.com/kb/184525
or Foxite...
http://www.foxite.com/archives/vfp-6-and-attributes-file-0000037650.htm
Simply use Google :-)
I would say more important is the fact above routines do not help if it is read-only cursor...
I use Ecosia and got the first 3 results :-)
Google is the best however Ecosia saves the Earth.
Google is the best however Ecosia saves the Earth.
Hmm, it redirected me to www.google.cz
ASKER
The field order can be modified when opened in Windows Explorer but when I 'do' prg in Foxpro that brings up the file it goes back to the default.
As mentioned my knowledge extends to a few commands. Any changes made outside of file sructure is way beyond my capacity. But thanks for our help.
It seems like a job for a programmer
Ian
As mentioned my knowledge extends to a few commands. Any changes made outside of file sructure is way beyond my capacity. But thanks for our help.
It seems like a job for a programmer
Ian
Yes, ecosia.com but it redirected me directly to http://ecosia.org/ and results were comming from google.cz ... probably more ecological than direct request to google :-))
Question and notes to racepro:
You did not mention you are opening the DBF file in Windows Explorer and column order is always reset to the default state... It seems you don't need to change the file structure but the way how it is displayed. We even don't know what program displays the data...
If it is Visual FoxPro then the column order and much more is stored in resource file for future use and it should remain unchanged when you open the same DBF file next time. Resource file must be enabled, of course. This may be done in its configuration (CONFIG.FPW) stored in Visual FoxPro home folder.
You may ask another question if you need more info about resource file, its creation and possible location.
Question and notes to racepro:
You did not mention you are opening the DBF file in Windows Explorer and column order is always reset to the default state... It seems you don't need to change the file structure but the way how it is displayed. We even don't know what program displays the data...
If it is Visual FoxPro then the column order and much more is stored in resource file for future use and it should remain unchanged when you open the same DBF file next time. Resource file must be enabled, of course. This may be done in its configuration (CONFIG.FPW) stored in Visual FoxPro home folder.
You may ask another question if you need more info about resource file, its creation and possible location.