Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transformation changes date value
Message
From
09/09/2010 10:46:30
 
 
To
09/09/2010 10:39:58
General information
Forum:
ASP.NET
Category:
Web Services
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01480677
Message ID:
01480678
Views:
37
I have adjusted to this for now. Basically, it checks to avoid replacing CHR(0) if we have a datetime.
                        ' If this is not a DateTime
                        If loColumn.DataType.ToString <> "System.DateTime" Then

                            ' We have to avoid doing this on a DateTime as when we have an empty value such as
                            ' 1899-12-30T00:00:00-05:00, it will be changed to 2010-09-09T00:00:00-04:00.

                            ' The loXslCompiledTransform.Transform() cannot support NULL.
                            ' So, we have to remove them from the value.
                            loRow.Item(lcColumn) = oApp.StrTran(loRow.Item(lcColumn), Chr(0), "")

                        End If
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform