Jorge, Dylan,
I just ran into this yesterday. I have oracle DATE and a CLOB fields.
Can't do anything about the CLOB except to find out if the data really
exceeds 4000 characters, the limit of VARCHAR.
You may be able to have your DBA create some code that converts the value
in his DATE column to something that Remedy likes. Off the top of my head,
maybe a character or number field where the data has been converted to
Epoch time. You will need to experiment with the Remedy side of things in
order to tell your DBA exactly what to provide...or someone on this list
can tell us!
Drew
Tulsa, OK
On Fri, 21 Dec 2007, Wheeler, Dylan wrote:
Is the field one of these types?
Only the following data types are supported in view forms:
* SQL Server-char, varchar, tinyint, smallint, int, text, real, float,
decimal
You can't use a datetime field from sql. I don't have a sql box I can
access but if I remember right it keeps a unix timestamp in a varchar
field and translates that into a human friendly date/time.
-------------
Dylan Wheeler
Production Control Analyst Principal
IT Operations
Downey Savings & Loan Association, F.A.
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jorge Polo
Sent: Friday, December 21, 2007 8:22 AM
To: [email protected]
Subject: When I create a View form does not load datetime fields
**
Hello everyone,
When I provide the database table name
(DATABASENAME.OWNER.TABLENAME) and click on "Load" to create a view
form, the datetime fields are missing from the list of loaded fields.
Can anyone explain how to resolve this problem? Thank you.
Our Environment is Windows Server 2003 - Remedy AR System Server
6.3 - Microsoft SQL-Server 2000 - Helpdesk 5.6 Application
Portions of this message may be confidential under an exemption
to Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message.
__20060125_______________________This posting was submitted with HTML in
it___
This message and any attachments are for the intended recipient(s) only and may
contain privileged, confidential and/or proprietary information about Downey
Savings or its customers, which Downey Savings does not intend to disclose to
the public. If you received this message by mistake, please notify the sender
by reply e-mail and delete the message and attachments.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
