[U2] Assigning a disk device

2005-12-15 Thread Bill_H
I'm trying to build a T.LOAD and T.DUMP file.  Of course I can't manage such
a simple task.  :-)  I have UV PE v10.1.11 installed along with UniAdmin
v1.3.1.

I first used UniAdmin to create an "other" device, giving it a name of
"DiskBackup" and assigning it the path of "E:\Backups\DiskBackup" (it
actually created a file "E:\Backups\DiskBackup").  I then went to tcl and
executed the following:

ASSIGN DiskBackup TO MTU 0

thinking this would allow me to do the T.DUMP.  However, I simply received
the message:

"Error, cannot get tape device configuration (87)."

Looking at the &DEVICE& item showed:

 DiskBackup
0001 A disk backup file
0002 E:\Backups\UVBackups\DailySave
0003 
0004 S
0005
0006
0007 
0008
0009
0010
0011
0012
0013
0014
0015
0016 
0017
0018
0019
0020

After looking at the archives I changed the &DEVICE& to look like:

 DiskBackup
0001 A disk backup file
0002 E:\Backups\UVBackups\DailySave
0003 500
0004 S
0005
0006
0007 E:\Backups\UVBackups\DailySave
0008
0009
0010
0011
0012
0013
0014
0015
0016 500
0017
0018
0019
0020

I still keep receiving the same message:

"Error, cannot get tape device configuration (87)."

I've tried a number of variations but still get the error.  Does anyone know
what I failed to initially configure?

As always, thanks.

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


RE: [U2] Calling a subroutine on an MV field from an I-Descriptor

2005-12-13 Thread Bill_H
Thanks Rex.  I didn't quite give the entire BASIC program.  It is a
particular business rule that, in a D3 system, was shared by a variety of
BASIC programs and dictionaries.

Unlike U2, D3 uses one passed variable in the subroutine argument list where
the contents of the dictionary stack is automatically assigned this single
argument variable.  The BASIC code usually takes that value then does
whatever then reassigns the variable a new value to be returned.  When
processing returns to the dictionary the assigned variable is automatically
placed back into the dictionary stack.

I'm not sure I like one method over the other.  I just need to make
additional changes to business rule subroutines so they can be called from
both dictionaries and BASIC code.

Bill
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar
> Sent: Tuesday, December 13, 2005 10:45 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Calling a subroutine on an MV field from an 
> I-Descriptor
> 
> Bill,
> 
> If all you are trying to do is return a multi-valued "1" or 
> "0" string for a multi-valued list of id's, you can use this 
> in field 2 of your I-descriptor:
> 
> 0002: CATS(REUSE(@ID:"*"), @RECORD<35>) ; TRANS("ARTLEDGER", 
> @1, 0, "X") ; NES(@2, REUSE(""))
> 
> Note that @RECORD<35> can be replaced with the actual 
> dictionary name for field 35.
> 
> 
> rex
> ---
> 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] Calling a subroutine on an MV field from an I-Descriptor

2005-12-13 Thread Bill_H
Bruce & Ray:

Thanks.  I was frightened of this prospect.  Maybe U2 needs a 'SUBRS'
function.  

It's amazing how much illogic creeps into an environment to overcome
development issues, and never gets straightened out.  But then it could just
be me.  I'd have never thought I would want to manipulate an entire MV
attribute at once.  :-)

Thanks again.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
> Sent: Monday, December 12, 2005 8:54 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Calling a subroutine on an MV field from an 
> I-Descriptor
> 
> The subroutine needs to do a READ for each value in the 
> multi-valued argument passValue.
> 
> You could also do a TRANS() function, which has this loop 
> built in, within the routine.
> 
> Note that individual elements of a dynamic array 
> (multi-valued field) can be null, so your null test must be 
> inside the loop.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] seeking info about Mark Information Systems & their applications

2005-12-13 Thread Bill_H
Scott:

I know they were working on moving their application to the web, but don't
know if they got it done.  I believe they were down to just a few developers
and needed to keep expenses down. 

Bill
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Scott Richardson
> Sent: Monday, December 12, 2005 3:54 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] seeking info about Mark Information Systems & 
> their applications
> 
> I am looking for any information on what happened to a 
> company called Mark Information Systems out of Burlingame, 
> CA; their Distribution Software Package, and folks that used 
> to work there. I did some work with them in the late 80's & 
> early 90's, and am curious as to what happened to their 
> installed base, folks that worked there, etc I know that 
> owner George F passed on, but not sure about what happened to 
> the company after that?
> 
> Any information would be appreciated.
> 
> Please feel free to reply back channel...
> Thanks!
> 
> Regards,
> Scott Richardson
> ---
> 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] Calling a subroutine on an MV field from an I-Descriptor

2005-12-12 Thread Bill_H
I'm trying to call a subroutine for each value of an I-Descriptor, but
without much luck.  The subroutine looks like:

SUBROUTINE D.CURRDELITEM (RetValue, passValue)
COMMON /CURRDELITEM_variables/ ARTLEDGER.FV
InvId= TRIM(passValue)
RetValue = ''
IF NOT(ASSIGNED(ARTLEDGER.FV)) THEN
   OPEN '', 'ARTLEDGER' TO ARTLEDGER.FV ELSE RETURN
END
READ TrInvRec FROM ARTLEDGER.FV, InvId THEN
   RetValue = 1
END ELSE
*  RetValue = '0'
   RetValue = OCONV(InvId, 'MX')
END
RETURN
END

I have a file with multiple invoice#s in field# 35 (INVS):

   035 77]79]81]82]84]85]86]87]89

The key is "790*4/1".  An I-Descriptor named CURRDEL looks like:

   002 CATS(REUSE(@ID:'*'), @RECORD<35>)

gives me:

LIST ARTMASTER "790*4/1" INVS CURRDEL 06:03:34pm  12 Dec 2005  PAGE1
ARTMASTER... INVOICES DEL

790*4/177  790*4/1*77
   79  790*4/1*79
   81  790*4/1*81
   82  790*4/1*82
   84  790*4/1*84
   85  790*4/1*85
   86  790*4/1*86
   87  790*4/1*87
   89  790*4/1*89

1 records listed.

However, I want each key in the "DEL..." column to be passed to a program
named "D.CURRDELITEM", and all I get is:

   002 SUBR("D.CURRDELITEM", CATS(REUSE(@ID:'*'), @RECORD<35>))

LIST ARTMASTER "790*4/1" INVS CURRDEL 06:52:25pm  12 Dec 2005  PAGE1
ARTMASTER... INVOICES DEL

790*4/177 3739302A342F312
  A3737FD3739302A
  342F312A3739FD3
  739302A342F312A
  3831FD3739302A3
  42F312A3832FD37
  39302A342F312A3
  834FD3739302A34
  2F312A3835FD373
  9302A342F312A38
  36FD3739302A342
  F312A3837FD3739
  302A342F312A383
  9
   79
   81
   82
   84
   85
   86
   87
   89

1 records listed.

It looks like the subroutine was only called once and the entire string of
invoice keys was passed in at one time.  So, I know I haven't handled the
complete multi-value properly.

Can anyone help.  Thanks in advance.

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


RE: [U2] SOX question (United States only, I believe)

2005-12-09 Thread Bill_H
Allen:

Which makes one wonder why in the world security was pulled out of the dbms.
There's something illogical about an O/S administrator knowing better how to
set up security in the application than the application vendor.

Bill 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Allen E. Elwood
> Sent: Friday, December 09, 2005 11:38 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] SOX question (United States only, I believe)
> 
> The thing that always cracks me up is that all one has to do 
> in a U2/PICK environment is to create q pointers to the main 
> account from the test account.  You can look and even modify 
> without having access to that account unless it is locked 
> down by logon at the OS level, which I have yet to find and 
> as a consultant I have worked on several 'sox compliant' boxes.

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


RE: [U2] VOC pointer replaced

2005-12-06 Thread Bill_H
Thanks to all who replied.

Bruce: ED gets the same response
  Welcome to the IBM UniVerse Telnet Server.
  Enter user name: wphaskett
  Enter password:
  Account name or path(DTA):DTAWEB
  UniVerse Command Language 10.1
  (c) Copyright IBM Corporation 2003. All rights reserved.
  DTAWEB logged on: Tue Dec 06 11:35:04 2005
  
  Unable to open your 'VOC' file.
  >ED VOC VOC
  Unable to open VOC file.
  >

