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
Alerts
Knowledgebase
FAQs
Case Central
Downloads
Forums
Blogs
Support Newsletters
User Guides
System Recommendations
Blackbaud Conferences
Blackbaud Delivers
Target User Forum
Web Seminars
User Groups
Industry Events
Regional Seminars
Who We Are
Contact Us
Careers
Blogs
Press Room
Philanthropy
Nonprofit Resources
Partners
Investor Relations
PCI Compliance
Home
Blogs
Forums
Photos
Downloads
Browse by Tags
.NET
»
api
(
RSS
)
bank account numbers
encrypt
forms
SQL Server
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
API using Visual Studio 2005
I am writing an app in Vb using Visual Studio 2005 and the RE API and have run into a problem displaying a Constituent form. Strangely I have been able to display an RE Gift form in exactly the same environment and with nearly identical code. Has anyone come upon similar problems? The details are .....
Posted to
Forum
by
Peter Falconer
on 08-06-2008
Solved
Ok I have it finally working! The main thing to check for is to go via the RE client into Config -> Fields and check whether all fields, that are marked as required, are provided for in the code. If any of those fields are missing, the API will throw up an error. Upon looking at the exception, the...
Posted to
Forum
by
Paul Black
on 06-20-2008
Re: API Help in .Net - Create Constituent
Ok I have it finally working! The main thing to check for is to go via the RE client into Config -> Fields and check whether all fields, that are marked as required, are provided for in the code. If any of those fields are missing, the API will throw up an error. Upon looking at the exception, the...
Posted to
Forum
by
Paul Black
on 06-20-2008
Re: API Help in .Net - Create Constituent
There seems to be some confusion. I am not updating data via the database, I just tried it to see if there were any constraints. The key field is RECORDS_fld_IS_CONSTITUENT which, if set to true, fails but if set to false works, but only inserts a row in the records table, NOT in the Constituent table...
Posted to
Forum
by
Paul Black
on 06-19-2008
Re: API Help in .Net - Create Constituent
I tried removing the CONSTITUENT_CODE_fld_CONSTIT_ID assignment but I get this error: System.Runtime.InteropServices.COMException (0x80040666): Required Field Missing: Status at BBREAPI7.CRecordClass.Save() I did some more investigation yesterday and discovered that if I set: Code: _record.set_Fields...
Posted to
Forum
by
Paul Black
on 06-19-2008
API Help in .Net - Create Constituent
Hi, My client has purchased Raiser's Edge and requires external systems to integrate their data with RE. I am writing .Net code to manipulate the API to create new constituents but am running into a problem. I tried all the help manuals but am unsure what to do. Code is as follows: IBBSessionContext...
Posted to
Forum
by
Paul Black
on 06-18-2008
Page 1 of 1 (7 items)