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!
|
|
Why the date is different between in table and using script?
Posted: 01 Sep 06 9:33 PM
|
fiogf49gjkf0d In table, the value of the date field is "9/1/2006 12:00:00.000 AM", but I can see the value for "objRS.Fields(0).vlaue" in my vbscript is: "8/31/2006 8:00:00.000 PM", why it get the different date ( with the Zone )?
How to make it is the same with the table? |
|
|
| |
| |
| |
|
Re: Why the date is different between in table and using script?
Posted: 01 Sep 06 11:57 PM
|
fiogf49gjkf0d If you are using vbscript within the SalesLogix client and you are using Application.GetNewConnection for your ADO connection then you are using the SLX OLEDB provider. If you are then using SQL Query Analyzer to look at the data in the table, you are NOT using the SLX OLEDB Provider. This is what I suspect you are doing. Please correct me if I am mistaken.
Also, here is the OLEDB Provider article page for this site:
http://www.slxdeveloper.com/page.aspx?id=15
Also, here is a link to a tool that others in the bp community seem to like. I have never used it nor do I take credit for finding it. I am just passing along the info 
http://www.albahari.com/queryexpress.html
Timmus
|
|
|
|