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: Adding another Filter Option to the Notes/History tab for Accounts (SLX v6.2.6)

SLX_Novice
Posts: 246

Adding another Filter Option to the Notes/History tab for Accounts (SLX v6.2.6) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Oct 07 2:24 PM

Hi all.

I would like to add another Filter Option (Category), it is a TPickList, to the Filter Options in the Notes/History tab for Accounts. Any idea how?

Thank you in advance.

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Adding another Filter Option to the Notes/History tab for Accounts (SLX v6.2.6) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Oct 07 3:34 PM

I added the following to the Notes History Comman (System) script:

If chkCategory.Text = "T" Then
If pklCategory.Text = "" Then
pklCategory.Popup
End If

If pklCategory.Text <> "" Then
strGridSQL = strGridSQL & " AND (CATEGORY = '" & pklCategory.TextOrder & ") " 'DNL
Else
chkCategory.Text = "F"
End If
End If

Is there anything wrong with it?

[Reply][Quote]

SLX_Novice
Posts: 246

Re: Adding another Filter Option to the Notes/History tab for Accounts (SLX v6.2.6) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Oct 07 4:03 PM

I get the following error when I try to use the filter on the SalesLogix Client:

An error occurred executing active form script (Account: Notes-History). Error in include script (System: NOTES HISTORY COMMON). Syntax error converting the varchar value 'Price Change' to a column of data type int at line 521, char 5.

line 521, char5 is:

520- grdHistory.SQL.Text = strGridSQL
521- grdHistory.Active = True

[Reply][Quote]

Mark Dykun
Posts: 297

Re: Adding another Filter Option to the Notes/History tab for Accounts (SLX v6.2.6) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 16 Oct 07 7:07 AM

Look at your query and check how the price change column is configured and what it is bound to. It just looks like a cast error to me.

Mark

[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/20/2025 2:52:28 PM