Ray:  A; the ticket.  :-)  SETFILE VOC VOC OVERWRITING.

John:  Of course, I should have thought of that.

Wouldn't one think it appropriate to disallow altering file pointers, unless
explicitly requested via an option of ED or something else?  Oh well, live
and learn and be careful.

Bill Haskett
Advantos Systems, Inc.
www.advantos.net 
(760)944-5570 (CA)
(360)923-4838 (WA)
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol
> Sent: Monday, December 05, 2005 5:34 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] VOC pointer replaced
> 
> Goo'day, Bill,
> 
> At 16:10 05/12/05 -0800, you wrote:
> 
> >I was working on upgrading an account to the most recent version of 
> >UniVerse PE.  When coping a list of custom VOC items, from a custom 
> >NEWAC file, to the local VOC (with an overwrite) it happened 
> one of the 
> >item IDs was "VOC", which was a Pick synonym for the (MD):
> >
> >001 Q
> >.
> >.
> >009 L
> >010 12
> >
> >It seems now I continually get the message:
> > >LU
> >
> >These are the UniVerse users presently sharing the system.
> >
> > uid  User No  User Name Terminal No 
>  Login Time
> >   0 2820  NT AUTHORITY\system   uvdlock:2820
>  Nov 25 17:49
> >* 0 5508  ASIBILL\wphaskett telnet:5508  
> Dec 5 10:56
> >
> >There are currently 2 users logged on the system.
> > >CT VOC VOC
> >Can not open the "VOC" file
> > >LISTF
> >Can not open the "VOC" file
> >
> >Is there a way I can modify the "VOC" item back.  I can 
> still see the 
> >file exists in Windows Explorer.
> 
> Does this help?
> 
>  >CT VOC VOC
> 
>   VOC
> 0001 F
> 0002 VOC
> 0003 D_VOC
>  >
> 
> >Any help would be appreciated.  :-)
> 
> Use ED?
> 
> 
> >Bill
> >---
> >u2-users mailing list
> >u2-users@listserver.u2ug.org
> >To unsubscribe please visit http://listserver.u2ug.org/
> >
> >
> >
> >--
> >No virus found in this incoming message.
> >Checked by AVG Anti-Virus.
> >Version: 7.1.371 / Virus Database: 267.13.12/192 - Release Date: 
> >05/12/05
> 
> 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.371 / Virus Database: 267.13.12/192 - Release 
> Date: 05/12/05
> ---
> 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] VOC pointer replaced

2005-12-05 Thread Bill_H
I was working on upgrading an account to the most recent version of UniVerse
PE.  When coping a list of custom VOC items, from a custom NEWAC file, to
the local VOC (with an overwrite) it happened one of the item IDs was "VOC",
which was a Pick synonym for the (MD):

001 Q
.
.
009 L
010 12

It seems now I continually get the message:
>LU

These are the UniVerse users presently sharing the system.

uid  User No  User Name Terminal No  Login Time
  0 2820  NT AUTHORITY\system   uvdlock:2820 Nov 25 17:49
* 0 5508  ASIBILL\wphaskett telnet:5508  Dec 5 10:56

There are currently 2 users logged on the system.
>CT VOC VOC
Can not open the "VOC" file
>LISTF
Can not open the "VOC" file

Is there a way I can modify the "VOC" item back.  I can still see the file
exists in Windows Explorer.

Any help would be appreciated.  :-)

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


RE: [U2] Associated MVs

2005-12-01 Thread Bill_H
Thanks Mats.  Actually I simply changed the association in the dictionaries
to be:

Dictionary List: DICT CHANGES  Prepared on: 07:03:38am  01 Dec 2005
Dict Name.. Type # Col-Heading Field-Definition. Conversion.. Format
Assoc...

ADATE   D4 ACTDATE   D2   9R
M AS_4
ACTIONS D7 ACTIONS TAKEN  63T
M AS_4
BYS D8 ACTIONS BYTUSERS;C;;1  20L
M AS_4
OACTIONSI  ACTIONS TAKEN   @RECORD<7> 30T
M AS_4 (from AS_4A)

and left the phrases alone.  This is a bit counter-intuitive though.  It's
as though there's no fixed relationship between attribute 7 and the phrase.
In fact, I changed the dictionaries to be:

Dictionary List: DICT CHANGES  Prepared on: 07:43:03am  01 Dec 2005
Dict Name.. Type # Col-Heading Field-Def Conversion.. Format
Assoc.

ADATE   D4 ACTDATE   D2   9R M X
ACTIONS D7 ACTIONS TAKEN  63TM X
BYS D8 ACTIONS BYTUSERS;C;;1  20LM X
OACTIONSI  ACTIONS TAKEN   @RECORD<7> 30TM X

and left the phrases alone as (no 'X' phrase)   :

Dictionary List: DICT CHANGES  Prepared on: 07:38:30am  01 Dec 200
Dict Name.. Type # Col-Heading Field-Definition...
AS_4PH ADATE ACTIONS BYS
AS_4A   PH ADATE OACTIONS BYS

This is the result of the query:

>LIST CHANGES '131081' DESC AS_4 AS_4A

CHANGES 131081
DESCRIPTION OF REQUEST. Allow moving an UNAPPLY amount
from one unit to another
within a client.  Also allow
the ability to refund any or
all of the UNAPPLY amount.
ACTDATE.. ACTIONS TAKEN..
ACTIONS BY..
20 NOV 03 + Modified the T/R adjustment program to allow an UNAPPLY to
wph
  be 'applied to--:' anywhere including another unit and refund.
24 NOV 03 + Modified the T/R adjustment program to allow an UNAPPLY to
wph
  be refunded, using the new subroutines built for use by the 
  T/R Invoice program.
ACTDATE.. ACTIONS TAKEN. ACTIONS BY..
20 NOV 03 + Modified the T/R adjustment  wph
  program to allow an UNAPPLY to
  be 'applied to--:' anywhere
  including another unit and
  refund.
24 NOV 03 + Modified the T/R adjustment  wph
  program to allow an UNAPPLY to
  be refunded, using the new
  subroutines built for use by
  the T/R Invoice program.

Martin: The ACTIONS and OACTIONS are synonyms for the same field, so
presently ADATE(4) would have a C;8;7 in it while ACTIONS(7), OACTIONS(7),
and BYS(8) would have a D;4 in it.  This is one of the painful (and oldest)
nuisances with the U2 products, where multiple dictionaries need to be
created for different output scenarios.

Thanks again,

Bill


> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Martin Phillips
> Sent: Thursday, December 01, 2005 2:19 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Associated MVs
> 
> Hi Bill,
> 
> > Is it possible to assocate the same dictionary item (field 
> definition) 
> > to more than one association phrase?  I'm doing some 
> conversion work 
> > and
> there
> > are several associations that include some of the same dictionaries.
> 
> How can this ever be necessary?  If item A has a value by 
> value relationship with item B and item B is similarly 
> related to item C, what situation can exist where the values 
> of A and C are not related in this same way?
> 
> 
> Martin Phillips
> Ladybridge Systems
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
> +44-(0)1604-709200
> ---
> 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] Associated MVs

2005-11-30 Thread Bill_H
Is it possible to assocate the same dictionary item (field definition) to
more than one association phrase?  I'm doing some conversion work and there
are several associations that include some of the same dictionaries.

For example, the following association phrases were created:

Dict Name... Type # Col-Heading Field-Definition

AS_10PH IMPDATE IMPVERSION

AS_4 PH ADATE ACTIONS BYS

AS_4APH ADATE OACTIONS BYS

In a Pick style dictionary this is no problem with the "[D]ependent and
[C]ontrolling association codes.  But I can't figure out how to do it here
without creating two new synonym dictionaries for both 'ADATE' and 'BYS'.

Thanks,

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


RE: [U2] Restoring a D3 ACCOUNT-SAVE to Universe (NT)

2005-11-14 Thread Bill_H
Ron:

If you contact me directly, I can send you an attached a Word document that
helps.

Bill Haskett
Advantos Systems, Inc.
www.advantos.net 
(760)944-5570 (CA)
(360)923-4838 (WA)
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Ron White
> Sent: Monday, November 14, 2005 2:36 PM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Restoring a D3 ACCOUNT-SAVE to Universe (NT)
> 
> It seems there was a discussion about restoring D3 
> accout-saves to UniVerse not long ago but I am unable to find 
> the thread in the archives.
> 
> If anyone knows how this is done I would appreciate an assist.
> 
> Thanks,
> Ron White
> ---
> 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] [UV] PRINT @(-23)

