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"
