5/15/2024 8:33:08 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!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Problems with saving DateTime
Posted: 20 Jul 08 11:14 PM
|
So just in case someone else runs into this problem...
We are using .NET and the OLEDB Provider..
We were getting this error in eventlog that kept saying "Does not support DBType 7"
We finally figured out that the problem is that SLX wants you to provide the data as a DBTimeStamp (which actually makes handling dates with SLX really easy)
If you use DBDateTime SLX converts that to DB_NULL and than you also have to do a little bit of datetime manipulation to get the dates saving into SLX properly as far as the UTC stuff is concerned...
So yea
Anybody out there using the OLEDB Provider
make sure that when you work with Dates and Times to always mark the type as DBTimeStamp
Otherwise lots of annoying stuff happens..
Unless you already knew that and it's in the documentation somewhere.. |
|
|
|
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!
|
|
|
|
|
|
|
|