2005-11-02 Thread Bill_H
Dianne:

The next step would be to look at the term-type, to make sure the
appropriate control codes are called, then the term-type item itself to make
sure the appropriate control codes are in the terminfo file.

Of course you should ensure the terminal is complied properly with "uvtic".

Hope this helps.

Bill
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Dianne Ackerman
> Sent: Wednesday, November 02, 2005 6:23 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] [UV] PRINT @(-23)
> 
> Using Accuterm.  The printer is fine because when I'm 
> attached to other clients' sites it all works fine.
> -Dianne
> 
> Bill_H wrote:
> 
> >Dianne:
> >
> >What client software are you using?  wIntegrate?  If so, check with 
> >File > Printer Setup.  Make sure a valid Windows printer is 
> selected, 
> >or one that works with U2.
> >
> >Hope this helps.
> >
> >Bill
> > 
> >
> >  
> >
> >>-Original Message-
> >>From: [EMAIL PROTECTED]
> >>[mailto:[EMAIL PROTECTED] On Behalf Of Dianne 
> >>Ackerman
> >>Sent: Tuesday, November 01, 2005 12:24 PM
> >>To: U2 List Server
> >>Subject: [U2] [UV] PRINT @(-23)
> >>
> >>I have a program which does a PRINT @(-23) at the beginning and a 
> >>PRINT
> >>@(-24) at the end so that all the information prints on the aux 
> >>printer.  Works great, but when running at one particular 
> client site, 
> >>I get all kinds of weird characters printing on the 
> document, at the 
> >>beginning and end of each line.  Fine at any other site, but just a 
> >>problem when connected to this one client.  Does anyone 
> have an idea 
> >>where I can look?
> >>Thanks!
> >>-Dianne
> ---
> 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] [UV] PRINT @(-23)

2005-11-01 Thread Bill_H
Dianne:

What client software are you using?  wIntegrate?  If so, check with File >
Printer Setup.  Make sure a valid Windows printer is selected, or one that
works with U2.

Hope this helps.

Bill
 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Dianne Ackerman
> Sent: Tuesday, November 01, 2005 12:24 PM
> To: U2 List Server
> Subject: [U2] [UV] PRINT @(-23)
> 
> I have a program which does a PRINT @(-23) at the beginning 
> and a PRINT
> @(-24) at the end so that all the information prints on the 
> aux printer.  Works great, but when running at one particular 
> client site, I get all kinds of weird characters printing on 
> the document, at the beginning and end of each line.  Fine at 
> any other site, but just a problem when connected to this one 
> client.  Does anyone have an idea where I can look?
> Thanks!
> -Dianne
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Week of the year (UV)

2005-10-28 Thread Bill_H
Wol:

As Kevin alluded to earlier, the program, and the consequences you point
out, are exactly what the client wanted.  So much for standards.  :-)

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Sent: Friday, October 28, 2005 5:57 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Week of the year (UV)
> 
> [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] wrote:
> > > ** A week is defined as a seven-day period running from 
> Monday-Sunday.
> > > ** Week 1 of any year is defined as the first week 
> containing four 
> > > days
> > > ** of the year, or equivalently the week containing the first 
> > > Wednesday
> > > ** of the year. For example, if January 1 falls on a Friday, then 
> > > the
> > > ** first two days of January fall in week 53 of the 
> preceding year.
> > > **
> > BIG BIG WHOOPS 
> > 
> > It's Thursday, not Wednesday. Let's take the case of "Wed, 
> 31 Dec". Your wednesday rule makes it week 53. But 
> Thu,Fri,Sat,Sun are all in the following year, ie 4 days, ie 
> a majority, which makes it ISO week 1.
> > 
> There's now a function available in the Basic Code area of 
> PickWiki that will do this for you.
> 
> Cheers,
> Wol
> ---
> 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] Week of the year (UV)

2005-10-27 Thread Bill_H
Kevin:

Sorry, I wasn't implying anything other than there is somewhere where some
have answered those questions.  But you know how stardards are; everyone has
one.  :-)

Bill 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
> Sent: Thursday, October 27, 2005 2:11 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Week of the year (UV)
> 
> Certainly the standard is applicable but only if the client 
> is concerned about the definition of "week" according to ISO 
> 8601.  Some might, some might not.  I was simply sharing some 
> of the issues that have come up in the projects I've had for 
> calculating the week number, of which I have had three 
> projects for three different customers with three different 
> definitions, and the only standard that mattered in any of 
> these projects was the standard defined by the customer 
> according to their own business rules, of which zero were 
> compliant with anything but themselves.
> 
> -Kevin
> [EMAIL PROTECTED]
> http://www.PrecisOnline.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] Week of the year (UV)

2005-10-27 Thread Bill_H
Kevin:

Try looking in Google for "ISO 8601 week".  It may help answer some of your
questions.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
> Sent: Thursday, October 27, 2005 12:38 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Week of the year (UV)
> 
> Barry is right, the definition of "year" (beit "fiscal", 
> "calendar" or some variant thereof) is one of several 
> important facets of the problem  that must be defined before 
> formulating a solution.  For some companies, January 1st is 
> actually part of the last (52nd or 53rd) calendar week of the 
> previous year, and the actual calendar week 1 could start on 
> the Monday, such as this year with 1/3/2005.
> 
> Some questions to consider: 
> 
> * What day is considered the first day of the year?  (Not 
> always January 1, particularly if talking a fiscal calendar.)
> 
> * What day is considered the first day of a given week? Wall 
> calendars may show Sunday as the first day of the week, but 
> for each unique company it could be Monday (first working 
> day), Friday (last working day), Saturday (last working day), 
> or really any other day.
> 
> * When in a 53 week year, is the 53rd week really considered 
> a 53rd week, or should it be an extended period on the 52nd 
> week?  Keep in mind that it may be possible to have a 53 week 
> year without a leap year based on the answers to the previous 
> questions and depending on what weekday the first of the year 
> shows up on.
> 
> These are just some considerations I've faced when writing 
> code for this week number calculation.  Your individual 
> results may vary.
> 
> -Kevin
> [EMAIL PROTECTED]
> http://www.PrecisOnline.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] Week of the year (UV)

2005-10-27 Thread Bill_H
Barry:

This is what I use to meet the ISO

Bill

SUBROUTINE WEEKNO (DateIn, WeekOut)
**
** Notes:
**
** Passed Variables:
**DateIn   :  Internal date representing week number desired
**WeekOut  :  ISO 8601-formatted Week Number:
**
** ISO 8601 prescribes a format Wnn, where nn is the ordinal week
** number in the year, and the rule is that week 01 in a year is the
** first week that contains four calendar dates in that year.
**
** A week is defined as a seven-day period running from Monday-Sunday.
** Week 1 of any year is defined as the first week containing four days
** of the year, or equivalently the week containing the first Wednesday
** of the year. For example, if January 1 falls on a Friday, then the
** first two days of January fall in week 53 of the preceding year.
**
** To allow for this possibility, this subroutine starts by computing
** the internal date for the Wednesday of the week containing the input
** date. A simple calculation from this gives the correct year number
** and week number for the tag.
!
** Start program run
!
** Calculate the closest Wednesday to the input date.  We're using a
** Sunday thru Saturday work week.
DayOfWeek = Mod(DateIn, 7)
WEDNESDAY = DateIn - DayOfWeek + 3
*
** Convert Wednesday's date to week number.
WeekNo = Int((OCONV(WEDNESDAY, 'DJ') - 1)/ 7) + 1
*
** Assemble the Wnn format.
WeekOut = OCONV(WEDNESDAY, 'DY') : "W" : WeekNo "R(%2)"
*
****
****
**  E N D   O F   P R O G R A M   **
****
****
*
RETURN
END 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik
> Sent: Thursday, October 27, 2005 11:42 AM
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] Week of the year (UV)
> 
> If I understand the question properly, I believe this will do it:
>  
>   PRINT INT(OCONV(DATE(),'DJ')/7) +
> OCONV((OCONV(DATE(),'DJ')/7:'')['.',2,1],"S;'1';'0'")
>  
> ...but be aware that even though we think of a year as having 
> 52 weeks, and a week is 7 days, 7 * 52 = 364. As far as I 
> know, a year always has 365 days unless it is a leap year 
> with 366 days.
> 
> Therefore, the above algorithm will return 53 for the last 
> day of the year, or for the last 2 days if it is a leap year.
> 
> Also, above algorithm might be totally useless if you are 
> talking about your company's FISCAL year, whatever it is 
> defined to be.
> 
> Barry Brevik
> ---
> 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] Date Conversion Codes

