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!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Show label when an account has an association

SLX_Novice
Posts: 246

Show label when an account has an association Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 07 9:33 AM

Hi all.

I have a similar question to the one I posted about multiple addresses. I would like to display a label "This account has associations" when an account has an association.

I'm having trouble coming up with a sql string, anyone have any ideas on how I can display a label if an account has associations?

Thank you in advance.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Show label when an account has an association Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 07 1:21 PM

This will tell you how many associations the current account has:

select count(associationid) from association where fromid = '" & CurrentID & "'"

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Show label when an account has an association Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Mar 07 4:01 PM

Thanks Ryan!

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Show label when an account has an association Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Mar 07 11:47 AM

One last question Ryan...I also want the label to appear if there is a "TO" association so either "FROM" or "TO" association how can I add that to the code you provided above?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Show label when an account has an association Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Mar 07 11:51 AM

Quote:

Originally posted by Fabian Garcia

One last question Ryan...I also want the label to appear if there is a "TO" association so either "FROM" or "TO" association how can I add that to the code you provided above?

select count(associationid) from association where fromid = '" & CurrentID & "' or toid = '" & CurrentID & "'"

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Show label when an account has an association Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Mar 07 12:13 PM

Works great thanks!

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/18/2025 4:34:49 AM