Is there a Raisers Edge convention for fields with values of zero and minus one. In the Schema for the RE database, the "Notes" for these fields usually says something like: Is_Constituent In 0, -1 (default = -1) Primary_Addressee_Edit in 0, -1 (default = 0) while the "Description"...

I'm trying to pull the Primary Addressee directly from the RE Tables, but having difficulty. There are fields in the RECORDS table, one called PRIMARY_ADDRESSEE which sometimes shows the full Addressee other times not, which is very bizarre. Anyway, cut a long story short I know its actually quite...

Good day All, I have an RE 7.91 installed in SQL 2K5 standard on a Win Server 2K8. This server houses RE, Deploy and a couple of other file folders related to RE work. It is part of my domain hence SQL is domain aware. SQL is in "windows only authentication mode" because of the enhanced security...

I'm having a little trouble with a query in RODBA, and I'm hoping someone here can steer me in the right direction. I'm trying to pull total gift sum, gift count, and donor count per fiscal year for the last five fiscal years. (This is for only certain funds, only certain appeals, and only...