11/22/2024 8:51:28 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Insert Opportunity, Contact, Attachment
Posted: 26 Feb 08 2:18 PM
|
| Currently I have an external application that I am using to insert a new opportunity. I then search the contact table to see if the they exists, if not, I insert a new contact. Upon doing so, I use the opportunityid as well as the contactid to create a new record in the opportunity_contact table. I am using the SLX OleDb Provider to make the Db connection, but I do not quite understand what else I can do with the SLX OleDb Provider. Should I be using the provider to perform the inserts in a manner not using OleDbCOmmands? Any links to applications of the provider would be helpful. I have looked through most of the threads on here, but do not have a good sense of the capabilities. |
|
|
|
Re: Insert Opportunity, Contact, Attachment
Posted: 29 Feb 08 4:56 PM
|
Hi Anthony,
It's just an OLEDB provider. Nothing more. You just use it to perform reads and writes to the SLX database. As you "read" (perform queries) the security for the user you supplied in the connection string is applied to the results. As you write (perform inserts/updates/etc) the transactions are logged so they will sync out to remotes.
That's about it. |
|
|
|
Re: Insert Opportunity, Contact, Attachment
Posted: 03 Mar 08 3:51 PM
|
| Thanks Ryan, I appreciate the reply. My thoughts were that it was simply a provider that could user accounts for security. After reading various posts I became slightly confused in the functionality, things along the line of auto creating unique ID's such as contactid or opportunityid. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|