dbTalk Databases Forums  

SORTTAB Bug? (D3NT 7.1)

comp.databases.pick comp.databases.pick


Discuss SORTTAB Bug? (D3NT 7.1) in the comp.databases.pick forum.



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

Default SORTTAB Bug? (D3NT 7.1) - 06-26-2005 , 11:13 PM






Hi Folks,
I am trying to use the SORTTAB facility in an old release of D3 NT
(7.1.4 I think). I think there is an issue with redirecting the output to
the spooler, i.e. (P

I have created a new verb: SORTTAB and appended Char(253):'53' to field 2 as
per TFM.

If I do: 'SORTTAB CUSTOMERS NAME ADDR PHONE (P' on D3/Linux 7.4.2 the
command completes and a hold entry is generated. This is the correct
behaviour.

If I do: 'SORTTAB CUSTOMERS NAME ADDR PHONE (P' on D3/NT 7.1.4 the output
(including tabs) is directed to the screen and no hold entry is created.

Similarly if i do (on D3/NT) EXECUTE 'SORTTAB CUSTOMERS NAME ADDR PHONE'
CAPTURING TABRPT the results go the screen and TABRPT is nul.

The manual does not state that this a *NIX specific feature.

I don't really care that it doesn't work on this old release, I just want to
confirm that the newer (7.4.*) NT release is NOT affected. Can anyone test
this for me?


Cheers,


John V.



Reply With Quote
  #2  
Old   
Bill H
 
Posts: n/a

Default Re: SORTTAB Bug? (D3NT 7.1) - 06-29-2005 , 05:16 PM






John:

We use this feature often in our application. Lately, however, I've been
finding extraneous data loaded into our tab-delimited files. I believe this
has to do with the D3 "ZC" conversion code, especially with foreign
addresses. The same issue occurs on "LIST-LABEL" commands when using
foreign conversions.

On a number of occasions, I've had to write a simple BASIC routine to print
the tab-delimited data, rather than relying on the "SORTTAB" facility, to
ensure the file is being received by numerous banks in a proper format.

I'm sorry to say that I've found no resolution to these problems.

Bill

P.S. I would recommend you migrate from D3NT v7.1.x as it is not conducive
to a production environment, except for plain vanilla R83 processing.

"John V" <johnv.invalid.chemform.com.au.z> wrote

Quote:
Hi Folks,
I am trying to use the SORTTAB facility in an old release of D3 NT
(7.1.4 I think). I think there is an issue with redirecting the output to
the spooler, i.e. (P

I have created a new verb: SORTTAB and appended Char(253):'53' to field 2
as
per TFM.

If I do: 'SORTTAB CUSTOMERS NAME ADDR PHONE (P' on D3/Linux 7.4.2 the
command completes and a hold entry is generated. This is the correct
behaviour.

If I do: 'SORTTAB CUSTOMERS NAME ADDR PHONE (P' on D3/NT 7.1.4 the output
(including tabs) is directed to the screen and no hold entry is created.

Similarly if i do (on D3/NT) EXECUTE 'SORTTAB CUSTOMERS NAME ADDR PHONE'
CAPTURING TABRPT the results go the screen and TABRPT is nul.

The manual does not state that this a *NIX specific feature.

I don't really care that it doesn't work on this old release, I just want
to
confirm that the newer (7.4.*) NT release is NOT affected. Can anyone test
this for me?


Cheers,


John V.





Reply With Quote
  #3  
Old   
Scott Ballinger
 
Posts: n/a

Default Re: SORTTAB Bug? (D3NT 7.1) - 06-29-2005 , 11:08 PM



Bill H wrote:
[snip]
Quote:
We use this feature often in our application. Lately, however, I've been
finding extraneous data loaded into our tab-delimited files. I believe this
has to do with the D3 "ZC" conversion code, especially with foreign
addresses. The same issue occurs on "LIST-LABEL" commands when using
foreign conversions.
I don't know at D3NT but there was a patch that fixed this problem in
D3linux 7.4.0 & 7.4.2. I too use sorttab (I call it sortt and listt) a
lot and encountered this problem, especially on large jobs.

Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006


Reply With Quote
  #4  
Old   
John V
 
Posts: n/a

Default Re: SORTTAB Bug? (D3NT 7.1) - 06-29-2005 , 11:35 PM



Thanks for the replies Bill & Scott.

I did a google groups search and it seems like this functionality is highly
volatile!

I think I'll go about what I am trying to achieve in a different manner to
avoid future hair loss.

Thanks again,


John.

"Scott Ballinger" <scott (AT) paretoTIRED-OF-SPAM (DOT) net> wrote

Quote:
Bill H wrote:
[snip]
We use this feature often in our application. Lately, however, I've
been
finding extraneous data loaded into our tab-delimited files. I believe
this
has to do with the D3 "ZC" conversion code, especially with foreign
addresses. The same issue occurs on "LIST-LABEL" commands when using
foreign conversions.

I don't know at D3NT but there was a patch that fixed this problem in
D3linux 7.4.0 & 7.4.2. I too use sorttab (I call it sortt and listt) a
lot and encountered this problem, especially on large jobs.

Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006



Reply With Quote
  #5  
Old   
Bill H
 
Posts: n/a

Default Re: SORTTAB Bug? (D3NT 7.1) - 07-04-2005 , 06:45 PM



John:

You might try "Download" from:

ftp.cedarville.edu

Go to the "Download" directory and download the newest release (probably
something like 7.1 or 7.2). You may be able to modify it for D3. I've seen
it work quite well in U2.

Bill

"John V" <johnv.invalid.chemform.com.au.z> wrote

Quote:
Thanks for the replies Bill & Scott.

I did a google groups search and it seems like this functionality is
highly
volatile!

I think I'll go about what I am trying to achieve in a different manner to
avoid future hair loss.

Thanks again,


John.

"Scott Ballinger" <scott (AT) paretoTIRED-OF-SPAM (DOT) net> wrote in message
news:E5ydnW5Glrt_8l7fRVn-tg (AT) seanet (DOT) com...
Bill H wrote:
[snip]
We use this feature often in our application. Lately, however, I've
been
finding extraneous data loaded into our tab-delimited files. I believe
this
has to do with the D3 "ZC" conversion code, especially with foreign
addresses. The same issue occurs on "LIST-LABEL" commands when using
foreign conversions.

I don't know at D3NT but there was a patch that fixed this problem in
D3linux 7.4.0 & 7.4.2. I too use sorttab (I call it sortt and listt) a
lot and encountered this problem, especially on large jobs.

Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006





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.