Re: [mvdbms] Digest for mvdbms@googlegroups.com - 7 updates in 2 topics

[Mark Brown]

Without the by-exp option, the sentence is parsed as select with ANY color = "blue" and ANY price = "80". ANY is the default, opposed to EVERY value matching.

On Thu, Aug 25, 2022, 11:30 AM <mvd...@googlegroups.com> wrote:

mvd...@googlegroups.com

Google Groups

Topic digest
View all topics

• list and select on controlling and dependent colums - 6 Updates
• Intermittent problems with DOS MOVE command - 1 Update

list and select on controlling and dependent colums

Albert Kallal <kal...@msn.com>: Aug 25 12:01AM -0700 Well, my MV skills are starting to really get rusty (approaching 10 years now). However, every once in a while, I spool up my older copy of D3 (in fact, I think it might be older). Anyway, I have a question, and one that I don't remember the answer (or I am just plain wrong).   When I have a simple record like this: (one record for this question). I have HotelName, and then two columns (mv), of Option, and Price (controlling Option, dependent price).   so this list MyHotels HotelName Option Price   And thus this:   Page 1 MyHotels MyHotels.. HotelName.. Option. ... Price 1 Super 8 Hotel Red 70 Blue 80 Green 70 [405] 1 items listed out of 1 items.   Now it escapes me, but was there a way WITHOUT doing a explode on the above to query and get me the above hotel reocrd with Option = "Blue" and Price = 70 (of course that should fail).   Of course this returns the above record - expected. list MyHotels HotelName Option Price WITH Option = "Blue" AND WITH Price = "70"   But, how can I get the controlling + depend to work with above condition?   I realize I can do this: list MyHotels HOtelName Option Price by-exp Option by-exp price WITH Option = "Blue" AND WITH price = "70"   But, I seem to remember there was a way to check for "Option Blue and Price 70 (without a explode). Of course if I don't by-exp (explode), then asking for Blue and price 70 in above works - but it should not (Blue is price at 80).   Is my memory failing me? Can I query above without a explode? or did we always have to explode the above to ensure the controlling + depending attribute "line up" and conditions between the mv columns are respected???   Regards, Albert Kallal, Edmonton, Alberta Canada

"David Green" <dgr...@dagconsulting.com>: Aug 25 08:04AM -0700 In UniData you do this with the “WHEN” keywoard.     From: mvd...@googlegroups.com <mvd...@googlegroups.com> On Behalf Of Albert Kallal Sent: Thursday, August 25, 2022 12:01 AM To: Pick and MultiValue Databases <mvd...@googlegroups.com> Subject: [mvdbms] list and select on controlling and dependent colums     Well, my MV skills are starting to really get rusty (approaching 10 years now).   However, every once in a while, I spool up my older copy of D3 (in fact, I think it might be older).   Anyway, I have a question, and one that I don't remember the answer (or I am just plain wrong).     When I have a simple record like this:   (one record for this question).   I have HotelName, and then two columns (mv), of Option, and Price   (controlling Option, dependent price).     so this   list MyHotels HotelName Option Price     And thus this:     Page 1 MyHotels   MyHotels.. HotelName.. Option. ... Price   1 Super 8 Hotel Red 70   Blue 80   Green 70   [405] 1 items listed out of 1 items.     Now it escapes me, but was there a way WITHOUT doing a explode on the above to query and get me the above hotel reocrd with Option = "Blue" and Price = 70   (of course that should fail).     Of course this returns the above record - expected.   list MyHotels HotelName Option Price WITH Option = "Blue" AND WITH Price = "70"     But, how can I get the controlling + depend to work with above condition?     I realize I can do this:   list MyHotels HOtelName Option Price   by-exp Option by-exp price   WITH Option = "Blue" AND WITH price = "70"     But, I seem to remember there was a way to check for "Option Blue and Price 70 (without a explode).   Of course if I don't by-exp (explode), then asking for Blue and price 70 in above works - but it should not (Blue is price at 80).     Is my memory failing me? Can I query above without a explode? or did we always have to explode the above to ensure the controlling + depending attribute "line up" and conditions between the mv columns are respected???     Regards,   Albert Kallal,   Edmonton, Alberta Canada     -- You received this message because you are subscribed to the "Pick and MultiValue Databases" group. To post, email to: mvd...@googlegroups.com <mailto:mvd...@googlegroups.com> To unsubscribe, email to: mvdbms+un...@googlegroups.com <mailto:mvdbms+un...@googlegroups.com> For more options, visit http://groups.google.com/group/mvdbms --- You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group. To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com <mailto:mvdbms+un...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/mvdbms/3ab47fff-99a9-4364-932b-7b3d90efc8ffn%40googlegroups.com <https://groups.google.com/d/msgid/mvdbms/3ab47fff-99a9-4364-932b-7b3d90efc8ffn%40googlegroups.com?utm_medium=email&utm_source=footer> .

