Re: [U2] Multi-value harmful? To whom?

2006-07-20 Thread Bruce Nichol 

Goo'day,

At 23:37 20/07/06 -0400, you wrote:


   You're scaring me, Debster!
   I  forgot to mention that the function of "and" in our very-high-level
   language,  called  English,  is  to  denote  that  the  next  value is
   end-of-list.   Maybe  we should have an "and" special character in MV?
   The  substringing of the attributes in the MV system is implemented by
   scanning  the characters and "blocking" the data between delimiters...
   just like we real humans scan a sentence.
   Now I am scaring you???
If  IBM  or MS had just discovered MV yesterday, it would be heralded
   as a huge break-through in digital technology.
   Too  bad  IBM didn't bump into Richard Pick instead of Bill Gates when
   they went looking for someone to implement a small and inconsequential
   operating  system  for the PC.


According to the information being bandied about over the years, they DID!

If not then, then shortly thereafter.



Regards,

Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia

http://www.taloncs.com.au

Tel: +61 (0)411149636
Fax: +61 (0)260232119

If it ain't broke, fix it till it is! 



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.10.3/394 - Release Date: 20/07/06
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Multi-value harmful? To whom?

2006-07-20 Thread will 
   Oh, d-d-d-dear me, did I say, "... at the same time."?
It is rather a hoot to fly r/c from a ski-boat... kinda' tricky while
   swimming though.

   Patrick Williams, President,

   American Computer Technics, Inc.

   www.actLinux.com
   George Gallen wrote:

True, Swimming and radio controlled aircraft just seem
  like too different a hobby to do at the same time

Now...Swimming and radio controlled Boatingdifferent story

(using And in the Boolean sense)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Debster
Sent: Thursday, July 20, 2006 4:04 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Multi-value harmful? To whom?

BTW..

I'm glad you didn't list your hobbies as

Robbery,Rape,Murder

and er...you would not have the "and" as you listed

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of will
Sent: Thursday, July 20, 2006 3:43 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Multi-value harmful? To whom?

   Real  life  information  consists of multi-value
attributes, as in the
   example  given,  one  person  has  many hobbies.  Our
English language
   accommodates  multi-values  with  a  comma  as  a
delimiter.  Thus, my
   hobbies  are  volleyball,  gardening,  swimming,  and
radio-controlled
   aircraft.   Note the commas.  Was this harmful to anyone's
brain.  Did
   anyone  misunderstand?   If  digital  technology is to
advance it must
   accommodate  the  real-word  and  reflect  rather  than
obfuscate that
   reality...  It  seems  that only Multi-Value database
systems do that.
   So why are they considered "Legacy" database systems?
   Patrick J. Williams, President
   American Computer Technics, Inc.
   www.actLinux.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Multi-value harmful? To whom?

2006-07-20 Thread will 
   You're scaring me, Debster!
   I  forgot to mention that the function of "and" in our very-high-level
   language,  called  English,  is  to  denote  that  the  next  value is
   end-of-list.   Maybe  we should have an "and" special character in MV?
   The  substringing of the attributes in the MV system is implemented by
   scanning  the characters and "blocking" the data between delimiters...
   just like we real humans scan a sentence.
   Now I am scaring you???
If  IBM  or MS had just discovered MV yesterday, it would be heralded
   as a huge break-through in digital technology.
   Too  bad  IBM didn't bump into Richard Pick instead of Bill Gates when
   they went looking for someone to implement a small and inconsequential
   operating  system  for the PC.  Yikes, instead of Legacy, MV would
   be on 98% of all computers in the West AND China.

   Patrick Williams, President,

   American Computer Technics, Inc.

   www.actLinux.com
   Debster wrote:

BTW..

I'm glad you didn't list your hobbies as

Robbery,Rape,Murder

and er...you would not have the "and" as you listed

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of will
Sent: Thursday, July 20, 2006 3:43 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Multi-value harmful? To whom?

   Real  life  information  consists of multi-value attributes, as in the
   example  given,  one  person  has  many hobbies.  Our English language
   accommodates  multi-values  with  a  comma  as  a delimiter.  Thus, my
   hobbies  are  volleyball,  gardening,  swimming,  and radio-controlled
   aircraft.   Note the commas.  Was this harmful to anyone's brain.  Did
   anyone  misunderstand?   If  digital  technology is to advance it must
   accommodate  the  real-word  and  reflect  rather  than obfuscate that
   reality...  It  seems  that only Multi-Value database systems do that.
   So why are they considered "Legacy" database systems?
   Patrick J. Williams, President
   American Computer Technics, Inc.
   www.actLinux.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Changed BASIC varname<1,-1>

2006-07-20 Thread Jacques G. 
> I always use   A.VAR :=
> @AM[1,NOT(NOT(A.VAR))]:NEW.DATA
> It is much more reliable and much quicker than <-1>

This is probably for people who want the position of
the item in the list to be significant. (The empty
values being wanted)  I find the code is easier on the
eyes to do:

NB +=1
A.VAR = NEW.DATA



__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Multivalue harmful - Register response

2006-07-20 Thread John Hester 
The Register took note of the collective comments from U2 and Pick
users:

http://www.regdeveloper.co.uk/2006/07/20/mutivalue_response/

The reason given for the response is "To set the matter straight and to
avoid unnecessary email traffic", but given the somewhat disparaging way
they're describing current MV databases, I think it may have the
opposite effect.

-John

John Hester
System & Network Administrator
Momentum Textiles, Inc.
(949) 833-8886 x623
http://www.memosamples.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Multi-value harmful? To whom?

2006-07-20 Thread Debster 
 ...orwould the "with" items be thrown in as sub-values instead?

swimming with sharks,radio controlled boating,glee following a huge dive
from the spreader,humpback whales,dolphins in BVI, no clothes, embarrassment
after not listening when someone yelled jibe-ho!


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of George Gallen
Sent: Thursday, July 20, 2006 5:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Multi-value harmful? To whom?


True, Swimming and radio controlled aircraft just seem
  like too different a hobby to do at the same time

Now...Swimming and radio controlled Boatingdifferent story

(using And in the Boolean sense)

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Debster
> Sent: Thursday, July 20, 2006 4:04 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Multi-value harmful? To whom?
>
>
> BTW..
>
> I'm glad you didn't list your hobbies as
>
> Robbery,Rape,Murder
>
> and er...you would not have the "and" as you listed
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of will
> Sent: Thursday, July 20, 2006 3:43 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Multi-value harmful? To whom?
>
>
>Real  life  information  consists of multi-value
> attributes, as in the
>example  given,  one  person  has  many hobbies.  Our
> English language
>accommodates  multi-values  with  a  comma  as  a
> delimiter.  Thus, my
>hobbies  are  volleyball,  gardening,  swimming,  and
> radio-controlled
>aircraft.   Note the commas.  Was this harmful to anyone's
> brain.  Did
>anyone  misunderstand?   If  digital  technology is to
> advance it must
>accommodate  the  real-word  and  reflect  rather  than
> obfuscate that
>reality...  It  seems  that only Multi-Value database
> systems do that.
>So why are they considered "Legacy" database systems?
>Patrick J. Williams, President
>American Computer Technics, Inc.
>www.actLinux.com
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Multi-value harmful? To whom?

2006-07-20 Thread George Gallen 
True, Swimming and radio controlled aircraft just seem
  like too different a hobby to do at the same time

Now...Swimming and radio controlled Boatingdifferent story

(using And in the Boolean sense)

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Debster
> Sent: Thursday, July 20, 2006 4:04 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Multi-value harmful? To whom?
> 
> 
> BTW..
> 
> I'm glad you didn't list your hobbies as
> 
> Robbery,Rape,Murder
> 
> and er...you would not have the "and" as you listed
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of will
> Sent: Thursday, July 20, 2006 3:43 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Multi-value harmful? To whom?
> 
> 
>Real  life  information  consists of multi-value 
> attributes, as in the
>example  given,  one  person  has  many hobbies.  Our 
> English language
>accommodates  multi-values  with  a  comma  as  a 
> delimiter.  Thus, my
>hobbies  are  volleyball,  gardening,  swimming,  and 
> radio-controlled
>aircraft.   Note the commas.  Was this harmful to anyone's 
> brain.  Did
>anyone  misunderstand?   If  digital  technology is to 
> advance it must
>accommodate  the  real-word  and  reflect  rather  than 
> obfuscate that
>reality...  It  seems  that only Multi-Value database 
> systems do that.
>So why are they considered "Legacy" database systems?
>Patrick J. Williams, President
>American Computer Technics, Inc.
>www.actLinux.com
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Multi-value harmful? To whom?

2006-07-20 Thread Allen E. Elwood 
A couple of years ago, I had to convert the data for someone that was moving
away from MV to SQL.  On average, I had to create about 10 separate
downloads for each single U2 file so SQL could handle it.  And they thought
they were "moving up" in technology.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of will
Sent: Thursday, July 20, 2006 12:43
To: u2-users@listserver.u2ug.org
Subject: [U2] Multi-value harmful? To whom?


   Real  life  information  consists of multi-value attributes, as in the
   example  given,  one  person  has  many hobbies.  Our English language
   accommodates  multi-values  with  a  comma  as  a delimiter.  Thus, my
   hobbies  are  volleyball,  gardening,  swimming,  and radio-controlled
   aircraft.   Note the commas.  Was this harmful to anyone's brain.  Did
   anyone  misunderstand?   If  digital  technology is to advance it must
   accommodate  the  real-word  and  reflect  rather  than obfuscate that
   reality...  It  seems  that only Multi-Value database systems do that.
   So why are they considered "Legacy" database systems?
   Patrick J. Williams, President
   American Computer Technics, Inc.
   www.actLinux.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Multi-value harmful? To whom?

2006-07-20 Thread Debster 
BTW..

I'm glad you didn't list your hobbies as

Robbery,Rape,Murder

and er...you would not have the "and" as you listed

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of will
Sent: Thursday, July 20, 2006 3:43 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Multi-value harmful? To whom?


   Real  life  information  consists of multi-value attributes, as in the
   example  given,  one  person  has  many hobbies.  Our English language
   accommodates  multi-values  with  a  comma  as  a delimiter.  Thus, my
   hobbies  are  volleyball,  gardening,  swimming,  and radio-controlled
   aircraft.   Note the commas.  Was this harmful to anyone's brain.  Did
   anyone  misunderstand?   If  digital  technology is to advance it must
   accommodate  the  real-word  and  reflect  rather  than obfuscate that
   reality...  It  seems  that only Multi-Value database systems do that.
   So why are they considered "Legacy" database systems?
   Patrick J. Williams, President
   American Computer Technics, Inc.
   www.actLinux.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Multi-value harmful? To whom?

2006-07-20 Thread Debster 
maybe.

older and wiser?


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of will
Sent: Thursday, July 20, 2006 3:43 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Multi-value harmful? To whom?


   Real  life  information  consists of multi-value attributes, as in the
   example  given,  one  person  has  many hobbies.  Our English language
   accommodates  multi-values  with  a  comma  as  a delimiter.  Thus, my
   hobbies  are  volleyball,  gardening,  swimming,  and radio-controlled
   aircraft.   Note the commas.  Was this harmful to anyone's brain.  Did
   anyone  misunderstand?   If  digital  technology is to advance it must
   accommodate  the  real-word  and  reflect  rather  than obfuscate that
   reality...  It  seems  that only Multi-Value database systems do that.
   So why are they considered "Legacy" database systems?
   Patrick J. Williams, President
   American Computer Technics, Inc.
   www.actLinux.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Multi-value harmful? To whom?

2006-07-20 Thread will 
   Real  life  information  consists of multi-value attributes, as in the
   example  given,  one  person  has  many hobbies.  Our English language
   accommodates  multi-values  with  a  comma  as  a delimiter.  Thus, my
   hobbies  are  volleyball,  gardening,  swimming,  and radio-controlled
   aircraft.   Note the commas.  Was this harmful to anyone's brain.  Did
   anyone  misunderstand?   If  digital  technology is to advance it must
   accommodate  the  real-word  and  reflect  rather  than obfuscate that
   reality...  It  seems  that only Multi-Value database systems do that.
   So why are they considered "Legacy" database systems?
   Patrick J. Williams, President
   American Computer Technics, Inc.
   www.actLinux.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Select Lists in Proverb

2006-07-20 Thread Brian Leach 
Carl

Two more options:

1. Use the IF S construct. This returns true if a select is active, e.g.

PQN
MV #1 "SELECT stuff"
P
IF S GO 10
C goes here if no stuff
X NO SELECT
10 

2. Use the REQUIRE.SELECT clause when processing the second command, e.g.
SSELECT OW WITH blah REQUIRE.SELECT

Brian 


 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Carl Sadlier
> Sent: 20 July 2006 16:41
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Select Lists in Proverb
> 
> I need to be able to see if a select returns any ids before 
> doing another select list in a proc. Here is the code I am using:
> 
> O SELECTING OPEN ORDERS TO PROCESS
> 
> HSSELECT ORDERS.ON.HOLD WITH HOLD.TYPE = MRAHL AND CURRENT.HOLD # "OK"
> 
> IF A3=ALL G 75
> 
> H AND WITH HOLD.DATE GE
> 
> A"3
> 
> H AND WITH HOLD.DATE LE
> 
> A"4
> 
> 75
> 
> H SAVING OWID
> 
> P
> 
> C
> 
> HSSELECT OW WITH CO =
> 
> A"2
> 
> C
> 
> The problem is if the ORDERS.ON.HOLD file doesn't return any 
> ids the OW file returns all of its ids. If there are no 
> records in the ORDERS.ON.HOLD file then I just want to stop 
> processing the proc.
> 
> Thanks,
> 
> Carl
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Select Lists in Proverb

2006-07-20 Thread Cordes, Tom (contractor) 
Carl,

If its Unidata, 'REQUIRE.SELECT' in the 2nd select statement will work if
you're using 'Unidata' flavor.  For 'pick' flavor a lower case for the 1st
letter of verb (HsSELECT) is also required.

Using SELECT instead of SSELECT may speed things up a bit in the first
selection statement.

Hope this helps.

Tom

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carl Sadlier
Sent: Thursday, July 20, 2006 11:41 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select Lists in Proverb

I need to be able to see if a select returns any ids before doing another
select list in a proc. Here is the code I am using:

O SELECTING OPEN ORDERS TO PROCESS

HSSELECT ORDERS.ON.HOLD WITH HOLD.TYPE = MRAHL AND CURRENT.HOLD # "OK"

IF A3=ALL G 75

H AND WITH HOLD.DATE GE

A"3

H AND WITH HOLD.DATE LE

A"4

75

H SAVING OWID

P

C

HSSELECT OW WITH CO =

A"2

C

The problem is if the ORDERS.ON.HOLD file doesn't return any ids the OW file
returns all of its ids. If there are no records in the ORDERS.ON.HOLD file
then I just want to stop processing the proc.

Thanks,

Carl
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Select Lists in Proverb

2006-07-20 Thread Jerry Banker 
Look at the REQUIRE.SELECT or SELECT.ONLY keywords.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carl Sadlier
Sent: Thursday, July 20, 2006 10:41 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Select Lists in Proverb

I need to be able to see if a select returns any ids before doing
another select list in a proc. Here is the code I am using:

O SELECTING OPEN ORDERS TO PROCESS

HSSELECT ORDERS.ON.HOLD WITH HOLD.TYPE = MRAHL AND CURRENT.HOLD # "OK"

IF A3=ALL G 75

H AND WITH HOLD.DATE GE

A"3

H AND WITH HOLD.DATE LE

A"4

75

H SAVING OWID

P

C

HSSELECT OW WITH CO =

A"2

C

The problem is if the ORDERS.ON.HOLD file doesn't return any ids the OW
file returns all of its ids. If there are no records in the
ORDERS.ON.HOLD file then I just want to stop processing the proc.

Thanks,

Carl
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] Select Lists in Proverb

2006-07-20 Thread BNeylon 
Make use of STON

O SELECTING OPEN ORDERS TO PROCESS
HSSELECT ORDERS.ON.HOLD WITH HOLD.TYPE = MRAHL AND CURRENT.HOLD # "OK"
IF A3=ALL G 75
H AND WITH HOLD.DATE GE
A"3
H AND WITH HOLD.DATE LE
A"4
75
H SAVING OWID
STON
C
HSSELECT OW WITH CO =
A"2
C
H<
HWHATEVER PROGRAM OR LIST
P

Bruce M Neylon
Health Care Management Group 
Phone: (301) 608-8633



"Carl Sadlier" <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
07/20/2006 11:40 AM
Please respond to
u2-users@listserver.u2ug.org


To

cc

Subject
[U2] Select Lists in Proverb






I need to be able to see if a select returns any ids before doing
another select list in a proc. Here is the code I am using:

O SELECTING OPEN ORDERS TO PROCESS

HSSELECT ORDERS.ON.HOLD WITH HOLD.TYPE = MRAHL AND CURRENT.HOLD # "OK"

IF A3=ALL G 75

H AND WITH HOLD.DATE GE

A"3

H AND WITH HOLD.DATE LE

A"4

75

H SAVING OWID

P

C

HSSELECT OW WITH CO =

A"2

C

The problem is if the ORDERS.ON.HOLD file doesn't return any ids the OW
file returns all of its ids. If there are no records in the
ORDERS.ON.HOLD file then I just want to stop processing the proc.

Thanks,

Carl
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] Select Lists in Proverb

2006-07-20 Thread Carl Sadlier 
I need to be able to see if a select returns any ids before doing
another select list in a proc. Here is the code I am using:

O SELECTING OPEN ORDERS TO PROCESS

HSSELECT ORDERS.ON.HOLD WITH HOLD.TYPE = MRAHL AND CURRENT.HOLD # "OK"

IF A3=ALL G 75

H AND WITH HOLD.DATE GE

A"3

H AND WITH HOLD.DATE LE

A"4

75

H SAVING OWID

P

C

HSSELECT OW WITH CO =

A"2

C

The problem is if the ORDERS.ON.HOLD file doesn't return any ids the OW
file returns all of its ids. If there are no records in the
ORDERS.ON.HOLD file then I just want to stop processing the proc.

Thanks,

Carl
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] RE: Multivalued datatypes considered harmful | The Register Register

2006-07-20 Thread Glen Batchelor 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of George Gallen
> Sent: Thursday, July 20, 2006 9:40 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] RE: Multivalued datatypes considered harmful | The
> Register Register
> 
> Keeping in mind, multivalue works for UV/PICK because the OS/database
> structure
> was designed around that concept.
> 
> Now, trying to get a single field application that has been designed
> around a
> single field of data to now try to "deal" with multivalue would be quite
> harmful,
> to the application.
> 
> It's kinda of like trying to implement GUI into UV code without using 3rd
> party
> methods, it would, not doubt, be very difficult and cause many a program
> to
> stop working correctly
> 
> I'm sure if the Access/Oracle/MySQL were redesigned with multi-value in
> mind, the opinoin
> would be a little higher of it's usefulness (to Access/SQL world)
> 

  Well, if there had been a standardization of access to MV data then this
