Maybe creating indices on your PROV.DIR.DB file for the MAMSI field is the way to go. Then selectindex to do your processing.
Mike R. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Davis Sent: Monday, March 15, 2004 4:40 PM To: U2 Users Discussion List Subject: RE: Strange results from I Descriptor Don't do a select (or any query statement) within an I-descriptor subroutine that gets called from query. That's what the message means. Even if it did work it would be a dog. If I need to do something like this in UniData I use the UniBasic index commands like SETINDEX READFWD, etc and create an index on the other file. Indices are different on Universe, but there are commands to access them in basic. ________________________________ From: [EMAIL PROTECTED] on behalf of Gordon Glorfield Sent: Mon 3/15/2004 3:56 PM To: U2 Users List ([EMAIL PROTECTED]) Subject: Strange results from I Descriptor UV 10.0.8 I am trying to create an I-Descriptor that calls a subroutine. The subroutine does a select on another file. When the select is executed I get this error: "Non-SQL re-entrant query calls are not allowed." I'm clueless as to what is wrong. Any hints would be greatly appreciated. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. ______________________________________________________________________ Our company accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. 11/29/2003 ACE Software, LLC -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
