Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample

Thanks, Troy. I was going to write that after I got to 11.1. (The upgrade was scheduled for Q3, but I hear rumours it got bumped because salesmen just sold something we can't do - yet. It pays the bills.) Troy, I want to borrow your code, but I want to include proper attribution in the

Re: [U2] Select from one file with save-list from another file

I'm with Ian. Maybe Ian and I don't understand the question. The other answers seem so complicated. Brandon, Replace Ian's example Y.PACKET.ID with whatever is thereal name in DICT X.INFO pointing to what you describa ase Y.INFO's key exists as a foreign key somewhere in X.INFO. Give

Re: [U2] Select from one file with save-list from another file

P.S. If there is a many::1 relationship between X.FILE Y.FILE, i.e., if more than 1 X.FILE record can have the same Y.INFO foreign key in it, do this: SELECT X.FILE WITH STATUS = cc SAVING UNIQUE Y.PACKET.ID LIST Y.FILE On 8/28/2013 9:56 AM, Charles Stevenson wrote: I'm with Ian.

Re: [U2] Select from one file with save-list from another file

Not sure where to toss this into this thread so I'll start at the beginning. I wanted to see the solutions that would be offered. I blogged on exactly this topic back in 2008. The solution I published for D3 uses @environment variables to allow us to do inner queries with a tiny bit of simple and

Re: [U2] Select from one file with save-list from another file

Hi, Long ago, I wrote an OUTERJOIN() function that could be called from an I-type using the SUBR(). This became a built-in function in QM but I think that the source code I have tracked down and shown below for the UniVerse version is about right. subroutine ojoin(result, file.name,

Re: [U2] Select from one file with save-list from another file

Hi again, Spotted a bug - I knew this would turn out to be the wrong source code!! When opening a new file, the filename should be copied to fname. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original

Re: [U2] Select from one file with save-list from another file

This line caught my eye: readlist var from 10 else then result = lower(var) else then ? I get it, but ... yuck. :) T From: Martin Phillips Spotted a bug - I knew this would turn out to be the wrong source code!!... ___ U2-Users mailing list

Re: [U2] Select from one file with save-list from another file

Hi Tony, Not one of my greater postings. I tidied it up a bit but seem to left a stray ELSE in place. 3/10 could try harder!! Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 28 August

Re: [U2] Select from one file with save-list from another file

Thanks everyone, I've got some usable info to work with. Sorry if my original post was a bit vague, let me illustrate to clarify: X.INFO @PACKET.ID.NAME..DOB...STATUS 52781456.52781456..DOE, JOHN.06-17-1985CCC Y.INFO

Re: [U2] Select from one file with save-list from another file

Do you have the ability to create new DICT entries in both X.INFO and Y.INFO ? -Original Message- From: Hilk, Brandon brandon.h...@iqor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 28, 2013 8:09 am Subject: Re: [U2] Select from one file with save-list from

Re: [U2] Select from one file with save-list from another file

Create new T)ranslate ATB's in Y.INFO to lookup the data in X.INFO, and just do the query directly from Y.INFO? One thing that's common in this situation is to have an xref file where the key is PACKET.ID and attribute 1 is a multivalued list of keys for Y.INFO. If this is a packaged app, you

Re: [U2] Select from one file with save-list from another file

Not myself, no. I could get with the programming staff and ask them to create fields in X.INFO that have the Y.INFO values that I need, but seems like a cop-out :) They are a grumpy bunch and if I have the ability to bypass them by writing a convoluted series of select statements then that would

Re: [U2] Select from one file with save-list from another file

What message do you get, when you try to create new Dict entries? -Original Message- From: Hilk, Brandon brandon.h...@iqor.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 28, 2013 9:06 am Subject: Re: [U2] Select from one file with save-list from another file

Re: [U2] Select from one file with save-list from another file

hi, like the same post from a few month, use direct access to btree indexfile (type 25) you can do it like this : 1) add a index on Y.INFO:PACKET.ID (create.index + build.index) 2) set a VOC entry to the btree file I_Y.INFO/INDEX.000 (000 can be different) ED VOC YINFO.PACKETID 001 F 002

[U2] Fwd: Re: Select from one file with save-list from another file

Tony: I use a simple program, inspired by a U2 tech note at https://u2devzone.rocketsoftware.com/accelerate/articles/u2-select, that does the following: LSELECT ARTVIOLATION WITH UNITID IN DEFAULT.LIST.NAME The list is simply generated then used in the statement. So, I can create a select