Search found 3 matches

by GaryFanning
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...
by GaryFanning
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...
by GaryFanning
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...