Save Table Settings

Posted on 2014-09-12
Last Modified: 2014-09-16
I have a startup program that opens more than one table then i organize my tables. After that i type close then restart my startup program and the tables are like i never changed them.
Question by:RVL
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 42

Expert Comment

ID: 40319598
What means "i organize my tables"? Do you shuffle tables displayed in a browse window on the screen? Or something else?

FoxPro remembers window position when you have RESOURCE file defined. So what is your SET RESOURCE setting at the beginning of the startup program?

The reason of your problems can be somewhere else.
Where do you type "close"?  CLOSE command causes an error exception and your error handler can be the reason. etc. etc.

Author Comment

ID: 40319611
yes i have SET RESOURCE ON  in my startup program and in the command window i type CLOSE ALL
LVL 42

Expert Comment

ID: 40319625
Is the resource file writable?
Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

LVL 42

Expert Comment

ID: 40319631
What command do you use to display tables?

Author Comment

ID: 40319645
how do i check if the resource file is r/w? i use BROWSE LAST NAME oGrid_Aleris_Corp NOWAIT
LVL 42

Accepted Solution

pcelba earned 500 total points
ID: 40319678
It should be visible from the location. E.g. Program files folder is r/o by default.

You may also issue:

USE (SYS(2005)) AGAIN ALIAS WhatEver

and try to write into it.

You may also find the appropriate record and check the ReadOnly column.

And you may use:
which will create resource record just for your purpose.

Featured Post

Certified OpenStack Administrator Course

We just refreshed our COA course based on the Newton exam.  With 14 labs, this course goes over the different OpenStack services that are part of the certification: Dashboard, Identity Service, Image Service, Networking, Compute, Object Storage, Block Storage, and Orchestration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question