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.
|
|
|
|
Does anybody know the method to use following SLX API's with SLX oledbprovider ??.
Posted: 10 Oct 08 8:22 AM
|
We are planning to move, from using slapi to SLX oledbProvider, but following 3 api's are not available through this route. we cant find way to use these methods...
slapi_DBRecordCount() slapi_DBGetBlobAsParsedText() slapi_GetGroupQuery()
does anybody know the method to use that API's with SLX oledbprovider ??. |
|
|
| |
|
Re: Does anybody know the method to use following SLX API's with SLX oledbprovider ??.
Posted: 19 Oct 08 11:39 PM
|
That wouldn't be much fun, at least for the last two! The first one, of course, is just a recordset property, or else you can get record counts directly from the database server with a COUNT(*) query... but as for the BLOB text and the group queries, would you be willing to deploy a third-party DLL for that purpose? Is this something that's only going to be run by a limited number of people, or only on a server of some sort, perhaps as a nightly maintenance task? |
|
|
|
Re: Does anybody know the method to use following SLX API's with SLX oledbprovider ??.
Posted: 20 Oct 08 9:43 AM
|
To get the Blob Parsed as Text, all you need to do is use an ADO Stream object. After you read the Binary into it, you can switch its mode to Text and get it into a string.
For the Group query, you could use the GroupTranslator DLL (not sure if this is a supported method, it works for me, but I only use it as a Migration utility). |
|
|
|
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!
|
|
|
|
|
|
|
|