Dennis, Create a subr/function routine to open the REPAIRS file, use BSCAN to find the required records (using the passed STOCK code) and then DCOUNT the BSCAN result. You can then return this value.
Create an ITYPE dictionary field (in STOCK file) which calls this routine, passing the required STOCK key/code. It would be a good idea to cache the file open using one of the methods which was discussed some months ago in this mail list. Cheers, David Murray -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Friday, March 14, 2008 6:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] Indexes My dumb question for the day (just cant remember how to... and the manual's example is too simplistic...) How do I programmatically get an index value out, eg I have a STOCK file, and a REPAIRS file. Whoever designed this needs their head read, but the repairs file only has the stock code as a reference in the record. I have indexed the repair file on stock code, and need to create a report on the stock file of how many items are under repair. 1. UniverseBASIC code? 2. is this possible from an Itype? ------- 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/
