Sage CRM

Hello, I have a web application which regularly connects to the CRM trough eware COM object to tranfer data. after a certain amount of connection, the login connection fails and the sql log gives one of these two errors: SQLClasses->DatabaseLogin…

If someone could point me in the right direction I would be really grateful. As the subject suggests I am currently building a CRM List Object within an ASP page which does not reference Metadata. The list itself is working and returning the data as…

Hi All, I am cloning a custom entity record via a custom asp page that performs the following : var recOld = CRM.FindRecord("Shift", "shft_shiftid"+"="+UseId); var recNew = CRM.CreateRecord("Shift"); recNew.shft_Name = recOld.shft_Name; recNew…

Hello, I am seeking clarification related to the overall basic theory of API interaction with SQL databases. Sage CRM is hosted by IIS and some features developed in Java require tomcat hosting service (for Java based web applications). I can…

I've got a screen similar to the below shot: The main thing I'm trying to sort out is the form post and target action. I know I don't have it right yet. The code is attached for the ASP and the SQL view that drives the page. When I tick the…

Hi, I have a pretty unique scenario where an ASP file is encrypted. However, I am able to add my own code on top of it. The requirement is to pre-populate a field with a value from Company table. This is done for the portal and I am using the…

The developer documentation doesn't say what the return data type is when a value is obtained from a query. In the dotNet API, the query object returns a string regardless of the field data type. Is it the same for the COM API? Or is the data type dependant…

I know I can query the Custom_Edits table to find a field type but is there a way to get this info from metadata to avoid issuing lots of queries? I need this so I can find the 'actual' field value for a given field, eg if it's a select field I need…

Hello, When creating a custom table script (Trigger) I cant retrieve a date value. There is also an area in my code where i have to get the current date and time which i can get with no problems by following Jeff's article here https://community…