2005-10-12 Thread Bill_H
A Pick-style solution would be:

TEST
001 S
002 3
003 Long Date
004
005
006
007 A3(DWA):', ':3(DMA)(T1,3):' ':3(DD):', ':3(DY)
008
009 R
010 23

Hope this helps.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Rick Ward
> Sent: Wednesday, October 12, 2005 11:54 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Date Conversion Codes
> 
> I'm trying to output a nicely formatted date (eg, Wednesday, 
> Oct 12, 2005), and I've tried doing it via date conversion 
> codes in dictionary field 7. I can get individual elements 
> (like Wednesday) or simplified date formats (10-12-2005), but 
> I haven't been able to figure out how to string them 
> together. The UniVerse documentation has been less than 
> helpful with this matter.
> 
> I'd appreciate any suggestions.
> 
> Regards,
> 
> Rick
> 
> 
>   
> __
> Yahoo! Music Unlimited
> Access over 1 million songs. Try it free.
> http://music.yahoo.com/unlimited/
> ---
> 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] Basic vs Execute Select

2005-10-12 Thread Bill_H
Mark:

Do you mean "accounted for"?

Bill 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Wednesday, October 12, 2005 7:58 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Basic vs Execute Select
> 
> You're kidding. I requested 'counted for', not counted.
> 
> The earlier SELECT thread brought up the concept of records 
> added during the processing. Thus, how could you insure that 
> all records were processed, even those latecomers.
> 
> Mark Johnson
> - Original Message -
> From: "Ralph Burton" <[EMAIL PROTECTED]>
> To: 
> Sent: Tuesday, October 11, 2005 1:32 PM
> Subject: 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 Johnson
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> >
> >
> > -
> >  Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
> > ---
> > 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] help with multivalue and when

2005-10-11 Thread Bill_H
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 Of Jeff Powell
> Sent: Tuesday, October 11, 2005 6:02 AM
> To: u2 users group
> Subject: [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 within that record there is an activity 
> log stored in multivalued fields.
> 
> My desire is to construct (using uniobjects for java) a list 
> command that returns a list of ids where the transaction 
> matches. In this case I want to see only those records where 
> action = PCK and act.date = (today). 
> 
> Here is my query:
> "list order-log when action="pck" and when 
> act.date="10/11/05" id.supp hdr.supp col.hdr.supp count.sup 
> @id fmt "132l""
> 
> What I get as a result of this is a record where there is a 
> action of PCK and there is a act.date of 10/11/05 but these 
> are not the record.
> 
> Here is sample of one of those records.
> 
> LIST ORDER-LOG "100TU093370" ACTION ACT.DATE ACT.TIME REF.NUM 
> 07:44:50 Oct 11 2005 1 ORDER-LOG. Code Act Date  Time Reference Number
> 
> 100TU09337 C09/09/05 10:37 CALL IN ORDER
> 0
>FUT  09/13/05 18:17 D3660RFBLMSS
>FUT  09/19/05 18:16 D2.5X18STUD
>FUT  09/21/05 18:37 D3660NASBRGMSS
>FUT  09/21/05 18:37 TDW3660BLKIT
>ALC  10/03/05 09:41 TDW3660BLKIT
>PCK  10/04/05 09:23 TU093370-1  Whse TUL
>SAV  10/11/05 06:52 TU093370-1 No Update Through RCE
>PAK  10/11/05 06:52 TU093370-1
> 1 record listed
> 
> As you can see the PCK occurred on 10/04 and the SAV occurred 
> on 10/11.
> I need a list of records where there is a PCK on 10/11.
> 
> Any suggestions?
> 
> Thanks.
> 
> Jeff
> ---
> 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] Good Programming Practice - Axiom - ........

2005-09-30 Thread Bill_H
Garry:


> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Sent: Friday, September 30, 2005 1:18 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice - Axiom - 
> 
> Nobody cares what anyone has to say

I do.

> .. everyone is going to do whatever they have always done.

I won't.

> Subordinates are going to follow whatever standards are 
> dictated by their supervisor.

Probably a good policy.

:-)

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


RE: [U2] Embedding JPG/GIF

2005-09-29 Thread Bill_H
Karl:

Have the signature sent to http://www.elfring.com/signatur.htm and they will
convert it to a PCL font for about $75 and return it to you along with a
couple of DOS scripts that will download the font to the printer on some
media you request.

Well worth the trouble, believe me.  :-)

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Sent: Thursday, September 29, 2005 1:48 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Embedding JPG/GIF
> 
> Yes, welcome to the 21st century... At least part of it. 
> We're hanging onto our green-screen app because it just ain't broke.
> 
> The 2 responses are great. Thanks for contributing these. Now 
> to figure out how to convert the yet-to-be-scanned signature 
> from the appropriate image format to PCL5.
> 
> That begs the question, anyone out there (or you, Bill) care 
> to contribute enough information to me that I don't have to 
> do any more work than I have to?  8^}  I'm running a Linux 
> workstation and will be checking out the ps2pdf-like 
> utilities that abound on this marvelously techy-geek friendly 
> platform.
> 
> Karl
> 
> 
> > Karl:
> >
> > I'm guessing you're replacing the 20th century equipment with 21st 
> > century complexity.  :-)
> >
> > I believe the simplest option is to get the signature you 
> need in PCL5 
> > format.  This font can then be downloaded to the HP4200 and 
> assigned a 
> > font# (say 99).  Then in your check printing routine locate the HP 
> > cursor to the appropriate location on the check, set the 
> font to font# 
> > 99 (see above), then print the text string "ABC", since the font is 
> > usually defined as A=first name, B=middle initial, and C=last name 
> > (maybe there's a D=Jr, II, etc).  Once this is done, reset the font 
> > back to the appropriate font to continue printing.
> >
> > This should do the trick.
> >
> > Bill
> >
> >> -Original Message-
> >> From: [EMAIL PROTECTED]
> >> [mailto:[EMAIL PROTECTED] On Behalf Of 
> >> [EMAIL PROTECTED]
> >> Sent: Thursday, September 29, 2005 11:08 AM
> >> To: u2-users@listserver.u2ug.org
> >> Subject: [U2] Embedding JPG/GIF
> >>
> >> We are currently printing checks to an Okidata printer with 
> >> tractor-fed 3-part NCR pre-printed checks. We are going to get a 
> >> 2-tray HP4200TN so detail can be printed to a blank page 
> in tray 2. 
> >> We have an old check signing machine that requires tractor-fed 
> >> checks.
> >>
> >> I would like to scan in the authorized signature currently 
> printed by 
> >> the signing machine so it can be printed on the checks by uniVerse 
> >> [mv]BASIC.
> >>
> >> Can we embed the scanned signature using mvBASIC? How would we go 
> >> about it? Any ideas welcome.
> >>
> >> TIA,
> >>
> >> --
> >> karl
> >>
> >>  _/  _/  _/  _/_/_/      __o
> >> _/ _/   _/  _/_/   _-\<._
> >>_/_/_/  _/_/_/ (_)/ (_)
> >>   _/ _/   _/  _/   ..
> >>  _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]
> >>
> >> --
> >> IT Director, ATS Industrial Supply, Inc.
> >> http://www.atsindustrial.com
> >> Toll-free: 800-789-9300 x29
> >> Direct2Desk: 801-978-4429
> >> Facsimile: 801-972-3888
> >> --
> >> ---
> >> 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/
> >
> 
> 
> --
> karl
> 
>  _/  _/  _/  _/_/_/      __o
> _/ _/   _/  _/_/   _-\<._
>_/_/_/  _/_/_/ (_)/ (_)
>   _/ _/   _/  _/   ..
>  _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]
> 
> --
> IT Director, ATS Industrial Supply, Inc.
> http://www.atsindustrial.com
> Toll-free: 800-789-9300 x29
> Direct2Desk: 801-978-4429
> Facsimile: 801-972-3888
> --
> ---
> 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] Embedding JPG/GIF

