[U2] help with multivalue and when

I am querying a file with multivalued fields but I am not getting a precise enough selection. I want to find only those records where the multivalues for two separate fields meet the criteria within the same index. The file is the order-log file. There is only one record for each order number but

Re: [U2] help with multivalue and when

This is a classic MV situation that is over 25 years old. I don't know the platform and if it supports associated fields. But, traditionally, selects against 2 fields are often taken as 2 separate selects. The classic repair is to concatenate the requested pair into one dict item and select it

Re: [U2] help with multivalue and when

This is only a stab... if you make field 7 the name of a phrase, say ACT.ACT, for the dict item, with the phrase being in the same dict as PH ACTION ACT.DTE then do the same query? On 10/11/05, Jeff Powell [EMAIL PROTECTED] wrote: I am querying a file with multivalued fields but I am not getting

RE: [U2] help with multivalue and when

U2 is not a database. UniData or UniVerse ? On UniData try HELP WHEN and look at the explanation of the ASSOCIATED keyword I think you're looking for WHEN ASSOCIATED action = PCK AND act.date = (today) but you need to make sure the file dictionary is correctly set up also only works in ECLTYPE

RE: [U2] Basic vs Execute Select

Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, October 10, 2005 5:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Basic vs Execute Select A recent thread debated the speed of these 2 SELECT methods. My question is what

Re: [U2] help with multivalue and when

Jeff Powell wrote: I am querying a file with multivalued fields but I am not getting a precise enough selection. I want to find only those records where the multivalues for two separate fields meet the criteria within the same index. The file is the order-log file. There is only one record for

RE: [U2] help with multivalue and when

Jeff: If you don't have the usual U2 dictionary types (you have Pick S/A types) try: LIST ORDER-LOG BY-EXP ACTION = pck BY-EXP ACT.DATE = 10/11/05 . That should do the trick. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

RE: [OT] [U2] chance encounter with a u2 site

They began developing a client-server product about 1990, using OS/2 and Modula-2 and Sybase. Over the years they moved to Windows, went through C, C++, and are now using Java, and the database preferences are Oracle, MS SQL, and DB2 (I believe). The private investors who bought the company

Re: [U2] Basic vs Execute Select

EXECUTE COUNT FILENAME Mark Johnson [EMAIL PROTECTED] wrote: A recent thread debated the speed of these 2 SELECT methods. My question is what would be the preferred way to insure that all records may be counted for on an active system instead of a dormant system. Thanks in advance. Mark

RE: [U2] OPEN vs TRANS

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Timothy Snyder Sent: Friday, October 07, 2005 5:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS Now, as to people who want to code one line instead of two (e.g.: the topic

Re: [U2] Redback Training?

Ralph Burton [EMAIL PROTECTED] wrote on 10/11/2005 01:30:19 PM: Any suggestions on Redback training/education? Here's a good place to start. ;-) http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=pagecontentID=a523 Tim Snyder Consulting I/T Specialist , U2

[U2] /etc/magic

Hi, Does anyone have an up2date /etc/magic file component for UV files (up to an including UV 10 and 64-bit files) on HP Alpha platform? If so, are they able to make it available? Cheers, Phil --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

Re: [U2] help with multivalue and when

WITH selects records. WHEN only suppresses display of multivalued fields that do not meet your selection criteria. UniVerse/SQL makes this clearer, since you must specify both the selection clause and the suppression clause. You can do this with LIST as well. LIST filename field_list WITH

RE: [U2] Redback Training?

We do and have done RedBack training for over 4 years now. Call us for rates and availability 303-768-9601. Doug Averch www.u2logic.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ralph Burton Sent: Tuesday, October 11, 2005 11:30 AM To:

[U2] U2 XML/DB Tool

Has anyone had any luck in getting the U2 Client tool XMLDBTool to work (Connect) ? I'm trying to connect to a UV server on a W2K platform. I'm using the default settings for transport type and rpc port #. It seems to hang so I haven't been able to connect to my server. Anything I'm

[U2] Redback - What are you using to develop your web pages? JavaScript? PHP? .Net?

What are you using? Does it work well? Would you use it today if you doing development or consider something else? Thanks, Ralph P.S. Thanks for the Training responses too. - Yahoo! Music Unlimited - Access over 1

RE: [U2] Redback - What are you using to develop your web pages? JavaScript? PHP? .Net?

Comments interspersed... Doug Averch www.u2logic.com Software Solutions and Tools for U2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ralph Burton Sent: Tuesday, October 11, 2005 5:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Redback - What

[U2] UniVerse/Windows and VMWare {Unclassified}

Folks, We are considering a server consolidation exercise, particularly for our Development and Test environments, using VMWare to provide several 'virtual server' environments on a single physical box. One part of this proposal is that my UniVerse Development server will become a virtual server

RE: [U2] OPEN vs TRANS

George Gallen [EMAIL PROTECTED] wrote on 10/11/2005 02:01:52 PM: Also, I don't use the OCONV() method with corelatives, I use the VAR=RAISE(TRANS(filename,itemname,-1,'x')), which is pretty self commenting, of course, that requires you to know what the TRANS() keyword does. I'm still trying

RE: [U2] UniVerse/Windows and VMWare {Unclassified}

Michael , Yes is the answer, we've be trialling UV (10.1.12)/VMware and also with SUSE/Xen. Both of which work/play with UV just fine (so far). We are setting up 'single' user development environments for each developer and a floating number of test environments. We

RE: [U2] OPEN vs TRANS

Just because you can doesn't mean you should. UniVerse has many ways of doing things, some well and others not so well. I like you cannot se any benefit in using a TRANS... My 2 cents -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder