dbTalk Databases Forums  

ENGLISH MV Question

comp.databases.pick comp.databases.pick


Discuss ENGLISH MV Question in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joe
 
Posts: n/a

Default ENGLISH MV Question - 09-29-2003 , 11:57 AM






I'm trying to see if there's an inconsistency between Pick variants given
the LIST statements below.

Here's a record (the ']' characters are value marks):
000 REC1
001 A]B]C
002 Code A]Code B]Code C
003 ]]100

Here's the output of LIST MYFILE "REC1" 1 2 3:
MYFILE..... CODE DESCRIPTION AMOUNT
REC1 A Code A
B Code B
C Code C 1.00
The '1.00' is the third value in the 'AMOUNT' column.

Here's the output of LIST MYFILE "REC1" 3:
MYFILE..... AMOUNT
REC1
1.00
Note that the '1.00' is on the line immediately below 'REC1'. IOW, it's
not shown as the third value in the output. Are all Pick systems
consistent in this manner, or will some show the '1.00' as the third value
(i.e., a blank line between the 'REC1' and the '1.00')? TIA.

Regards,
Joe

Reply With Quote
  #2  
Old   
Chandru Murthi
 
Posts: n/a

Default Re: ENGLISH MV Question - 09-29-2003 , 01:19 PM






That's the way it was originally. Some systems, I think Sequoia and Ult
would compress the list so 1.00 would appear on the first line, if there
were no other mv's displayed on preceding lines (to keep related mv;s in
synch.)

UV 9.6 shows 2 blank lines and 1.00 on the third, ie null mv's are
treated as if they were nonnull.

Chandru Murthi

Joe wrote:
Quote:
I'm trying to see if there's an inconsistency between Pick variants given
the LIST statements below.

Here's a record (the ']' characters are value marks):
000 REC1
001 A]B]C
002 Code A]Code B]Code C
003 ]]100

Here's the output of LIST MYFILE "REC1" 1 2 3:
MYFILE..... CODE DESCRIPTION AMOUNT
REC1 A Code A
B Code B
C Code C 1.00
The '1.00' is the third value in the 'AMOUNT' column.

Here's the output of LIST MYFILE "REC1" 3:
MYFILE..... AMOUNT
REC1
1.00
Note that the '1.00' is on the line immediately below 'REC1'. IOW, it's
not shown as the third value in the output. Are all Pick systems
consistent in this manner, or will some show the '1.00' as the third value
(i.e., a blank line between the 'REC1' and the '1.00')? TIA.

Regards,
Joe


Reply With Quote
  #3  
Old   
Brian Leach
 
Posts: n/a

Default Re: ENGLISH MV Question - 10-07-2003 , 02:54 AM



Joe,

This should work the same on all platforms. However to be sure, if your
variant understands the concept of association phrases, these should be used
for belt-and-braces.

Brian Leach

Quote:
Joe wrote:
I'm trying to see if there's an inconsistency between Pick variants
given
the LIST statements below.

Here's a record (the ']' characters are value marks):
000 REC1
001 A]B]C
002 Code A]Code B]Code C
003 ]]100

Here's the output of LIST MYFILE "REC1" 1 2 3:
MYFILE..... CODE DESCRIPTION AMOUNT
REC1 A Code A
B Code B
C Code C 1.00
The '1.00' is the third value in the 'AMOUNT' column.

Here's the output of LIST MYFILE "REC1" 3:
MYFILE..... AMOUNT
REC1
1.00
Note that the '1.00' is on the line immediately below 'REC1'. IOW, it's
not shown as the third value in the output. Are all Pick systems
consistent in this manner, or will some show the '1.00' as the third
value
(i.e., a blank line between the 'REC1' and the '1.00')? TIA.

Regards,
Joe




Reply With Quote
  #4  
Old   
Joe
 
Posts: n/a

Default Re: ENGLISH MV Question - 10-08-2003 , 07:29 PM



First off, thanks to Chandru for his response. The UV example was
what I was expecting.

Brian, from my experience this doesn't work the same on all platforms.
Unfortunate, but true.

My problem was that I needed to show a particular column alone in the
same way as if it were being displayed next to an associated column
full of data. I ended up doing a dictionary work-around to produce
the UV-like output.

Regards,
Joe


"Brian Leach" <bfl (AT) mmt-thamesvalley (DOT) com> wrote in
news:fjugb.4804$kA.1332198 (AT) wards (DOT) force9.net:

Quote:
Joe,

This should work the same on all platforms. However to be sure, if
your variant understands the concept of association phrases, these
should be used for belt-and-braces.

Brian Leach

Joe wrote:
I'm trying to see if there's an inconsistency between Pick
variants
given
the LIST statements below.

Here's a record (the ']' characters are value marks):
000 REC1
001 A]B]C
002 Code A]Code B]Code C
003 ]]100

Here's the output of LIST MYFILE "REC1" 1 2 3:
MYFILE..... CODE DESCRIPTION AMOUNT
REC1 A Code A
B Code B
C Code C 1.00
The '1.00' is the third value in the 'AMOUNT' column.

Here's the output of LIST MYFILE "REC1" 3:
MYFILE..... AMOUNT
REC1
1.00
Note that the '1.00' is on the line immediately below 'REC1'.
IOW, it's not shown as the third value in the output. Are all
Pick systems consistent in this manner, or will some show the
'1.00' as the third
value
(i.e., a blank line between the 'REC1' and the '1.00')? TIA.

Regards,
Joe






Reply With Quote
  #5  
Old   
cmurthi
 
Posts: n/a

Default Re: ENGLISH MV Question - 10-11-2003 , 10:15 AM



I suspect on most Picks you can set a Dict association (C - D in line
4), which will force the display in synch. Another way of course is to
use an A; correlative that concats the various fields you want to
display. Remember to do output conversion within the A; and perhaps pad
to fixed length. Of course, you will truncate long strips instead of
wrapping.

Eg: attrs 2 : 3(date) : 4( money) could be formatted by:

A;2(L#30 ):3(D2/):4(MR2,$ #10)

note the blanks within the format field serve to separate the display data.

Chandru Murthi

Joe wrote:
Quote:
First off, thanks to Chandru for his response. The UV example was
what I was expecting.

Brian, from my experience this doesn't work the same on all platforms.
Unfortunate, but true.

My problem was that I needed to show a particular column alone in the
same way as if it were being displayed next to an associated column
full of data. I ended up doing a dictionary work-around to produce
the UV-like output.

Regards,
Joe


"Brian Leach" <bfl (AT) mmt-thamesvalley (DOT) com> wrote in
news:fjugb.4804$kA.1332198 (AT) wards (DOT) force9.net:


Joe,

This should work the same on all platforms. However to be sure, if
your variant understands the concept of association phrases, these
should be used for belt-and-braces.

Brian Leach


Joe wrote:

I'm trying to see if there's an inconsistency between Pick
variants

given

the LIST statements below.

Here's a record (the ']' characters are value marks):
000 REC1
001 A]B]C
002 Code A]Code B]Code C
003 ]]100

Here's the output of LIST MYFILE "REC1" 1 2 3:
MYFILE..... CODE DESCRIPTION AMOUNT
REC1 A Code A
B Code B
C Code C 1.00
The '1.00' is the third value in the 'AMOUNT' column.

Here's the output of LIST MYFILE "REC1" 3:
MYFILE..... AMOUNT
REC1
1.00
Note that the '1.00' is on the line immediately below 'REC1'.
IOW, it's not shown as the third value in the output. Are all
Pick systems consistent in this manner, or will some show the
'1.00' as the third

value

(i.e., a blank line between the 'REC1' and the '1.00')? TIA.

Regards,
Joe






Reply With Quote
  #6  
Old   
Joe
 
Posts: n/a

Default Re: ENGLISH MV Question - 10-11-2003 , 05:20 PM



cmurthi <xyzcmurthi (AT) quest (DOT) with.a.w.net> wrote in
news:3F881E76.50400 (AT) quest (DOT) with.a.w.net:

Quote:
I suspect on most Picks you can set a Dict association (C - D in
line 4), which will force the display in synch. Another way of
course is to use an A; correlative that concats the various fields
you want to display. Remember to do output conversion within the A;
and perhaps pad to fixed length. Of course, you will truncate long
strips instead of wrapping.

Eg: attrs 2 : 3(date) : 4( money) could be formatted by:

A;2(L#30 ):3(D2/):4(MR2,$ #10)

note the blanks within the format field serve to separate the
display data.

Chandru Murthi
I ended up doing something very similar - I simply created a
dictionary that prefixed the real value with a space to force the
"blank" rows where there were null values. Thanks again for the
responses.

Regards,
Joe


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.