2005-09-29 Thread Bill_H
Karl:

I'm guessing you're replacing the 20th century equipment with 21st century
complexity.  :-)

I believe the simplest option is to get the signature you need in PCL5
format.  This font can then be downloaded to the HP4200 and assigned a font#
(say 99).  Then in your check printing routine locate the HP cursor to the
appropriate location on the check, set the font to font# 99 (see above),
then print the text string "ABC", since the font is usually defined as
A=first name, B=middle initial, and C=last name (maybe there's a D=Jr, II,
etc).  Once this is done, reset the font back to the appropriate font to
continue printing.

This should do the trick.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Sent: Thursday, September 29, 2005 11:08 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Embedding JPG/GIF
> 
> We are currently printing checks to an Okidata printer with 
> tractor-fed 3-part NCR pre-printed checks. We are going to 
> get a 2-tray HP4200TN so detail can be printed to a blank 
> page in tray 2. We have an old check signing machine that 
> requires tractor-fed checks.
> 
> I would like to scan in the authorized signature currently 
> printed by the signing machine so it can be printed on the 
> checks by uniVerse [mv]BASIC.
> 
> Can we embed the scanned signature using mvBASIC? How would 
> we go about it? Any ideas welcome.
> 
> TIA,
> 
> --
> karl
> 
>  _/  _/  _/  _/_/_/      __o
> _/ _/   _/  _/_/   _-\<._
>_/_/_/  _/_/_/ (_)/ (_)
>   _/ _/   _/  _/   ..
>  _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]
> 
> --
> IT Director, ATS Industrial Supply, Inc.
> http://www.atsindustrial.com
> Toll-free: 800-789-9300 x29
> Direct2Desk: 801-978-4429
> Facsimile: 801-972-3888
> --
> ---
> 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] Good Programming Practice Question.........

2005-09-28 Thread Bill_H
Paul:

This brings up an interesting point.  Why not keep information such as this
in the database where, one might properly argue, it belongs?

For years I did this but it dawned on me I couldn't slice and dice anything.
As a result I simply created a single "change" file with about ten
attributes.  Then all my change descriptions, change dates, purpose of
changes, who made changes, programs and processes changed, etc are placed in
this one file.  Now I can easily produce an "Enhancement and Resolutions"
report with all changes. The code simply contains the original creation
date, the data last changed, and the people responsible for each.  The
record key of the "changes" file is the date and time.

Once this is accomplished I can create a wrapper around the editor and/or a
trigger on the program file (depending on a slew of issues).

In addition, I can link the "changes" to local O/S files that contain
project documents, and other such helpful documents.

Just a thought.  :-)

bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien
> Sent: Wednesday, September 28, 2005 8:35 AM
> To: 'u2-users@listserver.u2ug.org'
> Subject: RE: [U2] Good Programming Practice Question.
> 
> Regarding the origin and revisions to software, DataFlo 
> programmers pretty much have followed the policy where you 
> try to flag all revisions in the software using the following 
> convention:
> * Baseline changes use just a rev#, for example rev 01
> * DataWorks use a rev# starting with a C, for example REV C1
> * Custom & Customer Programmers using a rev# starting with Z, 
> for example REV Z1
> 
>   Here is an excerpt illustrating this from a heavily 
> modified program (from one of my customers):
> 
> 0015: * D/W CUSTOM REVISIONS
> *
> 0016: ** Z5,04-20-04,KT-22,pault: Print SURCHARGE in footing 
> instead of CUR.
> 0017: ** Z4,03-15-02,KORE,EWY: Display NET xxx DAYS
> 0018: ** Z3,01-03-02,KT-3024,CWV: Add copper credit to output
> 0019: ** Z2,04-24-00,KT2002,CWV: Remove REV 22, ALLOW ZERO 
> DOLLAR INVOICE PRINT
> 0020: ** Z1,04-10-00,KT2001,CWV: Identify if report or proc
> 0021: ** 1C,03-05-99,39705,GEH: Added custom MFG PART number print
> 0022:  R E V I S I O N S
> *
> 0023: ** 24,12-17-98,APP-079,EMW: Change dates to 4-digit year.
> 0024: ** 23,04-07-99,AR-1103,ABC: Print total with 2 decimal places.
> 
> 0048: ** 00,09-11-95,AR-825,MLP: Rewrite at Rev 2.
> 
> and the revisions are flagged like so:
> 
> 0084: * REV 1C
> 0085:  READV MFGPART.FLG FROM F.TABLE,"PRT-CUST-PART",2 ELSE
> MFGPART.FLG="N"
> 0086: * END REV 1C
> 
> 0096:ZERO.LI="" ;  * REV 4
> 
> 0158: * REV 7  Assign DTL ""
> 0159:DTL = ""
> 0160: * END REV 7
> 
> 0938: * REV Z5
> 0939: *WORKVAR=WORKVAR:DISCPCT"R#6":" CUR"
> 0940:  WORKVAR=WORKVAR:DISCPCT"R#6":"  SURCHARGE"
> 0941: * END REV Z5
> 
> Note:
> * Revving your work this way usually makes it fairly easy 
> to see what
> was added (REV 1C and REV 7) and what was changed (REV Z5).
> * Usually the baseline revisions are removed in a major software
> release - only in the baseline software.
> * When we 'upgrade' the software for a customer, for customized
> software components (i.e. Programs, Procs, Reports), we merge 
> the baseline revisions into the customized software or visa 
> versa (easier route).  Using comparison tools the differences 
> in the software component is pretty easy to find and usually 
> pretty clear as to what to change.
> 
> Have a Great Day!
> 
> > Paul Trebbien
> > Kore Technologies, Senior Support Tech. 
> > "Solutions that work. People who care."
> > V 858.678.0030 F 858.300.2600 W koretech.com
> > 
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Marilyn Hilb
> Sent: Wednesday, September 28, 2005 7:48 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> 
> Two items I have thought of.
> 
> 1. In addition to putting a modification tag at the top of 
> the code with who/date/what, we also will assign a job number 
> to the mod in addition to a No for the mod. Such as mod 01. 
> Then throughout the code where the changes are made we put a 
> tag such as *<<01>> start  and *<<01>> end or, just a single 
> tag at the end of the line if only one or two lines being changed.
> This makes the changes very easy to search for and spot 
> should there be problems in the new code.
> 2. Consider when to use a paragraph and when to use a 
> program. Paragraphs
> (proc) certainly has their uses, but when the paragraph gets 
> to using IF, Case, locate, etc seems time to use a program.  
> For two reasons. One being while paragraphs (at least in SB+) 
> can do a lot, getting it to do everything a program can do 
> can be difficult. If you have an involved paragraph, sooner 
> or later y

RE: [U2] Good Programming Practice Question.........

2005-09-27 Thread Bill_H
Kevin:

Yes.  For example:

GOSUB INIT.GLOBAL
GOSUB INIT.LOCAL
GOSUB OPEN.FILES
GOSUB GET.CONFIG
.
LOOP
   READNEXT ID ELSE EXIT
   GOSUB READ.DATA
   GOSUB UPDATE.DATA
   GOSUB WRITE.DATA
REPEAT
GOTO END.OF.PROGRAM
.
***
GET.CONFIG:
***
.
RETURN
*
***
INIT.GLOBAL:
***
.
RETURN
*
***
INIT.LOCAL:
***
.
RETURN
*
***
OPEN.FILES:
***
.
RETURN
*
***
READ.DATA:
***
.
RETURN
*
***
UPDATE.DATA:
***
.
RETURN
*
***
WRITE.DATA:
***
.
RETURN
*
***
END.OF.PROGRAM:
***
RETURN (If Subroutine)
END

Hope I didn't create confusion.  :-)

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
> Sent: Tuesday, September 27, 2005 1:51 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> "alphabetize" the labels?  You mean "sort"?? :-)
> 
> -K 
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Bill_H
> Sent: Tuesday, September 27, 2005 1:35 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> Kevin:
> 
> Not if you alphabetize the labels; then it works just like numeric.
> :-)
> 
> Bill
> ---
> 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] Good Programming Practice Question.........

2005-09-27 Thread Bill_H
Kevin:

Not if you alphabetize the labels; then it works just like numeric.  :-)