would not be an issue. I really think I should resurrect that RFC for
communication of multi-valued data. The real question now, is whether or not
it should be normalized for 2-dimensional communications or written in
conjunction with an XML spec. :)  Maybe someone with more of a 1NF
philosophical background should review what's there now?

> George

---
Glen Batchelor
IT Director
All-Spec Industries
phone: (910) 332-0424
fax: (910) 763-5664
e-mail: [EMAIL PROTECTED]
---
www.allspec.com
---
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Replication and disaster planning/recovery

2006-07-20 Thread D Averch 
Laure,

We were not thrilled with Universe replication efforts, so we wrote our own.
There was a lot of setup involved and program changes that we did not want
to make.  Also, we use Unidata and the two systems at the time we looked at
them did not support the same model.

Our solution does not use the publish type model and is much easier to
implement.  You just need to call a single subroutine where you do your
writes or build a trigger on the files you want to replicate.

Please contact me off-line for more detail information.

Doug Averch
President
www.u2logic.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen
Sent: Wednesday, July 19, 2006 5:10 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Replication and disaster planning/recovery

Hi!

What have you/are you using for data replication across NT Universe
servers? Do you have any specific feedback on the replication tool that
comes with Universe? Any input on BrightStore's product? How else do you
handle disaster planning and recovery?

Thanks in advance.

Laure Hansen,
City of Redwood City
Information Technology
www.redwoodcity.org 
1017 Middlefield Road
Redwood City, CA 94063
Tel: 650-780-7087
Fax: 650-556-9204
[EMAIL PROTECTED] 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] RE: Multivalued datatypes considered harmful | The Register Register

2006-07-20 Thread George Gallen 
Keeping in mind, multivalue works for UV/PICK because the OS/database structure
was designed around that concept.

Now, trying to get a single field application that has been designed around a
single field of data to now try to "deal" with multivalue would be quite 
harmful,
to the application.

It's kinda of like trying to implement GUI into UV code without using 3rd party
methods, it would, not doubt, be very difficult and cause many a program to
stop working correctly

I'm sure if the Access/Oracle/MySQL were redesigned with multi-value in mind, 
the opinoin
would be a little higher of it's usefulness (to Access/SQL world)

George

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod
> Sent: Wednesday, July 19, 2006 9:20 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] RE: Multivalued datatypes 
> considered
> harmful | The Register Register
> 
> 
> I responded in a positive tone to the author with examples of 
> how his assertions are undermined by simple understanding of 
> the processes involved - primarily separating selection from 
> display in one's mindset.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Printer Groups

2006-07-20 Thread Tom Dodds 
I agree :(.  I guess you could get that out of the documentation, but I did
not.

Thanks for the reply, I will have to take a different tact.

Tom Dodds
[EMAIL PROTECTED]
513-563-2800 Cincinnati Office
708-234-9608 Chicago Office
630-235-2975 Anywhere Cell
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
Sent: Wednesday, July 19, 2006 9:16 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Printer Groups

Being a member of a printer group only gives access to five functions
(start/stop printing, start/stop queueing and mount form type).  It does not
give the administrative privileges that permit you to cancel or change
another user's jobs.  :(
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] RE: Multivalued datatypes considered harmful | The Register

2006-07-20 Thread u2 
[EMAIL PROTECTED] wrote:
> I responded in a positive tone to the author with examples of how his 
> assertions are undermined by simple understanding of the processes involved - 
> primarily separating selection from display in one's mindset.

I've also replied - with a condensed version of my usual stuff about Codd & 
Date's rules being a useless foundation for building a decent theory on. Rather 
than likening those rules to Newton, I decided it was better to liken them to 
Galileo. Galileo said "the planets CIRCLE the sun", which was badly wrong. We 
view him much more favourably, in part because he had the right idea, and in 
part because we confuse the words "circle" and "orbit" such that what we hear 
is very much *not* what he said.

I'm hoping he might respond to me, in which case I'll point him to rather more 
stuff. In particular, my page on PickWiki, but I don't want to risk that 
reference getting published!

Cheers,
Wol
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/