Database Manager

[PCPCKW]

Where can I find a list of the Database Manager commands?

[NeilZ]

Where can I find a list of the Database Manager commands?

What are you trying to do ??

[PCPCKW]

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.

[Jeff]

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.

[PCPCKW]

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.