Bill 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
> Sent: Tuesday, September 27, 2005 1:04 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> And here's where the conflict begins.  When looking through a 
> big program, I much prefer numeric labels in order with comments vs.
> alphanumeric labels.  With numeric labels in order you find 
> 1800 and if you're looking for 2000 you know to look farther 
> down, 1000, go up.
> With alpha labels if you find SELECT.FILE and are looking for 
> UPDATE.FILES, you have nothing but experience to know whether 
> to look up or down from there.
> 
> Numeric labels are good.  Not ordering or commenting them is 
> bad.  And not putting comments around all labels to make them 
> more easily distinguished from the rest of the program is 
> near unforgiveable.
> 
> -K 
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Allen E.
> Elwood
> Sent: Tuesday, September 27, 2005 12:40 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> My addition to this would be to use alphanumeric labels, and 
> to *have* a main calling section.  A main calling section 
> that looks like:
> 
> GOSUB OPEN.AND.INIT
> GOSUB SELECT.FILE
> GOSUB PRE-PROCESS.VALIDITY.CHECKS
> GOSUB PRINT.INVOICES
> GOSUB UPDATE.FILES
> 
> Looks so much better and is so easier to figure out than
> 
> GOSUB 100
> a bunch of statements
> a bunch of statements
> a bunch of statements
> GOSUB 1250
> a bunch of statements
> a bunch of statements
> a bunch of statements
> GOSUB 1375
> a bunch of statements
> a bunch of statements
> a bunch of statements
> GOSUB 4000
> a bunch of statements
> a bunch of statements
> a bunch of statements
> GOSUB 9755
> a bunch of statements
> a bunch of statements
> a bunch of statements
> 
> IMNSHO - *=aee=*
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of George Gallen
> Sent: Tuesday, September 27, 2005 12:12
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Good Programming Practice Question.
> 
> 
> Also, how about a change log at the top of the program
>   that lists, who, when and what/why a change was made.
> 
> add to that a short description as to what the function
>   of the program is for.
> 
> * this program does .
> *
> *
> * date who changes made
> * date who changes made
> 
> *
> 
> George
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of 
> Dianne Ackerman
> Sent: Tuesday, September 27, 2005 2:57 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Good Programming Practice Question.
> 
> 
> I like these and would add another one - Add comments to 
> tricky-looking code!
> -Dianne
> 
> David A. Green wrote:
> ---
> 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/
> 
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.11.7/112 - Release Date:
> 9/26/2005
> ---
> 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] Unusual problem w/Dynamic Connect 'speed'

2005-09-09 Thread Bill_H
Joe:

Now there's a waste of time.  Each of these stinking pieces of software is a
little different and acts a little different.  The thing to remember here is
to always check anti-virus/whatever or firewall software on local machines
as being the cause of network problems.  Then when you go on to other
possibilities and can't figure out what in the world is happening, return to
this cause every couple of hours.  :-) 

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 

[snipped]

> Shutdown ZoneAlarm and DC response is excellent.
> 
> So, now I wonder WHY - what is it about ZoneAlarm and/or 
> other firewall software that might cause this degredation in 
> performance of DC? 
> 
> joe
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of 
> > [EMAIL PROTECTED]
> > Sent: Thursday, September 08, 2005 11:34 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: RE: [U2] Unusual problem w/Dynamic Connect 'speed'
> > 
> > These may be way off-base here but:
> > 
> > 1. Does the emulation you are using change the response time? 
> > e.g. if you switch from say vt100 to wyse60?
> > 2. What is the network traffic like? Could DC be packeting up the 
> > telnet stuff differently than windows telnet? (AFAIR that 
> is part of 
> > the telnet negotiation).
> > 3. What is the performance of the server like? Are they running a 
> > screen saver? (Dc might be more performance sensitive than telnet?) 
> > 4.could it be the client PCs? Is DC chewing up CPU or fighting for 
> > resource(library/socket/spyware scanner issues?)
> > 
> > Strange...
> > 
> > Brian
> > ---
> > 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: [Maybe spam] RE: [U2] Remove Scenario

2005-08-12 Thread Bill_H
Mark:

Remember, all computer languages operate within their own limitations.  In
the early stages of mvDbms computing small speed tricks were necessary when
one ran 50 users on a 1MB memory machine.  Now, it only matters with batch
processing (as you've seen with REMOVE).

I don't think it is necessary to limit our logical thinking by the
limitations of the computing environment we're working with, which we see
every day.   :-)

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Friday, August 12, 2005 9:18 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [Maybe spam] RE: [U2] Remove Scenario
> 
> Not for nothin' but I believe there's more to the variable 
> assignment version of an equate than you've expressed.
> 
> In essence, there are 2 kinds of EQUATES. The first style, 
> sometimes known as an alias, is like your
> 
> EQUATE APFILE.BALDUE  TO APFILE.REC(2)
> 
> and you can manage the contents of the second field in the 
> A/P record either using the left portion of the TO or the right.
> 
> The second style is more on the compiler level and not a 
> simple variable assignment.
> 
>  EQUATE TRUE TO 1
> 
> causes the compiler to replace the expression TRUE inside the 
> source code with the literal value '1'. Then it compiles. 
> This is different than

[the rest snipped]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [Maybe spam] RE: [U2] Remove Scenario

2005-08-12 Thread Bill_H
Mark:

I've said this before many times.  Use equates when you later want to alter
one or another side of an equality.  For example:

EQUATE APFILE.BALDUE  TO APFILE.REC(2)

but don't use an EQUATE to simply assign a value.  For example:

EQUATE BELL$ TO CHAR(9)

If you want to assign a variable simply:

BELL$ = CHAR(9)

