All,
I am having an issue with the retrieval of data from a date column in a
live-link to an Oracle table.
I have created a live link to a table with 46 fields through MapInfo. All
data can be interrogated through the info tool except for a dates in a date
field that are in 1966. The table contains data collected in 66, 99, 00 and
01. All dates are visible except those in 1966 which are linked as null
values. Likewise downloading the data, downloads null values instead of
the 66 date.
This is causing me an issue when I am committing geometry changes through a
mapbasic app as the commit command is trying to enter a null into the date
field, a field that has a not_null constraint on it.
UPDATE <TABLE> SET OBJ = CREATEPOINT(x,y) WHERE ROW_ID = xx
COMMIT TABLE <TABLE> INTERACTIVE
I have thought of a workaround whereby I would send SQL to the Oracle
database direct which only updates the SDO_GEOMETRY column instead of using
the above but this will have performance problems as I don't want to commit
to the database after every transaction...
I'd appreciate any help as to the cause of the issue (surely Y2K related),
or alternative workarounds.
Kind Regards
Colin Thornton.
Informed Solutions Ltd, The Old Bank, Old Market Place, Altrincham,
Cheshire, WA14 4PA UK
Tel: +44(0) 161 942 2000 Fax: +44(0)161 942 2015
This e-mail and any attachments are sent in confidence, subject to
applicable legal privilege and upon the basis that the recipient will
conduct applicable virus checks. If you receive this e-mail in error please
telephone us upon receipt on the above number. You are strictly prohibited
from using, copying or disseminating it or any information contained in it
save to the intended recipient. You are also advised that the opinions
contained within this e-mail are those of the author and may not be those of
Informed Solutions, its associates or Clients. Internet communications are
not secure and Informed Solutions Ltd is not responsible for their abuse by
third parties, nor for any alteration or corruption in transmission, nor for
any damage or loss caused by any virus or other defect.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
