Hi, I'm looking for a way to find contstituents by their bank account. As off version 7.81 the account numbers are encrypted in the DB. Using the standard CustomWhereClause doesn't work because it queries the raw (encrypted) data. Is there a way to encrypt the plain text (account no) and pass...

For a RE data dictionary I also reference the RE7Schema (on my system it is located at C:\Program Files\Blackbaud\The Raisers Edge 7\Help\RE7Schema.chm). For the query I would suggest using the RECORDS table (I have not, that I recall, ever used the CONSTITUENT table). SELECT RECORDS.CONSTITUENT_ID ...

I am beginning to explore database replication adn RE 7. We are building redundency itno our server farm with another co - location. Our client apps run in a citirx enviroment that points to one RE server now. I've already found the KB article that says replication isn't supported by BB. I'm...

Greetings; Does anyone happen to know what the values in the “INDICATOR” field on CONSTIT_ADDRESS translate into? I specifically need 2, 3, and 7 but I would like the whole list if possible. As this is the second ‘translation table’ question I have asked, is there some place I can go to find this information...

My recent request to our server support team and director to backup the SQL Server transaction logs every two hours was returned with information that the SQL server logs are written to a san/lun and could be recovered if the database was ever lost or interrupted during the business day. I am the technical...

Has anyone run into this problem? A user creates a gift or constituent Query. When they run it, the Raiser's Edge locks up while it attempts to process the query (the panels go white and don't refresh anymore). By itself this is normal for large queries. What happens next is not normal. Back...

We've got a VBA macro and would like to log when whenever someone runs it and the context (what record were they in at the time). So basically, I want to capture the Date, Time, UserName, and ConstituentID-UserName of the record they were in at the time. Ideally, I'd like to send this information...

Has anyone run into this problem? A user creates a gift or constituent Query. When they run it, the Raiser's Edge locks up while it attempts to process the query (the panels go white and don't refresh anymore). By itself this is normal for large queries. What happens next is not normal. Back...