Re: help, help, help

[Scott Ames]

** Wow you are quick on the draw. I was composing a similar message when yours came in. lol.

"Nall, Roger" <[EMAIL PROTECTED]> wrote:

**

Sara,

 

To enforce unique values in a field I would suggest a unique index. As to a ‘Request ID’ type field you may need some sort of a stored procedure for that.

 

HTH,

 

Roger A. Nall

OSSNMS Sr. Remedy Administrator/Developer

T-Mobile USA

Desk: 973-644-3963

Cell: 973-652-6723

FAX: 973-267-6628

sf49fanv     AIM IM

RogerNall   Yahoo IM

 

---

From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sara abate
Sent: Tuesday, August 22, 2006 10:46 AM
To: arslist@ARSLIST.ORG
Subject: help, help, help

 

** I am a new remedy developer and I need help on two of the following things,
  
  1.  I want a field to have unique value.  How can I restrict the
field from having duplicate values?  In other words, Is there any way I can block if the current value entered is already in the database?
   
  2.  I want to create an auto generated field.  Anytime a ticket is
submitted, the field should be populated automaticlly in increments.  In
other word, I want a 'Request ID' kind of field on the form.
  
  Anybody can help me with this please email me at [EMAIL PROTECTED]. 
I will appreciate it.
  Thanks!
  
  Sara

 

---

Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail. __20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___