Thanks David. I implemented as you specified and it really worked . It is very much appreciated and in short span of time you replied which is great. I got one more question related to this.  Is that possible to check the code table entry before adding . As you said we cannot use GetTableEntryID for codetables which are not in ...

Hi David, Thanks for your reply. I implemented your code in C# which is given below , but when im trying to use AddEntry method its unable to add that entry to database . Its always showing "Unable to add entry" . Could you please help me with this. What kind of users can use AddEntry method successfully. I mean what ...

Hi David, Im having similar problem. My problem is adding values to attributes where attribute itself has code table datatype. I got part to that of that code where im able to get the code table entry value for that attribute using Attribute Type Server which is given in api  But im unable to find whether the value exist in attribute or ...

Hi people, Hope all is well at your end. Need some help with Crystal reports. For example if we have a table as follows: Table -------------------- ID  Name  Education     phone 1   John     BE               ...

Hi,   In Education  :  GPA field is set to accept only numeric values and not string or varchars.   I had a look at the education database table in RE (on test system) and GPA field is set to be as numeric. Can change the data type using VB?.   But what I noticed that the degree field was also a ...

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 Source property will tell you which object ...

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 Source property will tell you which object the ...

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. If anyone has been able to successfully ...

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(ERECORDSFields.RECORDS_fld_IS_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 _context; private CRecord _record = new ...