TCL Statement (AREV Specific)
At 22 OCT 2001 05:06:27PM b cameron wrote:
Hopefully an easy question. I know how to do this in Pick but doesn't seem to fly here..
I want to search a table on a multi-valued field (i.e. TYPE=INFO")
then display the tables item id the TYPE field (but only the value=INFO)and associated fields.
I have tried
LIST tablename BY-EXP TYPE=INFO" TYPE x1 x2 x3
this still gives me all the values in TYPE.
Write a symbolic or is my syntax off.
TIA
At 22 OCT 2001 05:48PM Raju Tamrakar wrote:
How about
:LIST TABLE WITH TYPE=INFO"
At 22 OCT 2001 08:47PM Mark Ford wrote:
Try:
List table_name field_name with every field_name=infO"
This command should list only those records who have the single response "Info". The key is the WITH EVERY.
Mark
At 23 OCT 2001 04:00AM C CHRISTIE wrote:
At 23 OCT 2001 04:02AM C CHRISTIE wrote:
At 23 OCT 2001 04:05AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Unusually prolix for the time of morning Mr Christie sir…
not using Opera are you (Aaron suspects a bug in Opera that he thinks does this)?
World Leaders in all things RevSoft
At 23 OCT 2001 09:50AM Michael Slack wrote:
The "WITH EVERY" looks like what you might want. You might want to look into "BY" or "BY_DSND" on multivalue columns. A long time ago, I did some programming in Pick as well and used the Explode sort. What I've been using in place of that on the AREV system is the sorting on a multivalued column which does the same thing. If you lood at the AREV manual entitled "Reference", on page 31, you see a section heading of "Sorting multivalue columns". The "WITH EVERY" is explained in the same manual on page 43 at the bottom. Of course I'm refering to the AREV manuals for AREV 3.12.
I hope this helps.
Michael Slack
At 23 OCT 2001 09:51AM Victor Engel wrote:
LIST tablename BY-EXP TYPE=INFO" TYPE x1 x2 x3
SELECT tablename BY TYPE
LIST tablename LIMIT TYPE=INFO" TYPE x1 x2 x3
In Arev BY implies BY-EXP on a multivalued field. In fact, if you look at the dictionary for BY-EXP, it is identical to the dictionary for BY.
At 23 OCT 2001 10:01AM Victor Engel wrote:
Note that WITH EVERY syntax will display a row only if every value in the field matches the syntax. The syntax I used will display only those values that match even if there are other values that don't match.
At 23 OCT 2001 11:01AM Cameron Christie wrote:
I suspect a dodgy NT Domain rollout that ate all the disk space on the PC I was using this morning. Shame - it's not often I get an answer up there ahead of you either…
At 23 OCT 2001 12:22PM David Kafka wrote:
I recently grabbed source code to a program called LIMIT which does what I think you are looking for
TCL Syntax would be LIMIT filename WITH field_name EQ values
Problem is, I don't know if the author maintains a copyright and I don't remember which web site! If this rings a bell with anyone, please post the link or let me know if it's OK to post the source code.
David Kafka
At 23 OCT 2001 12:43PM Victor Engel wrote:
I have one like that at http://the-light.com/limit.html
Feel free to grab it.
At 23 OCT 2001 02:05PM Don Miller - C3 Inc. wrote:
Victor ..
I remember that one. Nice piece of work. I think I used it to solve a nasty select issue in AREV 2.12. If I recall correctly, the MV field had an asterisk in it so the system saw it as a 2-part key. Your program bypasses all this caca.
Don
At 23 OCT 2001 07:46PM Aaron Kaplan wrote:
Aaron doesn't think.
no..wait…
Actually, that can be caused by an Opera bug, as well as premature clicking. Maybe I should report it to them.
At 23 OCT 2001 08:07PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Depending on what sort of criteria and active select list you have.
LIMIT takes the output of a MV list and only displays the values you're limiting on.
EVERY will only display the record/row if every MV value matches the close.
So, if I have a field with an MV value of "1,2,3" (where the , are @VMs delimiter) and another with "1"
LIST FILE FIELD WITH EVERY MV "1" will only display the second record since that's the only one where EVERY MY is 1
LIST FILE FIELD LIMIT MV "1" will display both records, but only display the MV lines that contain a 1.
It's a subtle difference, but does allow us maximum flexibility.
World Leaders in all things RevSoft
At 24 OCT 2001 08:57AM Don Miller - C3 Inc. wrote:
Aaron ..
FYI, I have been using Opera for a couple of months now and never seem to have had this problem. Kinda nice browser, all things considered. A few little annoyances (can't remember passwords, won't support Active-X, etc.) but very quick and compact. Not the monster that IE-5/6 are.
Don
At 24 OCT 2001 09:00AM Aaron Kaplan wrote:
I've found that there are some sites that text does not appear and the annoying posting issue in this forum. By and large, it's the only browser I use.