Search found 3 matches
- Tue Apr 27, 2004 6:11 pm
- Forum: Other Modules
- Topic: DatabaseManager - SQL - Multiple Statements Possible?
- Replies: 3
- Views: 4324
DatabaseManager - SQL - Multiple Statements Possible?
I have 1900 birth dates from RDS, the system we migrated from, that I want to update records in PowerChurch. We had imported the information allowed at an earlier time. I have lastname and firstname to match with and the birth date to add (update). Not in another table, was CSV and I have edited eac...
- Mon Apr 26, 2004 9:14 pm
- Forum: Other Modules
- Topic: DatabaseManager - SQL - Multiple Statements Possible?
- Replies: 3
- Views: 4324
DatabaseManager - SQL - Multiple Statements Possible?
Hi, Quick thanks for the last response. I am needing to UPDATE 2000 records in the ME table, matching on the LASTNAME and FIRSTNAME columns and updating the BORN column. I have the my UPDATE working (one at a time), but I have 2000 to execute. I've tried various syntax but I'm finding the proper one...
- Thu Apr 22, 2004 7:59 am
- Forum: Other Modules
- Topic: DatabaseManager - SQL - Matching with LIKE not working
- Replies: 1
- Views: 2827
DatabaseManager - SQL - Matching with LIKE not working
I am very new to PC, using PCP8.5, but have a few years working with SQL based databases. We made some rush decisions in importing data and then creating family units; husband and wife not being in the right order (number 1 or 2) and much more. We want to remove all conventional titles; Mr., Mrs., M...