Search found 7 matches
- Tue Jul 02, 2019 5:35 pm
- Forum: General Questions and Discussion
- Topic: Another Shot at this one
- Replies: 6
- Views: 1259
Re: Another Shot at this one
Is this code updating an Access db, or the PowerChurch data files directly? If it's just the Access db, then this looks safe enough. Creating the CSV output at the end could potentially have problems if the last name or first name fields have commas in them. Sometimes users enter "Smith, Jr" in the...
- Tue Jul 02, 2019 10:31 am
- Forum: General Questions and Discussion
- Topic: Another Shot at this one
- Replies: 6
- Views: 1259
Re: Another Shot at this one
Been a while since I replied. Thanks for the list of data files, helped out tremendously. I developed a quick and dirty WinApp program to update my emails as needed, based on the input being a comma delimited file where the emails were kept: using System; using System.Collections.Generic; using Syst...
- Sat Aug 11, 2018 9:31 am
- Forum: General Questions and Discussion
- Topic: Point of the Database Manager?!?
- Replies: 8
- Views: 1166
Re: Point of the Database Manager?!?
Okay, I must just be confused (wouldn't be the first time, :lol: ) I tried an update similar to this one: UPDATE ME SET E_MAIL='abc@email.net' WHERE ENV_NO = 1; UPDATE ME SET E_MAIL='123@email.com' WHERE ENV_NO = 2; UPDATE ME SET E_MAIL='456@email.com' WHERE ENV_NO = 3; UPDATE ME SET E_MAIL='789@ema...
- Sat Aug 11, 2018 9:12 am
- Forum: General Questions and Discussion
- Topic: Point of the Database Manager?!?
- Replies: 8
- Views: 1166
Re: Point of the Database Manager?!?
Thanks for this! Also - I regularly use the Database Manager tool for several things. I know it is a powerful tool and you need to understand the risks before using it. Please leave the functionality in the software for those of us who use it every now and then. I downloaded a separate copy of our D...
- Tue Jul 24, 2018 10:49 am
- Forum: General Questions and Discussion
- Topic: Point of the Database Manager?!?
- Replies: 8
- Views: 1166
Point of the Database Manager?!?
Hello all, I'm wondering - what is the purpose of including the Database Manager functionality if you can't really utilize it? I'm a 15+ year Application Developer with some proficiency in SQL CRUD operations, but I'm scratching my head at why it's in there.... I'd love to do a simple: UPDATE ME SET...
- Thu Jun 07, 2018 7:51 pm
- Forum: General Questions and Discussion
- Topic: Another Shot at this one
- Replies: 6
- Views: 1259
Another Shot at this one
Good evening all,
So - I love the fact that you can download your Powerchurch DB into an Access DB. Love that.
But I'm wondering if there was a schema list of what each table is? Be nice to know so I can really start to use some things here
So - I love the fact that you can download your Powerchurch DB into an Access DB. Love that.
But I'm wondering if there was a schema list of what each table is? Be nice to know so I can really start to use some things here
- Sat Jan 06, 2018 1:28 pm
- Forum: General Questions and Discussion
- Topic: Database Manager
- Replies: 1
- Views: 617
Database Manager
Hello there you all! I was wondering if you could help us. We are in the process of upgrading from 10.4 to 12, but one of the things we are doing is going through and updating existing users in PC with email addresses. I have a knowledge of SQL and would love to do an UPDATE statement (if possible) ...