Running Query that Counts Records and Returns Results in SalesLogix Windows Client

Question: In the SalesLogix Windows client I am trying to run a query that counts
records and returns the results.  I tried this but didn’t have much
luck:

Set rs = objSLXDB.GetNewRecordset
rs.Open “select count (*) from orcontact'”, objSLXDB.Connection

‘ How to get results of query?
rs.Close

How can I get my query to return results?

Answer: This is what you need to do –

Set rs = objSLXDB.GetNewRecordset
rs.Open “select count (*) from orcontact'”, objSLXDB.Connection

MsgBox “Count of orcontact table is: ” & rs.Fields(0).Value
rs.Close

 

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!