Welcome to Forums
Sign in
|
Join
|
Help
|
Forums
in
Current Tags
(Entire Site)
Search
Higher Education
Human Services
Healthcare
K-12 Schools
Arts & Cultural
Faith-Based
Foundations
Environmental
Animal Welfare
Associations
Fundraising
Constituent Relationship Management
Financial Management
Education Administration
Website Management
Direct Marketing
Ticketing
Consulting Services
Blackbaud Interactive
Training
Data Enrichment Services
Blackbaud OnDemand
Custom Report Solutions
Staffing Solutions
Maintenance
Disclaimer
Donor Acquisition
Prospect Research
Performance Benchmarking
Data Enrichment Services
Higher Education
Human Services
Healthcare
K-12 Schools
Arts & Cultural
Faith-Based
Foundations
Environmental
Video Interviews
Latest News
Knowledgebase
FAQs
Case Central
Downloads
Forums
Support Newsletters
User Guides
System Recommendations
Blackbaud Conferences
Industry Events
Regional Seminars
Web Seminars
User Groups
Who We Are
Contact Us
Careers
Press Room
Philanthropy
Nonprofit Resources
Partners
Investor Relations
Home
Blogs
Forums
Photos
Downloads
Browse by Tags
SQL
(
RSS
)
.NET
api
bank
bank account
constituent data
diagram
encrypt
logging
logs
query
Raisers Edge
replication
Schema
SQL Server 2005
VBA
Search for Constituents by bank account
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...
Posted to
Forum
by
Eric Bracke
on 10-19-2008
Re: Querying Constituent information from RE
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 ...
Posted to
Forum
by
Angela Natcheva
on 10-14-2008
SQL Server 2005 Replication and RE 7
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...
Posted to
Forum
by
Scott Crow
on 09-18-2008
Translation Table for “INDICATOR” in CONSTIT_ADDRESS
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...
Posted to
Forum
by
John Rice
on 08-21-2008
SQL Server 2000 Transaction Logs
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...
Posted to
Forum
by
Fred Gaines
on 03-25-2008
Queries Exhaust All Server Disk Space (SQL tempdb file blows up)
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...
Posted to
Forum
by
Paul Carreiro
on 03-10-2008
Log To SQL
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...
Posted to
Forum
by
Mitchell Gibbs
on 03-10-2008
Queries of Doom
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...
Posted to
Forum
by
Paul Carreiro
on 02-26-2008
Page 1 of 1 (8 items)