Home
|
Forums
|
Contact
|
Search
|
Syndication
[login]
[create account]
Sunday, August 24, 2025
slxdeveloper.com
Home
Search
Contact us
About slxdeveloper
Syndication
Community
Forums
(NEW!)
Newsletter Archive
Members
Your Profile
Submit Article
General
Administration
(6)
OLE DB Provider
Miscellaneous
(2)
Architect
VBScript
(9)
ActiveX Controls
(6)
How To's
(14)
.NET Extensions
(3)
External
OLE DB Provider
(12)
SLAPI (SlgxApi.dll)
SalesLogix COM
(1)
Web
ASP/ASP.NET
(2)
Web Services
Web Client
Downloads
Samples
(17)
Documentation
(7)
Utilities
(18)
Resources
SalesLogix
(3)
Programming
(1)
8/24/2025 6:38:02 AM
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:
Dynamic
Flat
Tree
Search:
Author
Thread: OnChange for DateTimeEdit control
Dave McGill
Posts: 47
OnChange for DateTimeEdit control
Posted: 26 Jun 08 2:46 PM
I have a DateTimeEdit control on a Contact Tab. When the date is changed in this field I need to copy the value to another field in the database. The code is working fine in the OnChange event when the calendar pop-up is used to set the date, but if the user types the value, my code fails because the OnChange event is firing with each character that is entered.
Does anybody have any tricks for getting around this problem?
This is the error:
---------------------------
Script Error
---------------------------
An error occurred executing active form script (Contact:LCMS AllMissions BioData).
Error calling method dtBirthdateChange
Conversion failed when converting datetime from character string.
at line 14, char 5
---------------------------
OK
---------------------------
This is the code:
Sub dtBirthdateChange(Sender)
Dim strSQL
Dim objSLXDB
Set objSLXDB = Application.GetNewConnection
strSQL = "Update CONTACT set BIRTHDAY = '" & dtBirthdate.Text & "' where CONTACTID = '" & txtContactID.Text & "'"
objSLXDB.Execute(strSQL)
Set objSLXDB = Nothing
End Sub
Thanks for your help,
Dave
[
Reply
][
Quote
]
Dave McGill
Posts: 47
Re: OnChange for DateTimeEdit control
Posted: 26 Jun 08 4:03 PM
I've also tried:
OnExitControl - it doesn't fire when the date is typed in and the user hits ENTER, then switches to another contact.
OnPopupReturn - it doesn't fire when the date is typed in, only when the calendar popup is used.
[
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): 8/24/2025 7:10:02 AM