home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #16 / NN_1992_16.iso / spool / comp / database / 5813 < prev    next >
Encoding:
Text File  |  1992-07-28  |  1.9 KB  |  54 lines
  1. Newsgroups: comp.databases
  2. Path: sparky!uunet!cs.utexas.edu!torn!cunews!nrcnet0!emr1!kasvand
  3. From: kasvand@ccrs.emr.ca (Tony Kasvand)
  4. Subject: ABF/4GL Help  
  5. Message-ID: <1992Jul28.185544.17880@emr1.emr.ca>
  6. Sender: news@emr1.emr.ca
  7. Nntp-Posting-Host: nova.ccrs.emr.ca
  8. Organization: Canada Centre for Remote Sensing, Ottawa
  9. References: <1992Jul22.180503.27010@homebase.vistachrome.com> <l6v00iINN8qf@jethro.Corp.Sun.COM> <4352@disuns2.epfl.ch>
  10. Date: Tue, 28 Jul 1992 18:55:44 GMT
  11. Lines: 41
  12.  
  13.  
  14.    Hi, 
  15.         I have a small problem with the ABF/4GL (Ingres 6.4) language.
  16.  
  17.   In the 'where' clause of a callframe statement, I would like to simulate
  18. the 'field' condition.
  19.  
  20.  Example - 
  21.  
  22.   look_for = 'Joe';     /*  varchar(10) */ 
  23.   whclause = 'fixer';   /*  varchar(15) */ 
  24.  callframe by_fixed_second(by_fixed_second.programs =
  25.                         select distinct key_b = unique_bug#,
  26.                                 type_p = product_type,
  27.                                 prior = priority,
  28.                                 cond = condition,
  29.                                 name_p  =  product_name,
  30.                                 usrnm = username,
  31.                                 fix = fixer,
  32.                                 d_of_bug = date_of_bug,
  33.                                 name_sys = system_name,
  34.                                 des =details1
  35.                                 from bug_reports_table
  36.                 /* ****** -->*/ where :whclause = :look_for
  37.                                 order by prior );
  38.  
  39.       I am assuming from this code, this is what it should look like:
  40.              where 'fixer' = 'Joe'
  41.  
  42. **->
  43.    What I really want is:  where fixer = 'Joe'
  44.  
  45.  ANY SUGGESTIONS TO AN AMATEUR ABF/4GL PROGRAMMER?
  46.  
  47.       Thanks in advance,
  48.  
  49. -- 
  50. Tonis Kasvand      | "Patience is a virtue, only to one's opponent...  
  51. Ottawa, Canada     |    and getting in the first shot. BOOT TO THE HEAD !" 
  52. kasvand@ccrs.emr.ca|          - The Frantics 
  53.                              
  54.