This solves a lot of confusion.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Friday, August 12, 2005 4:32 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [Maybe spam] RE: [U2] Remove Scenario
> 
> I'll go out on a limb here and make a conclusive opinion.
> 
> I don't like EQUATES inside of a program. That doesn't mean I 
> don't like EQUATES. I just don't like them as some form of 
> higher programming when they are in a program.
> 
> I do like them in a consistent manner and the way to make 
> them consistent is in an INCLUDE. Thus have a SETUP include 
> that has all of the housekeeping crap like EQUATE TRUE TO 1, 
> FALSE TO 0 EQUATE AM TO CHAR254, 253, 252 ETC PROMPT ""
> EQUATE BELL TO CHAR(8)
> blah, blah, blah.
> 
> and then have your file-defining EQUATES in their own single 
> INCLUDE. Thus the filehandle, DIM size and all of the things 
> you are trying to normalize are consistent.
> 
> Like before, I've seen too many scattered examples of 
> half-baked ideas of EQUATES that really don't impress me 
> much. Sometimes I see one or two EQUATES like EQUATE CUSTNAME 
> TO 1 EQUATE PRODDESC TO 6
> 
> and they're used properly but in the same program you see:
> 
> PRINT CUSTREC"L#30":" ":CUSTREC<49>"D2/"
> 
> C'mon. Either all or none at all.
> 
> That begs the question. EQUATE the attribute number for a 
> dynamic array (compiler replacement) or EQUATE the field for 
> a dimensioned array, (alias concept). I've seen many examples 
> of both but I think they lean more towards the DIM variety. 
> And the survey says...
> 
> Thanks.
> 
> - Original Message -
> From: "Marilyn Hilb" <[EMAIL PROTECTED]>
> To: 
> Sent: Friday, August 12, 2005 2:48 PM
> Subject: RE: [Maybe spam] RE: [U2] Remove Scenario
> 
> 
> > I am on MasterPack. Whenever I 'deliver' a modification with a 
> > dictionary
> on it from one system to another, that process actually 
> re-builds the equate includes for any new dictionary item I 
> may have added. So yup, got lots of these, but not something 
> I or any recent programmer before me did intentionally.
> >
> >
> >  -Original Message-
> > From: Mark Johnson [mailto:[EMAIL PROTECTED]
> > Sent: Friday, August 12, 2005 1:35 PM
> > To: u2-users@listserver.u2ug.org
> > Subject: Re: [Maybe spam] RE: [U2] Remove Scenario
> >
> > I'll add another localized comment from my experience.
> >
> > My client with the 17 different expressions of CUSTOMER 
> NAME actually 
> > had
> 17
> > versions of
> >
> > EQUATE CUST.NAME.ATTRIBUTE TO 1
> > EQUATE CUSTOMER.NAME.ATT TO 1
> > EQUATE CNAME.ATR TO 1
> > etc.
> >
> > So I still stand by my original belief that if these EQUATES are 
> > localized as in this example, then you are missing the 
> point and only 
> > adding to the confusion. You cannot remember which version 
> is in each 
> > different program without going to the top of the program 
> to find it.
> >
> > Only by having these EQUATES in an application-wide INCLUDE concept 
> > can
> its
> > value be realized. Otherwise, it's just another half-baked 
> > inconsistent method.
> >
> > My 1 cent.
> > Mark Johnson
> > - Original Message -
> > From: <[EMAIL PROTECTED]>
> > To: 
> > Sent: Friday, August 12, 2005 1:27 PM
> > Subject: Re: [Maybe spam] RE: [U2] Remove Scenario
> >
> >
> > > In a message dated 8/12/2005 6:00:10 AM Pacific Daylight Time, 
> > > [EMAIL PROTECTED] writes:
> > >
> > >
> > > > Thank you for clearing up the issue of using EQUATES. I 
> was ready 
> > > > to
> > pile
> > > > on you along with Les Hewkin. We use EQUATES and live 
> by what they 
> > > > describe.  I have learned never to trust DICTS.
> > >
> > > The only problem being (or at least last time I checked) was that 
> > > RAID doesn't understand EQUATES.  So you're walking 
> through the code 
> > > and see CUST.ADDRESS = ''
> > > and you type
> > > */CUST.ADDRESS
> > > and it says whatever something like "variable not found" or 
> > > something I forget.
> > >
> > > So is there a downside to using a construct like 
> A.CUST.ADDRESS = 40 
> > > CUST.REC = ""
> > >
> > > Then RAID is quite happy with it.
> > >
> > > Will Johnson
> > > ---
> > > 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.or

RE: Re[4]: [U2] Connection Problems with Ud6 and UV10 - unmentioned

2005-08-12 Thread Bill_H
Dave:

I've found numerous instances where clients, and friends, install AV
software that includes firewall software and we have to make sure ___BOTH___
are turned off.  To turn off Windows try:

Control Panel > Security Center

then at the bottom under "Manage Security Settings:" click on Windows
Firewall.

Make sure the darned thing if "Off (not recommended)".

Next, open your Anti-virus software and look for some kind of "Security
Settings" and make sure that darned software firewall is turned off.

Once we get through the collosal pile of s#$% then maybe we can find out
what the "real" problem is.  :-)

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> David Tod Sigafoos
> Sent: Thursday, August 11, 2005 5:31 PM
> To: Ken Wallis
> Subject: Re[4]: [U2] Connection Problems with Ud6 and UV10 - 
> unmentioned
> 
> Ken,
> 
> Thursday, August 11, 2005, 4:56:18 PM, you wrote:
> 
> >> I have turned off as many services as I could and that didn't help.
> >> 
> >> I can only conclude that there is SOMETHING running on 
> this box that 
> >> keeps UV RPC from working.
> 
> KW> Windows Firewall?
> 
> Yes .. BUT if you bring up the security screen it says Firewall on.
> Drill down to the setting and it says it is off ..
> 
> I am not getting the ' your computer is not protected ' from 
> windows with makes me think SOMETHING is still working to 
> block actual work ..
> 
> 
> 
> -- 
> DSig `
> David Tod Sigafoos  ( O O )
>  ___oOOo__( )__oOOo___
> 
> Should any political party attempt to abolish social 
> security, unemployment insurance, and eliminate labor laws 
> and farm programs, you would not hear of that party again in 
> our political history. There is a tiny splinter group, of 
> course, that believes you can do these things.  Among them 
> are a few Texas oil millionaires, and an occasional 
> politician or business man from other areas. Their number is 
> negligible and they are stupid.  --President Dwight D. 
> Eisenhower, 1954 (source:  Eisenhower Presidential Papers, 
> Document #1147; November 8, 1954 The Papers of Dwight David 
> Eisenhower, Volume XV - The Presidency: The Middle Way Part 
> VI: Crises Abroad, Party Problems at Home; September 1954 to 
> December 1954,) Chapter 13: "A new phase of political experience"
> ---
> 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: Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-10 Thread Bill_H
Dave:

I'm just guessing here but I wonder if there is a registry setting inke in
HLM > Software > Informix (or is it IBM) > Universe (or UniData) that sets
the port for telnet.

Bill 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> David Tod Sigafoos
> Sent: Wednesday, August 10, 2005 4:02 PM
> To: Ron White
> Subject: Re[2]: [U2] Connection Problems with Ud6 and UV10
> 
> Ron,
> 
> Wednesday, August 10, 2005, 1:01:03 PM, you wrote:
> 
> RW> Launch UniAdmin and select Telnet under the Network 
> services header.  
> RW> When the screen appears, the first thing on the screen is the 
> RW> desired telnet port number.
> RW> After entering your port number, click the stop button to 
> stop the 
> RW> UV services and then click start to restart them.  If you are 
> RW> accessing UV with a terminal emulator you will have to 
> change your 
> RW> telnet port setting in the emulator as well.
> 
> I start UniAdmin and Local Host shows on the left.
> The menu items are File, View, COnnect, Admin, Window, 
> Logging and Help
> 
> Under Admin is Network Services.  Problem is that ALL items 
> under Admin are grayed out.
> 
> I find that if i use uniadmin on another server those items 
> don't become available until a connection has been made.
> 
> So is this one of those chicken and egg things 
> 
> 
> 
> -- 
> DSig `
> David Tod Sigafoos  ( O O )
>  ___oOOo__( )__oOOo___
> 
> Should any political party attempt to abolish social 
> security, unemployment insurance, and eliminate labor laws 
> and farm programs, you would not hear of that party again in 
> our political history. There is a tiny splinter group, of 
> course, that believes you can do these things.  Among them 
> are a few Texas oil millionaires, and an occasional 
> politician or business man from other areas. Their number is 
> negligible and they are stupid.  --President Dwight D. 
> Eisenhower, 1954 (source:  Eisenhower Presidential Papers, 
> Document #1147; November 8, 1954 The Papers of Dwight David 
> Eisenhower, Volume XV - The Presidency: The Middle Way Part 
> VI: Crises Abroad, Party Problems at Home; September 1954 to 
> December 1954,) Chapter 13: "A new phase of political experience"
> ---
> 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] Connection Problems with Ud6 and UV10

2005-08-10 Thread Bill_H
Dave:

I'm thinking of two choices: 1) shutdown the Windows telnet service (which I
always do anyway), or 2) change the port# for the UV telnet services.  I
believe you can do this via UniAdmin; at least that's how I did it so UV and
D3 would both run on the same machine.  :-)

Bill 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> David Tod Sigafoos
> Sent: Wednesday, August 10, 2005 8:44 AM
> To: u2-users@listserver.u2ug.org
> Subject: [U2] Connection Problems with Ud6 and UV10
> 
> I posted this questions last year, got some responses and 
> tried everything but without resolve.
> 
> I got a new laptop in February of this year and am not 
> experiencing the same problems.  Below is a 'basic' system information
> 
> Problem.  After installing (without any problems) either 
> Universe 10 PE or Unidata 6 PE I am unable to connect to the 
> serves locally.
> 
> I can connect to clients UD and UV servers but there is no 
> TELNET or InterCall access available on localhost.
> 
> This IS (for me) a big problem, and I hope that there is some brainiac
> (http://theages.superman.ws/Encyclopaedia/brainiac.php) out 
> there who can help me figure this out.
> 
> I can only GUESS that there is a windows service running that 
> in clobberin' (The Thing's favorite phrase is "It's Clobberin time")
> 
> Are there any known tools which would help find out what 
> might be clobberin' telnet?
> 
> 
> System Basics (some extras in case it helps):
> HP Pavilion zd8065
> Windows XP Professional 5.1 build 2600 Service Pack 2 Current 
> date/time: 8/10/2005  8:34 AM Total physical memory = 522732 
> Kbytes Physical memory available = 101352 Kbytes Total 
> virtual memory = 2097024 Kbytes Virtual memory available = 
> 2026904 Kbytes Country code: 1
> Language: English
> Code-page: 1252
> 
> Internet Explorer
> C:\Program Files\Internet Explorer\IEXPLORE.EXE
> ver: 6.0.2900.2180  8/9/2004  7:00 PM
> ver in registry: 6.0.2900.2180
> 
> Microsoft Installer
> C:\WINDOWS\system32\msiexec.exe
> ver: 3.1.4000.1823  3/21/2005  3:00 PM
> 
> Folder Options: Using System Settings
> Classic Style:  0
> DblClk in Web:  1
> IconUnderline:  3
> Browser ULine:  yes
> 
> RichEdit 1.0ver: 5.1.2600.0 8/9/2004  7:00 PM
> RichEdit 2.0ver: 5.30.23.1221   8/9/2004  7:00 PM
> 
> System desktop theme installer:
>   Installer name:rundll32.exe
>   Installer version: 5.1.2600.2180
>   Theme base folder: C:\WINDOWS\system32\Themes\
>  
> Default mail client location info...
>   Mail client name from 'HKLM\SOFTWARE\Clients\Mail' is:
> 'The Bat!'
>   Default mail client specifies MAPI DLL as:
>   C:\Program Files\The Bat!\tbmapi.dll
> ... and this file exists.
> 
> shell32.dll ver: 6.0.2900.2620  2/28/2005  4:11 PM
> comdlg32.dllver: 6.0.2900.2180  8/9/2004  7:00 PM
> comctl32.dllver: 6.0.2900.2180  8/9/2004  7:00 PM
> 
> 
> Thanks
> 
> --
> DSig
> David Tod Sigafoos
> 
> 'Politics is like driving. To go backward, put it in R. To go 
> forward, put it in D' unknown
> ---
> 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] Text extraction.

