Re: Memo: RE: [UD] Union Query

2004-04-30 Thread Mark Johnson
My 2 cents on this topic and maybe it'll trigger a UD/UV response. D3 allows you to GET-LIST A-LIST B-LIST and you get them combined for your next process. Could this work for this person by pre-qualifying the 2 separate SELECT statements into 2 lists, blah. blah, blah. I'm interested to know

Re: Input weirdo...

2004-04-29 Thread Mark Johnson
The Advanced Pick manual illustrates most all of the SYSTEM() references. It's one of my favorite manuals as it's chapterized like all the others but the index is pure as it contains everything. I don't like the UD/UV manuals as you need to know which index in which book to look up your topic. If

Re: Input weirdo...

2004-04-28 Thread Mark Johnson
I have a new client that i've yet to be able to break key with over the modem. So if I'm running a program (readnext etc) but i want to break, I include this INCLUDE. IF SYSTEM(14) # 0 THEN INPUT A IF A=Q THEN CLEARSELECT (sic) ; STOP IF A=D THEN DEBUG END SYSTEM(14) is the length

Accuterm like Wintegrate

2004-04-28 Thread Mark Johnson
wintegrate but I may not want to rock the boat. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: Barcode printing

2004-04-23 Thread Mark Johnson
In my 15 years of printing/using bar codes, I've concluded that it's best to not re-invent the wheel and purchase printers that are bar code capable. Thus, you don't really make up the bar code lines themselves, you just send an escape sequence telling the printer what kind of code, orientation,

Re: How do we convert lowercase letters to uppercase in Pick basi c

2004-04-22 Thread Mark Johnson
Only downsides to these OCONV's is that McDonalds and O'Henry lose the 2nd capitalized letter. The only true way to manage would be to have a BEGIN CASE situation to look for MC or O' at the beginning and handle that way. Plus maintain a list of unprogrammable exceptions. I have a music database

Re: GUI as nice as character-based

2004-04-20 Thread Mark Johnson
] On Behalf Of Mark Johnson Sent: Monday, April 19, 2004 1:45 PM To: U2 Users Discussion List Subject: Re: GUI as nice as character-based Dawn: Good luck in your search for this holy grail. Lemme know if such a silver bullet is found. I've been hunting for years. Mark Johnson

Re: GUI as nice as character-based

2004-04-19 Thread Mark Johnson
Dawn: Good luck in your search for this holy grail. Lemme know if such a silver bullet is found. I've been hunting for years. Mark Johnson Original Message - From: Dawn M. Wolthuis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 19, 2004 2:17 PM Subject: GUI as nice

Re: GUI or Event ? as nice as character-based

2004-04-19 Thread Mark Johnson
Isn't that what System Builder did (does) with its sbclient software? - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, April 19, 2004 2:27 PM Subject: Re: GUI or Event ? as nice as character-based Clarify. Are you talking about

MV Data Warehousing with Great Plains

2004-04-19 Thread Mark Johnson
Wow. Thanks to all who have helped me create a proposal for my client to possibly keep their MV system as a Data Warehouse to Great Plains. Especially the Data Cube concept which has been in Results for 24 years. I would like to get some first hand examples if anyone has used a MV system as a

Re: UV to Text Conversion Standard?

2004-04-17 Thread Mark Johnson
Let's not forget the lower case L for 1 (one). - Original Message - From: Larry Hiscock [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Saturday, April 17, 2004 2:08 PM Subject: RE: UV to Text Conversion Standard? You expect delimiters? When I started in

Re: Productivity metrics

2004-04-14 Thread Mark Johnson
Oh boy, I can smell the debates regarding programming styles in lieu of reducing lines of code. Could this be where GOTO's have their day. my 1 cent. - Original Message - From: Bob Dubery [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 7:24 AM Subject: Productivity

Re: Pro-4

2004-04-07 Thread Mark Johnson
Haven't heard of Application Liberation Language in a dogs age. - Original Message - From: Barry Brooks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 9:53 PM Subject: Pro-4 Hi all I'm looking for someone who maybe be able to assist with support of a customer

