[Openroad-users] Problems Importing XML Dates

[Bloomfield, Martin (PSD)]

OpenROAD Experts,

With much assistance form Kim Ginnerup, I have now managed to create a
SCP procedure to import an XML file into OpenROAD.  However, I am having
problems importing date elements. In the XML file these are defined in
the format "yyyy-mm-dd" (the only format allowed by XML).  On our server
& clients we use the date format of multinational4 and display dates in
the format dd/mm/yyyy.

When I try to import the XML date, I get the following error in the
trace window:

E_WT0029 Error at line 76 of ConvertToDate.

E_EO0022 A dynamic expression ('date ( _XMLvar )') could not be
evaluated.
    A getvalue, setvalue, or getfield method failed because the
Windows/4GL
    interpreter detected a fatal error when it tried to evaluate the
dynamic
    expression.  A subsequent message will specify the error.

E_WT0011 4GL expression evaluation error.
    An error occurred in the evaluation of a 4GL expression.  The
results
    will be undefined.

Fri Nov 17 16:15:38 2006 E_US10D0_4304	2006 is not a valid month for a
date column.

ERROR IN GSCP Results: XML IN conversion failed.  Error converting
2006-11-15 
into a date.

I have tried changing the date format in the XML file, but this causes
it to be invalid.  Has anyone else managed to import XML (ISO format)
dates into OpenROAD using the XMLIN parameter?  I assume that the
ConvertToDate procedure(?) is a built in procedure called as part of
OpenROAD's conversion mechanism.

We are running OpenROAD 4.1 SP2 on our clients.  I have tried to install
patch 10464, but this breaks our vnode definitions, did not fix the
problem and resulted in a stream of Memory allocation errors in the
trace window.

Thanks in advance,

Martin Bloomfield.
____________________________________________
Application Developer & Database Administrator
IT Branch,
Pesticides Safety Directorate
YORK

Email: martin.bloomfield at psd.defra.gsi.gov.uk
Website: www.pesticides.gov.uk

Department for Environment, Food and Rural Affairs (Defra)

This email and any attachments is intended for the named recipient only.
If you have received it in error you have no authority to use, disclose,
store or copy any of its contents and you should destroy it and inform
the sender.
Whilst this email and associated attachments will have been checked
for known viruses whilst within Defra systems we can accept no
responsibility once it has left our systems.
Communications on Defra's computer systems may be monitored and/or
recorded to secure the effective operation of the system and for other
lawful purposes.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3277 bytes
Desc: not available
Url : http://peerlessit.com/pipermail/openroad-users/attachments/20061117/7635187b/attachment.bin