|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: Mercator / Oracle ODBC
With using version 1.4.x or earlier, you will have to manually format the
date to this format CCYY-MM-DD<sp>HH:MM:SS with <sp> being a space
character (hex 20). Since the default date string on a text field is
YYMMDD, you will have to use the LEFT(), RIGHT() and MID() functions to do
this
ie
="20"+LEFT(DATETOTEXT(CURRENTDATE()),4)+"-"+MID(DATETOTEXT(CURRENTDATE
()),2)+"-"+RIGHT(DATETOTEXT(CURRENTDATE()),2) - then do the same for the
time concantenated on this string
Using version 5 or later, when you create your type tree, it should
automatically format the item properties to a date time with the format as
indicated as above, and then all you will need to use the CURRENTDATETIME()
function to return the proper date.
Hope this helps
"matthias_edi"
<mmatthias@synes To:
isintl.com> cc:
Subject: [EDI-L] Mercator /
Oracle ODBC
07/09/02 08:09
AM
I need help with mercator and writing directly to a database.
I am trying to write a map in Mercator that will update Oracle
tables. Everything works until I get to the dates. I have created
the type tree using the Database Editior and it sets the date fields
as TEST (19). When I try to write DATETOTEXT(currentdate()) I get a
database error. Does anyone have any suggestions?
To unsubscribe from this group, send an email to:
Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
<OFF-TOPIC>
Access the list online at: http://groups.yahoo.com/group/EDI-L
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
---------------------------------------------------------------------------
This message (including any attachments) is confidential and may be
privileged. If you have received it by mistake please notify the sender by
return e-mail and delete this message from your system. Any unauthorised
use or dissemination of this message in whole or in part is strictly
prohibited. Please note that e-mails are susceptible to change.
ABN AMRO Bank N.V. (including its group companies) shall not be liable for
the improper or incomplete transmission of the information contained in
this communication nor for any delay in its receipt or damage to your
system. ABN AMRO Bank N.V. (or its group companies) does not guarantee that
the integrity of this communication has been maintained nor that this
communication is free of viruses, interceptions or interference.
---------------------------------------------------------------------------
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