Re: Conversions

2004-04-05 Thread Mark Johnson
and delaying the needed flow of information. -- Sincerely, Charles Barouch www.KeyAlly.com [EMAIL PROTECTED] Mark Johnson wrote: This sounds very tempting, using MV as a data warehouse to a non-MV (or MV) primary application. Does anyone

Re: Label printers on AIX and/or Solaris

2004-04-05 Thread Mark Johnson
I've purchased many Prodigy DataMax label printers (4x6 UPS or smaller) from Ebay for around $80-$150 each over the last few years. The replacement heads alone are $280 new. The PCL (sic) is pretty straightforward. It isn't WYSIWYG but debugable. These printers have all the bar code fonts

Re: Conversions

2004-04-04 Thread Mark Johnson
. Thanks Mark Johnson I have one client that uses Great Plains. Although an old version I felt that the system was not as aligned to the work flow as many PICK systems are. There was also a trap similar to the old spreasheets in the report generator, where the calculations are directional ir

Re: Conversions

2004-04-04 Thread Mark Johnson
a MV customer. Thanks Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: Conversions

2004-04-03 Thread Mark Johnson
the project run smoothly to completion. Best wishes. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, April 02, 2004 10:05 PM To: U2

Conversions

2004-04-02 Thread Mark Johnson
Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very large mismatch. GP seems to be shopping-cart oriented and

Re: How to launch remote browser from UniVerse server?

2004-04-01 Thread Mark Johnson
a document) does work fine. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 01 April 2004 04:53 To: U2 Users Discussion List Subject: Re: How to launch remote browser from UniVerse server? If running Wintegrate this databasic command

Re: The lists are closing

2004-03-30 Thread Mark Johnson
Perhaps if IBM or whomever is sponsoring the U2UG.org site is listening to the feedback of the current members of this list that they will respond in a 'customer-oriented' kinda way. That's why it's called SOFTware. It can change to meet the needs of its customers. I agree with the reduction of

Re: OKI Code 39 BarCode

2004-03-29 Thread Mark Johnson
One could check www.okidata.com to see if there's any support for manual printer driver stuff like bar codes. I use www.hp.com to get beaucoups of HP PCL stuff. my 1 cent. - Original Message - From: Ray Buchner [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent:

Re: The lists are closing

2004-03-28 Thread Mark Johnson
have my cake and eat it too. Not for nothing, but I did enjoy the diversity of the topics, UV/UD and others in my single email inbox. Even though I wasn't looking for any specific topic, just scanning the various topics and responses was useful. thanks. Mark Johnson - Original Message

Re: U2 file articles in International Spectrum

2004-03-22 Thread Mark Johnson
Is OHM a pretty big player in the application arena? Are they today's Eclipse? I keep seeing their job postings. Thanks. - Original Message - From: Results [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Sunday, March 21, 2004 11:18 PM Subject: Re: U2 file articles

