Kishor Sorry, should not be BY RECORD_ID, should be BY @ID
The key is RECORD_ID:DATE:TIME, RECORD_ID is in Field <1> in the record and refers the the @ID of another file There can be many RECORDS in the AUDIT.HIST File with the same RECORD_ID, but there DATE and/or TIME will differ. Regards Bjvrn Behr SUMMIT CORE Developer Tel No: +27 12 673 3251 Fax No: +27 12 673 4681 E-Mail: be...@frstia.co.za -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of kis...@parmars.com Sent: 29 April 2009 09:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I-Descriptor Help Hi Bjorn, Why are you using the BY RECORD_ID clause when you are selecting on RECORD_ID = '1537044' ? Should this be @ID for the first record on the AUDIT_HIST file? Regards, Kishor Quoting Bjorn Behr <be...@frstia.co.za>: > Morning All > > I wonder if somebody can please assist me here. > > What I need to do is SELECT the 1st Record saved from a file > (AUDIT.HIST) for a specific RECORD_ID. > The RECORD_ID Field is an indexed field on AUDIT_HIST. > > I am trying to do this via a I-Descriptor calling a BP and it is > returning an error > > Error: > Non-SQL re-entrant query calls are not allowed. > > Select Statement within BP: > "SELECT AUDIT.HIST WITH RECORD_ID = '1537044' BY RECORD_ID" > > Any idea how I go about doing this? > > System Info > Universe 10.1.24 (PICK) > System Builder 5.3 > > Regards > Bjvrn Behr > SUMMIT CORE Developer > Tel No: +27 12 673 3251 > Fax No: +27 12 673 4681 > E-Mail: be...@frstia.co.za<mailto:be...@frstia.co.za> > > > ________________________________ > The information in or attached to this e-mail message is confidential > and may be subject to legal privilege and client confidentiality. If > you are not the intended recipient of this e-mail or the authorised > representative of the recipient then please notify the sender of this > e-mail immediately by return e-mail and delete this message from your > system. You may not print, store, forward or copy this message or any > part thereof or disclose or cause information in this message to be disclosed > to any other person. > > FRSTIA cannot be held liable for any harm or loss resulting from > malicious software code or viruses in this message or attachments, > including data corruption resulting there from. > > Employees or representatives of FRSTIA are not permitted to send > unsolicited messages ("spam") and FRSTIA cannot be held liable for > their sending of such mail. If you regard this message as spam, please > inform us immediately by sending an email to i...@frstia.co.za. > > If this message contains offensive, derogatory or defamatory > statements or materials, it means the message has been sent outside > the sender's scope of employment with FRSTIA and only the sender can > be held liable in his/her personal capacity. > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information in or attached to this e-mail message is confidential and may be subject to legal privilege and client confidentiality. If you are not the intended recipient of this e-mail or the authorised representative of the recipient then please notify the sender of this e-mail immediately by return e-mail and delete this message from your system. You may not print, store, forward or copy this message or any part thereof or disclose or cause information in this message to be disclosed to any other person. FRSTIA cannot be held liable for any harm or loss resulting from malicious software code or viruses in this message or attachments, including data corruption resulting there from. Employees or representatives of FRSTIA are not permitted to send unsolicited messages ("spam") and FRSTIA cannot be held liable for their sending of such mail. If you regard this message as spam, please inform us immediately by sending an email to i...@frstia.co.za. If this message contains offensive, derogatory or defamatory statements or materials, it means the message has been sent outside the sender's scope of employment with FRSTIA and only the sender can be held liable in his/her personal capacity. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/