Mike, Doing a querying, within a query in RetrieVe, isn't recommended. That is, if you I-type is doing a query, then that probably part of the problem. But it works in the testbed, then perhaps the differences are with that environment?
However, is your testbed account set to INFORMATION flavour too? As the PERFORM and EXECUTE commands can work different depending on the account flavour, syntax and/or $OPTIONs used. Regards, David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: Thursday, 19 May 2005 1:10 PM To: [email protected] Subject: [U2] UV "PERFORM 'SELECT <filename> ...' " in I-Type {Unclassified} Folks, We have had a puzzling situation where a particular subprogram works differently when run from a test-harness from TCL, to when it is run as an I-Type subroutine. The sub-routine concerned is about three layers deep in the execution sequence:- Test-Harness does CALL A(<parameters>), A does CALL PROBLEM(<parameters>) I-Type says SUBR("X",<parameters>), and X does CALL A(<parameters>), A does CALL PROBLEM(<parameters>) When you LIST <file name> <I-Type name> the I-Type returns 'wrong' answers The programmer concerned eventually worked out that the problem was that, from the I-Type, a "PERFORM 'SELECT <filename> <with-condition>' " ALWAYS returned no records, whereas the same select works correctly from the test harness. No, the were no select lists active at the time! The solution was to change the "PERFORM 'SELECT <filename> <with-condition>' " to a Basic "SELECT <filename>" and weed out the unwanted records in an internal loop. It may well be that it has always been this way, the I-Type is new. UV 10.0, INformation flavour, Windows 2K3 Ideas, anyone? Thanks Mike ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
