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
I would use the SAVING clause on a select of the repairs file to build a list
of stock id's then use a merge list command to see what stock ids do not have a
repairs record.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: 14
I am out of the office until 01/04/2008.
Please contact Kenton Turner on 07801 684291 in my absence.
Note: This is an automated response to your message U2 Users Digest V1
#2115 sent on 14/3/08 8:00:05.
This is the only notification you will receive while this person is away.
---
u2-users
At the universe tcl:
SELECT REPAIR SAVING UNIQUE STOCK.ID
Providing the the id to the STOCK file is in a field called STOCK.ID.
Raul
- Original Message -
From: Dennis Bartlett [EMAIL PROTECTED]
Sent: 03/14/2008 12:03 PM ZE2
To: u2-users@listserver.u2ug.org
Subject: [U2] Indexes
Dennis
Two more ways to do this:
1/ you can use BASIC but it's a slight pig..
The SelectIndex statement selects keys from an index. But it generates a
select list, so you need to be careful about segregating these e.g. if
calling from a SUBR() in an Idescriptor.
2/ a way I'm clearly not
I recently put together a Tech Tip for a monthly news Letter about the Merge
List process. That might help with your situation, take a look.
http://www.ashwoodcomputer.com/TechTip.html
This is not an ad for Ashwood Computer Company
Tom Dodds
[EMAIL PROTECTED]
630.235.2975
-Original
Thanks! This is by far the easiest, and it works!
-Original Message-
[EMAIL PROTECTED] wrote:
At the universe tcl:
SELECT REPAIR SAVING UNIQUE STOCK.ID
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
There is no function like the T correlative to translate to an indexed file
from a dict item, so you will need to do in BASIC as an I-type. The command
is BSCAN, e,g.
BSCAN BVAL,ID.LIST FROM FV,ID USING FIELDNAME ELSE BVAL =
ID.LIST contains an AM delimited list of keys to records in file FV
Dennis:
I would handle it with something like the following...
-Bill
*
equate true to 1, false to 0
open 'STOCK' to F.Stockelse null
open 'REPAIRS' to F.Repairs else null
clearselect ALL
execute SELECT REPAIRS
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
Keep it simple! In a program you can use SELECTINDEX and from a command
line use SELECT with the SAVING UNIQUE keywords.
Jerry Banker
-Original Message-
From: Scott Ballinger [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2008 9:22 AM
To: u2-users@listserver.u2ug.org
Subject: Re:
Hi,
I'll use Universe's XDOM functions and I don't understand how to work
with multiple xml nodes within a xPath result.
Into XDOMLocate I can use xPath like /bookstore/book[price50.00]' ;
it return a nodehandle to the first node which is ok with condition but
when I have many nodes I don't
Ah...
If that's what you want, then in BASIC
SELECTINDEX STOCK.ID FROM F.REPAIR
Should have exactly the same effect (and save the overhead of an EXECUTE). The
only difference is the resulting select list may not be sorted (although I
think it is).
If you then want to find what records are
13 matches
Mail list logo