I need to clarify something, sorry: I can type in which key field to use manually, and it will accept it, and my table is able to import SOME fields from the view form, but not others.
Here are the fields in my view: Name Null? Type ----------------------------------------- -------- ---------------------------- CUSTOMER_NAME VARCHAR2(50) CUSTOMER_NUMBER NOT NULL VARCHAR2(30) CONTACT_NAME VARCHAR2(91) EMAIL VARCHAR2(2000) STATUS VARCHAR2(1) ROLE NOT NULL VARCHAR2(80) IBX NOT NULL VARCHAR2(20) I am using CUSTOMER_NUMBER as the key field, as it is unique. From my table, I am not able to select CONTACT_NAME or EMAIL; those do not even show up in my "Fields on Form" list in my table property tab. The only thing those two have in common is the VARCHAR size is > 80. Is there a size limit on columns a view form can provide? -Paul -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Friday, September 07, 2007 2:28 PM To: arslist@ARSLIST.ORG Subject: Re: AR 6.3 How to Populate a Table with a SQL Query? Unfortunately, neither of these solutions creates a column that is a suitable key field. From the documentation: The database table must have a column (field) that enforces non-null and unique values. This column will act as the Request ID. If the administrator chooses a column that is non-unique or allows nulls, data corruption will probably occur. The Request ID field must be an integer field or a character field that is no less than 6 and no greater than 15 characters. Otherwise, the Key field list will be empty, and you will not be able to create the view form. My DBA and I are still trying to create a column that meets this requirement. -Paul -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, September 07, 2007 12:14 PM To: arslist@ARSLIST.ORG Subject: Re: AR 6.3 How to Populate a Table with a SQL Query? Add the Column ROWNUM to the view Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Friday, September 07, 2007 2:11 PM To: arslist@ARSLIST.ORG Subject: Re: AR 6.3 How to Populate a Table with a SQL Query? If it truly a view then you should be able to add a column to the view that will act as Request ID. Make sure that you increment the column by 1 for each record. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Friday, September 07, 2007 3:08 PM To: arslist@ARSLIST.ORG Subject: Re: AR 6.3 How to Populate a Table with a SQL Query? Ah yes, view forms. (You can tell I'm new at this.) Unfortunately, while creating the view, none of my database fields qualify as an index (tripping up on the 6-15 char window). I'm trying to work around this in oracle (the table is actually a view of an external DB so I have no control of that varchar limit), any other methods of implementing are appreciated. Thanks! -Paul -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Friday, September 07, 2007 11:43 AM To: arslist@ARSLIST.ORG Subject: Re: AR 6.3 How to Populate a Table with a SQL Query? You cannot populate a table via direct SQL (unfortunately). You can, however, create a remedy view and point it to a database SQL view of what you need, then point the remedy table to the view you created. Now, to pass a dynamic variable in the table qualification field, check out EXTERNAL() function in the AR Admin basic book. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul Blasquez Sent: Friday, September 07, 2007 12:16 PM To: arslist@ARSLIST.ORG Subject: AR 6.3 How to Populate a Table with a SQL Query? Hello, I have a 'Customer Data' page on my main form in which there is one read/write character field named 'Company Name+', and several read-only character fields. I have set up a menu that reads from an Oracle View SQL query our database of customers, attached it to the 'Customer Data' field. and set up a couple active links so that when a search term is entered into Customer Data, or a Customer is chosen from the menu, the read-only fields are filled in with the appropriate SQL result columns. Now, my issue is that I would also like to have a table on the page that I can populate with the customer's contact list. In order to do this, I must make another SQL query, using the 'customer_id' from the original 'company_name' query to key which rows to pull out. Any ideas on workflow that could pass the customer_id variable to a new SQL query, and then populate a table with several rows of data? I can't seem to work out a solution using menus/forms/active links. Thank you! _______________________ Paul Blasquez [EMAIL PROTECTED] ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
