Question: Structure Changes in Tables from v8 to v9

Got a question or comment about PowerChurch that doesn't belong anywhere else? Why not post it here!?

Moderators: Moderators, Tech Support

Post Reply
steviebu
Posts: 5
Joined: Fri Jun 11, 2004 8:07 pm

Question: Structure Changes in Tables from v8 to v9

Post by steviebu »

I am developing software that reads data from the ME*, MA* and SK* tables in PowerChurch and displays the data in my system. I have a few questions about these tables:

Has the structure changed for any of these tables between v8 and v9?

Have any of the data elements that were stored in these tables in v8 been moved to different tables in v9?

Thanks,
Steve

NeilZ
Posts: 10435
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Question: Structure Changes in Tables from v8 to v9

Post by NeilZ »

steviebu wrote:I am developing software that reads data from the ME*, MA* and SK* tables in PowerChurch and displays the data in my system. I have a few questions about these tables:

Has the structure changed for any of these tables between v8 and v9?

Have any of the data elements that were stored in these tables in v8 been moved to different tables in v9?

Thanks,
Steve
What are you using to develop in, and do you have a copy of v9.0 ?? I've seen table changes in every update we've used here. You can get a schema of each table easily using the Database Manager under utiliies :

use me
display structure

This works under 8.0 and 9.0.
Neil Zampella

Using PC+ since 1999.

steviebu
Posts: 5
Joined: Fri Jun 11, 2004 8:07 pm

Post by steviebu »

Thanks for the reply. I am writing my system in C++ and using ODBC to access the tables. I am doing the development at my home and do not have easy access to the PowerChurch system that is installed at my church. I have no problems accessing the data in the files. A secretary at the church has informed me that there is a new version installed.

Thanks for the reminder about getting the structure. I had forgotten that I could do that from within PowerChurch.

Does anyone know if these tables are still valid in v9? I'm concerned that they may be remnants from v8 that were not removed during the upgrade process (I'm in the dark about the files that were there and should be there because I didn't do the installation--of either v8 or v9).

Thanks,
Steve

NeilZ
Posts: 10435
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Post by NeilZ »

steviebu wrote:Thanks for the reply. I am writing my system in C++ and using ODBC to access the tables. I am doing the development at my home and do not have easy access to the PowerChurch system that is installed at my church. I have no problems accessing the data in the files. A secretary at the church has informed me that there is a new version installed.

Thanks for the reminder about getting the structure. I had forgotten that I could do that from within PowerChurch.

Does anyone know if these tables are still valid in v9? I'm concerned that they may be remnants from v8 that were not removed during the upgrade process (I'm in the dark about the files that were there and should be there because I didn't do the installation--of either v8 or v9).

Thanks,
Steve
Those tables are still valid.
Neil Zampella

Using PC+ since 1999.

Post Reply