2005-08-02 Thread Bill_H
Scott:

You're correct, of course...I don't know what I was thinking.  An example is
even in the D3 help.  The only caveat is the 1st value of each attribute is
selected.

Thanks for the correction.  :-)

Bill 

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Scott Ballinger
> Sent: Tuesday, August 02, 2005 10:02 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] Text extraction.
> 
> Bill:
> 
> [snip]
> D3 doesn't allow a SELECT to create a READNEXT list from an 
> array so REMOVE is all D3 can use.
> [/snip]
> 
> Are you saying that...
> 
> SELECT DYN.ARRAY TO MYLIST
> LOOP
>   READNEXT THING FROM MYLIST ELSE EXIT
> REPEAT
> 
> ...does not work in D3?
> 
> I think you are mistaken. My experience is that it works most 
> excellently in D3, AP, and even R83- as a matter of fact, I 
> think it probably works more consistently across all mv 
> platforms than REMOVE.
> Are there any mv platforms that it doesn't work on? There is 
> one caveat
> though: DYN.ARRAY must be @AM delimited (else you can CONVERT 
> @VM TO @AM IN DYN.ARRAY first).
> 
> /Scott Ballinger
> Pareto Corporation
> Edmonds WA USA
> 206 713 6006
> ---
> 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] Open Excel and Import a file or execute a command from a localPC

2005-07-29 Thread Bill_H
Ralph:

This code worked for me. 

:bptest $options ext ; stx = char(2) ; esc = char(27) ; cr = char(13) ;
print
 esc:stx:">Excel D:\BathBid.xls":cr ; print esc:stx:">notepad
 D:\netscreen5gt.cfg" ; end
BpTest*647738360
.
[820] Creating FlashBASIC Object ( Level 0 ) ...
[241] Successful compile!   3 frame(s) used.

The excel spreadsheet appeared, then when I exited it the notepad appeared.
I'm guessing the excel line can't find either excel or the item to open.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Ralph Burton
> Sent: Friday, July 29, 2005 5:08 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Open Excel and Import a file or execute a 
> command from a localPC
> 
> Here's what I attempting in Accuterm 2000.
> The "notebook" line works, but the excel line flashes 
> something fast and returns me
> to Accuterm.  Weird huh? I went to my PC and used RUN command 
> Excel f:\ralph.csv and that worked... here's the code:
>  
> STX=CHAR(2); ESC=CHAR(27); CR=CHAR(13)
> PRINT ESC:STX:">Excel f:\ralph.csv":CR
> PRINT ESC:STX:">notepad f:\ralph.csv":CR
>  END
> 
>  
>  Thanks,
>   Ralph
>  
>  
>  
> 
> Lee Beel <[EMAIL PROTECTED]> wrote:
> Ralph,
> I am not familiar with a utility that will send a file to 
> windows, but, Accuterm will do this for you.
> 
> Lee
> 
> >>> [EMAIL PROTECTED] 07/27/05 04:06PM >>>
> Are there any utilities to pass as comma delimited file from 
> Unidata/Universe and have it open/imported into Excel? 
> 
> Any way to execute a command from a local PC workstation?
> 
> Thanks,
> 
> Ralph
> 
> 
> 
> -
> Start your day with Yahoo! - make it your home page
> ---
> 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/
> 
>   
> -
>  Start your day with Yahoo! - make it your home page
> ---
> 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] Text extraction.

2005-07-29 Thread Bill_H
Mark:

Generally, the FOR/NEXT structure is used for looping where the loop count
is known.  If the loop count is unknown the LOOP/REPEAT structure should be
used.  Don't try to fit a square peg into a round hole.

The REMOVE function is designed to traverse an array while preventing the
next field read from having to start from the beginning of the array.  When
using small arrays, the need to use REMOVE is unnecessary.  However, when
using large arrays REMOVE is mandatory (this isn't true in UV).  This is not
true for D3, mvBase, and maybe UniData.

So, use REMOVE when traversing large arrays and forget this FOR/NEXT looping
BS.  If you're only wanting to extract single valued arrays then READNEXT
works just fine.  D3 doesn't allow a SELECT to create a READNEXT list from
an array so REMOVE is all D3 can use.

As a result, REMOVE seems to be the generic statement to use under the
specific circumstances.  However, the syntax for D3 is different than the UV
so one should keep in mind of the potential differences.

Hope this helps.

Bill

> -Original Message-
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
> Sent: Friday, July 29, 2005 4:33 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Text extraction.
> 
> I guess I was more focused on the REMOVE statement and let my 
> fingers do the other typing. I'm not a LOOP REPEAT guy but 
> rather a FOR NEXT guy, especially when knowing the boundary 
> values. Not knowing the ending value of D caused me to use 
> LOOP REPEAT which, given the wide variety of placements for 
> the WHILE and UNTIL clauses, used the wrong one first.
> 
> Since REMOVE (sans DCOUNT) doesn't know the end value, 
> putting it in a FOR NEXT loop may require FOR I=1 TO I+1. I 
> don't like using FOR I=1 TO I+1 as it mentally doesn't have a 
> real ending. I'd rather DCOUNT a known ending, use LOOP UNTIL 
> "", REMOVE (with some more good experiences behind me) or use 
> the EXIT clause. In my travels, the FOR I=1 TO I+1 usually 
> has a test and a branch out of the loop which brings in 
> single purpose statement labels which this forum frowns upon.
> 
> BTW, i just tested REMOVE on D3 sans the AT clause  and it 
> didn't compile.
> That doesn't mean that it won't if another $OPTIONS clause is 
> brought into the fray.
> 
> Being an old-school guy, I got a little gun shy with all of 
> the $OPTIONS and UDT.OPTIONS in my travels. Being a 
> consultant and not a full time programmer or admin at my 
> client's locations, I dare not fiddle with these settings.
> Every one of my clients has had their systems established by 
> a VAR or someone else before me. I'm usually the current cook 
> in the application kitchen. I don't need a phone call on 
> Tuesday for some OPTION that I mis-set on Monday.
> 
> Thanks
> Mark Johnson
> - Original Message -
> From: "Ken Wallis" <[EMAIL PROTECTED]>
> To: 
> Sent: Thursday, July 28, 2005 8:41 PM
> Subject: RE: [U2] Text extraction.
> 
> 
> > > Does this behave (misbehave) on u2 systems, ie be careful of the 
> > > location of the UNTIL statement?
> >
> > Mark, that is the documented behaviour, it certainly isn't 
> misbehaving.
> >
> > Yes, you have to be precise about when you terminate the loop, but 
> > surely
> a
> > guy with your experience would always be precise about such things?
> >
> > BTW, is the AT clause something that D3 requires?  UniData, 
> UniVerse 
> > and jBASE certainly don't.
> >
> > Cheers,
> >
> > Ken
> > ---
> > 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/