Albert Kallal <kal...@msn.com>: Aug 25 08:28AM -0700 Thank you kindly, - my older Pick version I have sitting around does not have "when". I just could not remember if one had to always explode a controlling and dependent set to have conditions that apply to that "set" of mv fields.   I guess the answer is that if you don't have "WHEN" support, then you have to expand/explode to have those conditions respect each other. But then again, if you have/had to do that, then you don't really need to setup controlling and dependent columns, do you?   Again, it been about 12 years since I done this, but I seem to recall a way of doing this. And I seem to recall such a query would not work UNLESS you setup the controlling and dependent set. Of course there is "print limiting" to restrict what is displayed, but that's not what I'm looking for.   So, for such a query, then I don't need the C & D set then do I? And such a C & D set does not help much at all then, right?   Anyway - I guess this comes down to my memory, or lack of.   Regards, Albert D. Kallal Edmonton, Alberta Canada       On Thursday, August 25, 2022 at 9:04:53 AM UTC-6 David Green wrote:

Albert Kallal <kal...@msn.com>: Aug 25 08:53AM -0700 Just to save follow up? Of course C and D fields matter - especially if you going to map that table to SQL, or have a editor figure this out!       On Thursday, August 25, 2022 at 9:28:56 AM UTC-6 Albert Kallal wrote:

Bill H <wpha...@gmail.com>: Aug 25 08:54AM -0700 Albert:   If I'm not mistaken you need to so something like:   LIST MYHOTELS BY-EXP Option = "Blue" HotelName Option Price   I don't ever remember any other option to "BY-EXP" in native PICK. "WHEN" works with UV/UD and others.   Bill   On Thursday, August 25, 2022 at 8:28:56 AM UTC-7 Albert Kallal wrote:

Albert Kallal <kal...@msn.com>: Aug 25 09:11AM -0700 Thanks. I perhaps should get a newer d3 or some such up and running. While I not in mv land right now? Well, I still often get involved in discussions about multi-value databases. And with the huge rise in xml and now json in our industry due to web? Then the concept of controlling and dependent data is missing from those systems. As a result, you can't query such data without the concept of controlling and dependent data. It actually a big issue.   R Albert

Back to top

Intermittent problems with DOS MOVE command

Bob Dubery <mega...@gmail.com>: Aug 25 04:51AM -0700 On Wednesday, 24 August 2022 at 06:32:13 UTC+2 ji...@temporal-wave.com wrote:   > This is the correct way to obviate the bugs in UniVerse EXECUTE and, so it > would seem, MVOn. It is to do with process permissions and synchronization.   How would it address permissions problems? Everything done with one process, so all files have the same owner?   I ask, because I thought it might be a synchronisation problem, but I am now more inclined to think it's a permissions problem (as previously noted, I tried to address the synch problem with liberal use of SLEEP. (Just to try and prove a point, I wouldn't have left them in the code and burdened the user with all that waiting).   Our system has a web browser front end, so all the basic programs are run as phantoms, with all phantoms being run as with the same user name and permissions. It is possible to log in to the system as that user IF you know the password, but the password (rightly) is distributed on a need to know basis - and I don't need to know.   I wrote a test program that can be run from the command line and which does the same operations in the same sequence. If I run via the browser interface, the move always fails on the same record. If I wait 30 minutes and run the job again, it will fail in the same place. If I log in as me using a telnet client and run it from the command line, it always works.   This is the reverse of the usual situation on our system, whereby the phantoms have more access than I do, but my point is that the problem seems to be moving with the user. But even this is odd, if the problem were caused by permissions surely ALL moves would fail or all succeed?

Back to top

You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to mvdbms+un...@googlegroups.com.