Re: LOCATE Command - Help :(

2004-03-19 Thread Mark Johnson
This is a similar issue with the LOCATE and understanding what level it's trying to locate in. For example, let's say you just read in a REC that has attributes, values and sub values. If one of the attributes may contain the value FRED then the reference for REC would be: LOCATE FRED IN REC

Re: Alpha-Micro to D3

2004-03-18 Thread Mark Johnson
out of 100,000,000 while Pick wanted 100% paying licenses out of 10,000. - Original Message - From: Ron White [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, March 18, 2004 9:22 AM Subject: Re: Alpha-Micro to D3 - Original Message - From: Mark

Re: Alpha-Micro to D3

2004-03-18 Thread Mark Johnson
-Micro system ? Ron White [EMAIL PROTECTED] wrote: - Original Message - From: Mark Johnson To: Sent: Wednesday, March 17, 2004 12:39 PM Subject: Alpha-Micro to D3 Dear All: One of my clients has a 40 user Alpha Micro native system that's in need of a migration. I want to migrate

D3 Automatic Faxing

2004-03-16 Thread Mark Johnson
of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL

Re: Looking for associated multi-value algorithm...

2004-03-16 Thread Mark Johnson
Perhaps the most glaring problem here is the level of the LOCATE. Since SPECIAL.PARTS is a value and thus possibly multi-valued, the ,STARTPOS indicator suggests to the LOCATE to look at the first subvalue of the value'd. Somehow, especially since STARTPOS isn't previously defined, it become zero

Re: Help Needed regarding performance improvement of delete query

2004-03-15 Thread Mark Johnson
I have a client that needs roughly 250,000 items removed monthly from a file containing 5-6 million records. Since there is no need to use the keys (records) for any other purpose except for deleting because they are old, a standard data/basic SELECT statement is just about as fast as you can

Terminology

2004-03-15 Thread Mark Johnson
Dear all: I'm not familiar with the following as referred to by MV: SLA and OLA metrics. Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL like Eclipse. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: UniVerse on NT vs *nix - Higher User Counts with W2003?

2004-03-10 Thread Mark Johnson
Sidebar on sizing. One client of mine had 240 users on a 75 mhz 486 R90 system. Around 30 printers with the rest as users both as local and multiplexed. Slow? Sort of. Working? Yes. MTBF? Incredibly infrequent given the user count. The system was written in ScreenGen which was ABS heavy. Also the

Re: [UV] Would anyone be interested in UV based bible software?

2004-03-09 Thread Mark Johnson
Aren't there bible applications already written. I don't know of them but i've heard of them as they can quickly cross reference passages and named references. - Original Message - From: Glenn W. Paschal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 11:03 PM

Re: UniVerse on NT vs *nix

2004-03-08 Thread Mark Johnson
My 2 cents: Are the persons applying the pressure MS preferred for its own sake or is it the result of an actual comparison of AIX to W2003. A client of mine bought into an MS app because of the implied greatness of MS only to have a huge disappointment. mark - Original Message - From:

Re: Pick AP-Pro Discs

2004-03-05 Thread Mark Johnson
I'll restate the question: snip Does anyone have the box, manuals and installation diskettes for AP-Pro for the Pentium I system that they could give/loan/sell? I have a new client that I want to break into the Pick world with an inexpensive application to start. I can develop their new app on my

Re: Pick AP-Pro Discs

2004-03-05 Thread Mark Johnson
Thanks. I will try it. - Original Message - From: Brian Leach [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, March 05, 2004 9:01 AM Subject: RE: Pick AP-Pro Discs Mark, I assume you've asked the question on comp.databases.pick? If not, you may get

Re: Pick AP-Pro Discs

2004-03-05 Thread Mark Johnson
Is that a URL or how do i get into it. thanks I assume you've asked the question on comp.databases.pick? If not, you may get more joy there. Brian -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: [UV] Variable never assigned a value warning

2004-03-04 Thread Mark Johnson
Not to mention the infidel CLEAR statement that does the same thing, hides errors. I believe the practice of variable assignment at the top is a practice brought over from other languages where all variables apparently need to be defined up front with DIM statements and variable types. I support

Re: How to start windows programs

2004-03-03 Thread Mark Johnson
I don't mean to over illustrate WIN.PCRUN but I must endorse it. I've got clients using it to FTP to remote sites for order downloads, delete remote data, instantiate text file transfers, link UPS tracking numbers to UPS.com and fedex. 2 of my clients maintain fleets of 20-30 dispatchable trucks

Re: [UV] Ever wondered how something works...

2004-03-03 Thread Mark Johnson
I don't know exactly but LD may be short for LISTDICTS and since you're not providing a filename, it may bomb, taking the active list with it. Sometimes on UD i wish there were an easier way to clear an active list instead of CLEARSELECT. I used TIME on all native systems but UD is more durable

Pick AP-Pro Discs

2004-02-29 Thread Mark Johnson
Dear All: I would like to acquire or purchase the complete box, manual and all diskettes for an older Pick AP-Pro system or someone's retired AP-Pro system (133-166 P1 preferably). I only need 3-5 users. I think the minimum is 3. I have a new client that I want to break into the Pick world

Re: Pick AP-Pro Discs

2004-02-29 Thread Mark Johnson
I had considered this option as well as the MV-Lite environments already out there. This is really a low-key client (private club membership) that i am making a good deal on developing the app from scratch. Once they get their original system duplicated (dbase) to Pick, I can enhance their

Re: WinteGrate

2004-02-23 Thread Mark Johnson
Are we agreeing that WIN.PCRUN would be the best way to 'launch' pictures if they're stored on a shared Windows drive. Yo No Habla Samba. mark - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, February 23, 2004 12:24 AM Subject: Re:

Re: [UV] paragraph labels

2004-02-22 Thread Mark Johnson
What does the 'also documented' sentence mean. How would a non-existant label appear before the GO in a paragraph. Regarding paragraphs: Do they behave like procs whereby you can accidentally have the same label twice and the proc goes to the first occurrence (starting at the beginning). This is

Re: [OT] Pr1me Hardware question

2004-02-22 Thread Mark Johnson
My guess is that it is a Serial Port Controller Board. I used to know what all the Royale/Reality/Sequel boards were. NIC's surely saves a lot of space now. my 1 cent. P.S. Howja get a gig like that. Is it the History Channel aspect of the CS program. I and i'm sure others could talk hours on

Re: [OT] Looking for U2 owners in northern suburbs PA, USA

2004-02-19 Thread Mark Johnson
go to pickjobs.com. there's one in wilkesbarre. - Original Message - From: Rich Sias [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 11:13 AM Subject: [OT] Looking for U2 owners in northern suburbs PA, USA Well, I got to start my

Re: D3 /NTand RESIZE function not working

2004-02-15 Thread Mark Johnson
lemme get this straight. If a 'live' resize of a file in D3 requires no users using that file, how is it considered live? my 1 cent. - Original Message - From: Lee Bacall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 15, 2004 8:00 AM Subject: Re: D3 /NTand RESIZE function

Re: Hashing Algorithm

2004-02-14 Thread Mark Johnson
Is that one similiar to the 'only' one available to native systems, which many people have known for years? - Original Message - From: Ray Wurlod [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Saturday, February 14, 2004 5:06 PM Subject: Re: Hashing Algorithm

SQL Server and Crystal Reports

2004-02-11 Thread Mark Johnson
I would like to know the best beginning books for either of these two topics. I don't yet want a reference, rather to know if 'Dummies' Books are appropriate or if anyone else has better beginning selections. My UD client migrating to these wants to keep me and this is the environment. thanks.

Re: The result of VARIABLE[1,3] + 0

2004-02-06 Thread Mark Johnson
I'm all ears. What is this numeric variable. Thanks. - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 2:34 PM Subject: Re: The result of VARIABLE[1,3] + 0 In a message dated 2/2/2004 9:06:43 AM Eastern Standard

Re: The result of VARIABLE[1,3] + 0

2004-02-06 Thread Mark Johnson
- Original Message - From: Mark Johnson [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 3:29 PM Subject: Re: The result of VARIABLE[1,3] + 0 I'm all ears. What is this numeric variable. Thanks. - Original Message - From

Re: InValid Characters

2004-02-06 Thread Mark Johnson
UD has EDIT-LIST or EDIT.LIST. - Original Message - From: Susan Lynch [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 6:51 PM Subject: Re: InValid Characters Bill, Not sure whether you are on UV or UD, so I will avoid using the

Re: UDT SELECT optimization

2004-02-04 Thread Mark Johnson
Title: Message My example was multiple WITH clauses that are ANDed. Breaking them up may be more efficient. Your example begs the question of what is faster: SELECT ORDERS WITH DATE = "01.01.04" BY TIME vs SELECT ORDERS BY TIME WITH DATE = "01.01.04" I tend to put the WITH's first if that

Re: Memo: Re: [UD] Determining if list exists

2004-02-04 Thread Mark Johnson
I once worked on a UV (SCO/Dell Poweredge) that was ported from a MCD that had a lot of IF E = 401, IF E = 201 etc. Come to think of it, every TCL statement generates an ERRMSG. They're just not all errors. 100 items selected is stored in ERRMSG. The ERRMSG dialect is evoked from the STOP

Re: VARIABLE-1 = '' Inconsistent behaviour

2004-02-03 Thread Mark Johnson
At least with maintaining a variable you are in control. - Original Message - From: Marco Manyevere To: U2 Users Discussion List Sent: Tuesday, February 03, 2004 2:00 AM Subject: Re: VARIABLE-1 = '' Inconsistent behaviour OK the documentation for

Re: VARIABLE-1 = '' Inconsistent behaviour

2004-02-03 Thread Mark Johnson
I worked on an application that had: A=INSERT(A,1,-1;NEWVAL:@VM) and it was tricky. You should develop your own best approach to this concept of managing manual delimiters. BTW, is the -1 necessary with A=A[2,LEN(A)-1]. For that matter, could you use A=A[2,1000]. My question is if the

Re: Recent issues

2004-02-03 Thread Mark Johnson
I take the blame for announcing that MV doesn't have typed variables (file handles and arrays excluded here). My contention is that we're not burdened by too many choices that may sometimes get in our way (integer vs long vs floating point etc) especially for numbers. There is a brain set,

Re: [UV] VARIABLE-1 = and Basic Compile$OPTIONSEXTRA.DELIMwork consistently

2004-02-03 Thread Mark Johnson
I think that the amount of diverse replies on this topic indicates an inconsistency across platforms and that the use of a MV counter either derived or managed is clearly the best solution that a programmer can take to any MV environment, new or old. It would remove any suspicion to wonder

Re: Re: [UD] Determining if list exists

2004-02-03 Thread Mark Johnson
Likewise if you're using new proc you may use the original ERRMSG file indicator as HSELECT FILE WHATEVER STON HSAVE-LIST LISTNAME P IF E = 401 GO somewhere as there were no items selected. - Original Message - From: [EMAIL PROTECTED] To: U2 Users Discussion List Sent:

Re: [UV] VARIABLE-1 = andBasicCompile$OPTIONSEXTRA.DELIMwork consistently

2004-02-03 Thread Mark Johnson
My issue was the possibility of -1ing a null value. I use -1 plenty of times if i absolutely know that the value is not null or i'm creating a log file. If i'm appending a set of associated mv'd attributes, i still DCOUNT the controlling one (one with never a null) add 1 and directly replace from

Re: Memo: Re: [UD] Determining if list exists

2004-02-03 Thread Mark Johnson
The E=401 is a test to see if a process generated an ERRMSG record, item-id of 401. The ERRMSG file had its own syntax of displaying the messages with the parameters, but i'm sure it's a long lost art. Sort of like RUNOFF and BATCH. GFE (Gone ForEver). - Original Message - From: Bruce

Re: The result of VARIABLE[1,3] + 0

2004-02-02 Thread Mark Johnson
I tried this on a MCD spirit, D3 W2kand AP-Pro as well and got the '1' and 567 that we're all getting. It's been affirmed here and other places that MV considers everything as a text variable (keep file handles and arrays out of this discussion) and its numerological properties come into

Re: UDT SELECT optimization

2004-02-02 Thread Mark Johnson
Title: RE: [UD]LOGTO Cached in memory is correct as well as the second statement will only have to process fewer records if the WITH was done in the first. Breaking up a SELECT statement into 2 parts may be advantageous, regardless of caching, if there are multiple ANDed WITH clauses and one

Re: Distributed multipart files [as RE: [UV] Resize - Dynamic or64 bit?]

2004-01-29 Thread Mark Johnson
Title: Message Just curious. Are Distributed files handled by the OS or the programmer. One client of mine had 12 monthly files (2-3 million records each) and the software combined the data into work files for cross-month queries. thanks. - Original Message - From: Logan,