Thank you. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, December 21, 2007 12:05 PM To: [email protected] Subject: Re: When I create a View form does not load datetime fields
Create a view on from the table that converts the date/time field to an int data type in the format that Remedy expects. Then in your view form, create a date/time field and point it to the int column. See the db reference guide on how to convert the data type. Axton Grams On Dec 21, 2007 11:55 AM, Drew Shuller <[EMAIL PROTECTED]> wrote: > 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" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
