Hello,

Where can I get a list of all SLX procedures avaiable through the oledb providor.

Specifically I need to get to the group sql statement stored in a blob field. 

Alternatly, can I call a proceedures to give me all of the records the group call for ?

Thanks in advance.

Jeff

FYI we are using SLX web version 7.5.4

I need to be able to acces the contacts called for by the groups from an out side app.

Thanks

You can get the List from the SalesLogix LAN Developers Reference, but here are a few:

  slx_ClearGlobalID, slx_CycleLogFile, slx_DBIDs, slx_GetServerList....

The SLX Store Procedures are not there to retreive any data. For that you would just execute SQL queries (e.g. SELECT * FROM CONTACT). The Query will return all records visible to the User you are logged in with (on the Connection String).

That said, Groups are a different animal all together.

The Group Definition is Stored within the Plugin Table (and could have many versions, so you need to get the Latest version). The definition is stored within a BLOB on a Binary format. There are some undocumented functions exposed on some of the DLLs included with SalesLogix that may allow you to get the definition as XML, from there you could get the SQL Statement. And then you could get the data for that Group.

On the LAN side you can:

Application.BasicFunctions.GetGroupSQL

maybe there's an equivalent on the web side?