Database Manager
Moderators: Moderators, Tech Support
Database Manager
Where can I find a list of the Database Manager commands?
Re: Database Manager
What are you trying to do ??PCPCKW wrote:Where can I find a list of the Database Manager commands?
Neil Zampella
Using PC+ since 1999.
Using PC+ since 1999.
Re: Database Manager
View and/or make corrections to a dbf. The only db command I remember is the browse cmd. Also looking for a listing of which of the db files in the PC+ folder are used for - such as CO.dbf is for Contributions, etc.
-
- Program Development
- Posts: 1225
- Joined: Fri Sep 05, 2003 11:43 am
- Location: PowerChurch Software
- Contact:
Re: Database Manager
Here is a link to the table list:
http://www.powerchurch.com/support/kb/k ... icle_id=75
If you choose to do this, you will be accessing the tables directly and there are no validation controls. It is very easy to cause problems in the data by orphaning records or not populating required fields.
If you know sql commands most should work fine.
Here is a link to the sql update command: http://fox.wikis.com/wc.dll?Wiki~UpdateSQL~VFP
To see a field list you can enter:
USE <tablename> <Enter>
LIST STRUCTURE <Enter>
if you want a hard copy of the structure you can use:
LIST STRUCTURE TO PRINT <Enter>
I can't stress enough how carefull you need to be. Before you do anything, I would make sure you have a good current backup, just incase a command doesn't so what you expected it to. The database manager was designed as a tech support tool for technicians to see the data directly.
What specifically are you trying to do? There may be ways in the program to accomplish what you want to do.
http://www.powerchurch.com/support/kb/k ... icle_id=75
If you choose to do this, you will be accessing the tables directly and there are no validation controls. It is very easy to cause problems in the data by orphaning records or not populating required fields.
If you know sql commands most should work fine.
Here is a link to the sql update command: http://fox.wikis.com/wc.dll?Wiki~UpdateSQL~VFP
To see a field list you can enter:
USE <tablename> <Enter>
LIST STRUCTURE <Enter>
if you want a hard copy of the structure you can use:
LIST STRUCTURE TO PRINT <Enter>
I can't stress enough how carefull you need to be. Before you do anything, I would make sure you have a good current backup, just incase a command doesn't so what you expected it to. The database manager was designed as a tech support tool for technicians to see the data directly.
What specifically are you trying to do? There may be ways in the program to accomplish what you want to do.
Re: Database Manager
I really appreciate all the help/support. I will be careful. My typical routine is to run a MS Windows backup routine of the entire PC+ directory PRIOR to beginning any work sessions, and then once in PC+ I perform a Utilities/Backup of the module files I am going to work on. Comes from my 20+ years of working on PC's and networks. Call me old fashioned, leary and/or skeptical, but things always go wrong just when it is expected least.
Again - appreciate all the responses. Very helpful.
Again - appreciate all the responses. Very helpful.