Login /
Register
 search
 syndication
 about
|
|
 |
Note: this subscription applies to the current blog only.
You will receive each new post via e-mail. Your e-mail
address will not be used for any other purpose.
July 2012 - Posts
-
I am working in SLX 7.5.1. I have created a SQL View using a linked server. I am trying to access the view in a datagrid but I am unable to see the table when I try to do a join to it with the Account table. Can anyone tell me what I am missing? Read more
|
-
I have a tab with several datagrids placed on a tab control. I have a filter which is essentially the same as the notes/history tab filter. The problem I'm having is whenever a drop down filter goes over the grid, the grid doesn't render properly again unless I refresh. It also happens when I invoke a form in front of it.
Have you seen this issue in the past?
Read more
|
-
I'm trying to make Contract Insertion on some Sales Process. The problem is that in the main menu it is called a function (call Insert Contract), and Sales Process doesn't support "Call Function".
How to call this action (Function, Argument - Insert: Contract) by the script?
Read more
|
-
Under SLX 7.2, The following code was used to refresh all of the currently open forms as part of an OK event on a popup form:
Dim i
For i = 0 to Application.Forms.Count-1
Application.Forms.Item(i).Refresh
Next
That worked fine in 7.2 (and still works 7.5), but some of my 7.5 users are getting script errors when it hits this bit of code. Is there a better way to accomplish this? Read more
|
-
I have a function that locks down the opportunity based on several conditions.
When a user uses split view and tries to sort the data grid they get an Exception error and this is one error I have never seen when using custom code. Usually you will get a line error telling you exactly where something is failing.
When I comment out the opp lock code the error does not occur anymore. I've checked and checked the code again and I'm sure this should work. This error only occurs when using split view on the opportunity.
Read more
|
-
I'd like to change the content of the email message body that gets created when a user hits the "Copy Opp Info to E-Mail" link in the Opportunity snapshot. See that the code calls a VM script:
'BLOCKED SCRIPT window.external.Form.Script.SendEmail '
but I don't know where to find what that script is doing.
Can anyone tell me where to look so that I can customize what gets placed in the body of the email message? Read more
|
-
Is there a plugin for the screen displayed by Function File:PrintReports (called by the Reports icon on the Marketing toolbar).
I want to restrict the choices avaiable in the "type of report" drop down list and cant seem to find a plugin for it. Read more
|
-
SLX LAN 7.5.1:
I'm getting a Type Mismatch error on this line:
.Fields("PRICE").Value = .Fields("BASEPRICE").Value - NullToZero(Value)
When debugging in Visual Studio 2008, Value = 450 and the type is Currency. .Fields("BASEPRICE") is part of a recordset from a dynamically created datagrid. The column was created as type 13 (Currency) and the current value is 2400. .Fields("PRICE").Value is also a column type 13. Setting a currency type column to 2400-450 shouldn't be a problem.
I also noticed in VS that the Type property of BASEPRICE is 131. The article at http://support.microsoft.com/kb/195180 seems to say that calculations of adNumber type produces type mismatch errors.
I'm going to try using cDbl(value) when doing the math, but is this a recent change from Microsoft? I think the original developer of this 3-rd party plug-in would have encountered this. Read more
|
-
I've made some changes to the "System:Close Opportunity" view and I want to add some form validation before closing the form. I've hidden the OK button and added a new "Save" button that triggers my form validation.
The form is opened from "System:Opportunity Detail" with this code:
Set objMainView = Application.MainViews.Add("System:Close Opportunity", 0, False) 'DNL
...
If objMainView.ShowModal = mrOK Then
I tried to close the customized form with both if these options:
Application.BasicFunctions.CloseCurrentView(FALSE) Read more
|
-
I am trying to put a Ticket Number on a Crystal report, and I am running into an issue. I was hoping I could figure it out by myself by going into Architect and looking at the Global Join Manager, but I can't seem to figure it out. Read more
|
-
I have a need for sending out emails from SalesLogix (7.52) with attachments to contacts in the database, but without any user intervention. The quemessage and mergefromplugin don't seem to have a "silent" mode. Does anyone have a snippet of code or a suggestion about how to do this without user intervention?
Read more
|
-
I have a number of older plugins that were created with a blank company name. In order to delete them, I need to first mark them read/write, but when I uncheck Read Only in the Properties box and click OK, it tells me that I have an invalid company name and it won't save the record.
Any idea how I can get past this and delete these ancient plugins?
Read more
|
-
Question:
SQL Server Native Connection, ADO Command, and Parameters
Does anyone have an example of using ADO CommandText with input parameters and a native SQL Server connection?
? parameters and the SLX OLE DB Provider work fine.....except it has the tremendous additional query overhead of the SECCODE joins for Non ADMIN users.....SLX OLE DB Provider performance for a scan of 100,000+ records is NOT acceptable.
'Named' Parameters like ? or @P1 don't work with the SQL Server 2005 connection, yet.....
any hints?
Maybe a stored procedure command call instead?
SELECT A1.OPPORTUNITYID FROM OPPORTUNITY A1 WHERE OPPORTUNITYID LIKE ?
or the equivalent would be perfect. Read more
|
-
We have a list of activities. The list is imported to an unassociated table (import history). We are capturing ActivityID and a date/timestamp. Can we complete the activities in the list via a script? (bypass the complete activity form) using the timestamp from the table for complete date (rather than "As Scheduled or Now) SLX 7.2
Read more
|
-
I am trying to edit a pre-existing group created in SalesLogix client. When I view the SQL query, I see that there are conditions applied to this group. However, I do not see the 'Conditions' tab in Query Builder. How was the previous user able to set the conditions?
Also, can groups be not edited through SLX Architect?
Read more
|
-
We're on 7.5.4 LAN. We have about 13 remote users currently. Everything seemed to be humming along just fine until I noticed that about 5 days ago, the TEF's, although are being created just fine, are not moving from Logs --> OUTFILES folder on Sync server to the FTP OUTFILES directory...... except for one user. Her files are still moving as they should. Is there an issue I should know about??
Read more
|
-
In 7.0, when you minimized Insert New Ticket, you could navigate around SalesLogix. In 7.5.2, when you minimize Insert New Ticket and try to do something else, focus just goes back to the minimized Insert New Ticket form.
This happens on the evaluation database as well as my customer's database. What am I missing? Did something change? Same behavior for Insert Defect, Contract, Return.
Read more
|
-
Anyone know of a way to dynamically populate a multi-select pick list with values that are pulled from a database table?
Read more
|
-
I want 3 users to be able to edit picklists without having any other administrative access. I gave them access to the tools-->manage-->picklists menu item but any changes they make can only be seen by themselves and not other users.
Ive come across something like this before and did a sql update to make the modifyuser of the picklist item ADMIN which makes it visible to all users but its not feasible to do this every single time these 3 users edit a picklist.
Have i missed something in the permission process?
Read more
|
|  |
|