Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, November 30, 2024 
 
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 - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to Controls | New ThreadView:  Search:  
 Author  Thread: Datagrid Editing Event
Rekha
Posts: 72
 
Datagrid Editing EventYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Dec 07 9:56 AM
Hi, In Salesprocess tab, there is an event written by Saleslogix as below

Function grdSalesProcessEditing(Sender, PrimaryKeyValue, FieldName, Value)

This message box pops twice when you click on same cell in grid again

---------------------------
Warning
---------------------------
The 'New Sales Step1' step has not been completed. You must complete the step before proceeding.
---------------------------
OK
---------------------------

How to fix this issue? Any help much appreciated!!

[Reply][Quote]
Rekha
Posts: 72
 
Re: Datagrid Editing EventYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 06 Dec 07 10:00 AM
It happens only on "Completed on" cell not on other cells
[Reply][Quote]
Jeff Weight
Posts: 219
 
Re: Datagrid Editing EventYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 Dec 07 11:33 AM
There are about four or five places that actually pop that message box in the code, so it could be any number of things.

But before I mention something to do - what are you looking to have fixed? Is it that the message pops twice? If that's it, then you want to make sure it is popping only that message twice - modify the message a little and see if the modification is visible both times that the message pops up.
[Reply][Quote]
Rekha
Posts: 72
 
Re: Datagrid Editing EventYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 Dec 07 4:50 PM
Hi Jeff,

Thanks for replying. I have tried several things to supress the message box firing twice in the edit event.
Function grdSalesProcessEditing(Sender, PrimaryKeyValue, FieldName, Value)

If I keep a flag, then the message box will not fire the second time if the user checks the same cell again.
Here's the sample code:

Function grdSalesProcessEditing(Sender, PrimaryKeyValue, FieldName, Value)
Dim strReqStepName, strReqStepID

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' New code starts
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
If cboSalesProcess.Text = "Group Booking" Then
Select Case grdSalesProcess.GetCurrentField("Description")
Case "Waiting to be booked"
Msgbox "message here"
grdSalesProcessEditing = False
Exit Function
End Select
End If

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' New code ends
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Select Case FieldName
Case "STARTDATE" 'DNL
gStrCrntDate = Value
Case "COMPLETEDDATE" 'DNL

gStrCrntDate = Value
strReqStepID = GetRequiredStepID(grdSalesProcess.GetCurrentField)
If strReqStepID <> "" Then
strReqStepName = GetStepName(strReqStepID)
MsgBox Application.Translator.Localize("The '") & strReqStepName & Application.Translator.Localize("' step has not been completed. You must complete the step before proceeding."),vbOKOnly+vbExclamation, Application.Translator.Localize("Warning")
grdSalesProcessEditing = False
End If
End Select
End Function


***************************************************
' If you click the same grid cell twice, it shows 2 message box twice.
***************************************************

Please let me know if you can find any solution for this... thanks in advance... just want to know if this is salelogix bug
[Reply][Quote]
Jeff Weight
Posts: 219
 
Re: Datagrid Editing EventYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 08 Dec 07 4:26 PM
I was about to recommend the flag, but I realized that it would surpress any other edits after the first one... Also, the even doesn't reset any values, from what it looks like, so you can't rely on that either. The one constant that I can think of is that the event runs twice every time - never just once, and never three times or more - which means you can keep a flag but operate it like a switch. Declare a global variable called something like "blEditMessagePopped" and set it to False.

Then, in between the "If strReqStepID <> "" Then" and "End If" use this code:

If Not blEditMessagePopped Then
strReqStepName = GetStepName(strReqStepID)
MsgBox Application.Translator.Localize("The '") & strReqStepName & Application.Translator.Localize("' step has not been completed. You must complete the step before proceeding."),_
vbOKOnly+vbExclamation, Application.Translator.Localize("Warning")
blMessagePopped = True
Else
blMessagePopped = False
End If
grdSalesProcessEditing = False


On the first time around, it'll see that the message hasn't been popped (because the flag is set to False), and it'll set the flag to True (after all, the message has been popped!). On the second time through, it'll see that the message has been popped, and instead of displaying the message, it'll set the flag back to False (on the second time through, the flag hasn't been popped). Then, the next time the user tries to do that illegal procedure, it'll see that the flag is set to False (no message popped), and it'll pop the message again. That should hopefully accomplish what you are looking for.
[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/30/2024 10:35:30 AM