RE: [U2] UniData ECL anomolies
Goo'day, Bill, At 21:09 06/03/07 -0800, you wrote: Bruce: As you saw in my email, I tried both unquoted and single-quoted record keys. Unidata can occasionally get very strange. Most stuff works but sometimes a Pick person keeps knocking their head trying to execute simple commands. For instance, the Prime style COPY command has a different syntax than most other commands (apparently the idea was to confuse anyone working in other Pick environments - much like casing is a constant blight for those who work on other environments at the same time they work on Unidata). Actually, with time in both vanilla Pick (up to AP) and then UV camps, I have to admit to preferring the COPY FROM x TO y A,a B,b syntax. There's no ( to worry about... Although, I do wish somebody'd tell me about the abbreviations to OVERWRITING and DELETING.. grin Using the LIKE keyword is a never ending frustration level. The ECL DELETE command had to be rewritten to remove the questions asked upon every delete. Don't get me on the AE ^ command that tells me Unprintable characters not shown when, in fact, they are. I'm guessing there is a reason I can't change the name of multiple items by using the COPY command, but I can't quite figure it out. It's a real bear to move between simple Pick syntax, that is the same for all verbs, and Prime syntax that depends on the verb being used. As the previous respondent pointed out, UD, in at least one flavour, wants to barf over an * in the item-ids, unless the item-ids are quoted I was never aware of that, but with the apparent thousand or so options, I thought there'd have to be one that. I don't suppose you want me to point out the better bits of QM in all of this?Didn't think so... grin 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! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe vs. Unidata
Goo'day, Bill, If I can make observations and suggestions here? Observations: 1. The time (5:30pm) indicates to me a quiescent machine no other activity? 2. The second run in each case would almost certainly involve items being in memory, although that would not be the case for the first run. Suggestion: Do the same thing on a quiescent machine and reverse the process (ReadnextLoop first, followed by ArrayLoop) There may well be a difference, but I don't think it'd be so startling At 17:54 02/03/07 -0800, you wrote: Chuck: Here is a UniData test run... 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! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT:Employment
At 19:07 01/03/07 -0800, you wrote: The glass is half full. Ah! But which half? 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! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe vs. Unidata
Goo'day, At 18:44 27/02/07 -0500, you wrote: Hello, all. We are in the process of moving to a new ERP solution which runs on Unidata. Our legacy system runs on Universe. In running some processes on each system, we are seeing some performance differences; in particular, running programs which make liberal - though not particularly efficient - use of dynamic arrays on our legacy (Universe on Linux) system run orders of magnitude faster than the same programs on a much larger system (Unidata on AIX). In the process of determining the origins of these problems, I want to rule out any Universe vs. Unidata issues. My question is this: does Universe handle the random searching of dynamic arrays (such as VAR1 = VAR2x) better than Unidata? Based on the assumption that you copied/restored/whatever direct from UV to UD, is this a file-size problem? In other words, did UD create the same size files or UD's equivalent, or just minimum sized ones? That rings a faint bell from last century. if not millennium 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! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Access to IBM knowledgebase for in-house developers
Stevenson, Charles wrote: First, my own var, Strategy Seven, was aggressive in getting me access to the knowledgebase. I think that says it all. Surely, it's up to each VAR to determine if any and/or all of their users should or should not have access to the knowledgebase, for whatever reason, be it revenue stream, be it implementation quirks, code, whatever Can IBM maintain a register of end-user within VAR to permit access? T'wouldn't be too difficult, Ida thought. This isn't really a function of a user group, is it? It's solely an individual user/VAR/IBM function, and I firmly believe the VAR has some rights to preclude access if the VAR deems it prudent. -- 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! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Why does the IF statement think these values are different?
Goo'day, At 10:16 08/11/06 -0500, you wrote: Don't know if you have already checked but what is your wide zero set to in uvconfig? It is a hex number. WIDE0 0x3dc0 I have called our vendor for support on this, but their recommendation is leave it alone, but grudgingly they will find out what it could be set to. We had inordinate problems with x not being equal to x within our software from about UV 9.4.something on Winblows NT... Got to the stage where we changed WideZero to 0x3eb0 on every NT that went out the door.. No more problems. Actually, I vaguely remember a UV discourse (Appendix C comes to mind) in UV documentation somewhere... so it's not going against the grain.. T'was pointed out to me much later, as far as WideZero was concerned, that ICONV/OCONV was much more preferable to multiplying and dividing by 100 (Just a thought...) 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. Version: 7.5.431 / Virus Database: 268.14.0/524 - Release Date: 08/11/06 13:40 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] The Next Big Thing
Goo'day, At 12:18 08/11/06 -0800, you wrote: Charles, Re: the NBT product: snip So, if the target market is college students, then we need to develop some *simple* applications that college students can use every day, in a gui interface, that can be used to enter information, retrieve information and print information. Not only applications, but a tutorial on putting at least one of those applications together, so the user can see how, and be told why, the application works as it does.. This then, would enable the user to modify and/or add-to that, and the other, applications, thereby getting their hands dirty and involved. and learning and.. Somebody out there, and he knows who he is, (doesn't he, Martin?), has a simple tutorial Lending Library (books, authors, borrowers) application... We need to talk with some college students first, and maybe let then develop these applications with our help so we can see how our tools really work in the target marketplace. Just sending out a product the doesn't work for them (even though it works for us) will do more harm than not sending out anything at all. Hear! Hear! 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. Version: 7.5.431 / Virus Database: 268.14.0/524 - Release Date: 08/11/06 13:40 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Closing Dynamic Connect
Goo'day, Mike At 12:35 12/10/06 -0400, you wrote: Windows 2000 SP4 Universe 10.0.21 Dynamic Connect I have a customer that uses Dynamic Connect for most of their users. They asked me recently if there is a way to catch a user when they click on the X to close Dynamic Connect so that they can properly log the user off of the system. Does anyone know of a way to handle this? Some changes that could be made to their application or to Dynamic Connect? Isn't there a stopexit.wis script in wIntegrate's \\\example\script directory to handle this? Thanks, -Mike Pflugfelder --- 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. Version: 7.5.427 / Virus Database: 268.13.3/473 - Release Date: 12/10/06 16:15 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. Version: 7.5.427 / Virus Database: 268.13.3/473 - Release Date: 12/10/06 16:15 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UD] UniQuery SELECT WITH Limits
At 08:30 26/09/06 -0400, you wrote: Don't pick on the F correlatives as they were the state of the art back then and got us where we are today. And so were valve radios and kerosene fridges.Whilst there is a resurgence of valve amplifiers for audiophiles the rest of us great unwashed can do without either having them or knowing anything about them especially when there is a progression path. Catch up with the rest of the world.Your customer will ultimately thank you unless you want to go down in history as the last person defending F-correlatives. There really are times when the tripe still propounded for vanilla Pick is just not the answer in U2.. 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. Version: 7.5.427 / Virus Database: 268.13.3/473 - Release Date: 12/10/06 16:15 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Auto-faxing a print job - RICOH Aficio 2035e/2045e [UD]
Goo'day, Ed, At 12:44 26/09/06 -0400, you wrote: We have a RICOH Aficio 2035e/2045e printer and it supports faxing and all kinds of good stuff. Has anyone figured out how to send a SINGLE print job packet to a printer like this, such that the printer says, ok, instead of printing you, I am going to fax you to 123-456-7890. I'm hoping that I can put a header on the print job that contained the fax number and some indicator that the printer would understand, and act accordingly. I'm not too sure you can expect the printer to do that. If it's the printer I'm thinking of, it's a multi-function printer and nowhere can you get the functions to talk to each other Just as a quiet aside, if you're looking for faxing and emailing direct from your code... look at ActiveFax from www.actfax.com 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. Version: 7.5.427 / Virus Database: 268.13.3/473 - Release Date: 12/10/06 16:15 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] TEXT box subroutine
At 16:56 15/09/06 -0500, you wrote: In the past, I have integrated applications with a text box using wIntegrate subroutine calls and have been very successful with that technique. You may well have done, but the OP is Dynamically Connected, and IIRC, stuck there.Dynamic Connect is, unfortunately, a cut-down version of wIntegrate, and AFAICR, does not support subroutine calls.. But I could be proven w..www...ww.wwwrong. There! 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.406 / Virus Database: 268.12.4/449 - Release Date: 15/09/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time/Date as a single number
Goo'day, George, At 17:31 12/09/06 -0400, you wrote: I'm limited to 10 characters, and to a barcode that will only use 0-9. Problem is one of the 10 characters will need to be a basic checksum, which drops me to 9 numbers. (this can't change it's the way the bar code reader/decoder is setup). I figured 86400, from 60 sec * 60 min * 24 hours I could cheat a little, since none of the dates would be before Oct 2006. But it doesn't leave me much room. I really don't know what the upper date limit will be (I'd like to be able to work with 10 years at a min.) which is 3660 * 86400 = 31622400, which works. I think I have it worked out, but it's messy using all kinds of bit manipulation and packing, hoping it's not too slow. Would you achieve anything by setting a base at, say, 1st October, 2006 and simply using your 10 years of seconds (about 316,000,000) or even more, as an add-on to that?That gives about 30 years. That way you've got 9 digits or less, and no packing/unpacking, etc... For example, 1st October is day 14154, a seconds count of 12345657 = 205760 minutes = 3429 hours = 142 days which gives day 14295 = 19th Feb, 2007. A seconds count of 987654321 (9 digits) = 16460905 minutes = 274348 hours = 11431 days = day 25584 = 16th Jan 2038.. More than your required 10 years worth George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Tuesday, September 12, 2006 4:45 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time/Date as a single number My method is take date()*86400+time() Is the goal to track a chronology via a single field? If so, I'd say your calulation is close. Wouldn't it be: ((DATE() - 1) * 86500) + TIME() (...as the number of days elapsed is today - 1, not today.) Regardless, you're right that the date could get humongous. For the cycles you're going through to do this calculation it would be a small step to convert it into and out of any other base to compress and decompress the bytes. The foundational question, however, is one of context. Why do you need this? That answer may limit or expand your options. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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.1.406 / Virus Database: 268.12.3/446 - Release Date: 12/09/06 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.406 / Virus Database: 268.12.3/446 - Release Date: 12/09/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Continuing Long Lines
Goo'day, At 11:01 25/08/06 +0800, you wrote: One way to break up a large condition is to do something like this... COND1 = (condition1 OR condition2) COND2 = (condition3 OR condition4) COND3 = (condition5 AND condition6 AND condition7) IF COND1 OR COND2 OR COND3 THEN... You could make the variables COND1, COND2, etc. meaningful (like AMOUNT.TOO.LARGE, OVER.LIMIT, WRONG.SUBURB). Wouldn't this look much cleaner and neater (not to say more understandable) with CASE statements? 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.405 / Virus Database: 268.11.6/427 - Release Date: 24/08/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Multi-value harmful? To whom?
Goo'day, At 23:37 20/07/06 -0400, you wrote: You're scaring me, Debster! I forgot to mention that the function of and in our very-high-level language, called English, is to denote that the next value is end-of-list. Maybe we should have an and special character in MV? The substringing of the attributes in the MV system is implemented by scanning the characters and blocking the data between delimiters... just like we real humans scan a sentence. Now I am scaring you??? If IBM or MS had just discovered MV yesterday, it would be heralded as a huge break-through in digital technology. Too bad IBM didn't bump into Richard Pick instead of Bill Gates when they went looking for someone to implement a small and inconsequential operating system for the PC. According to the information being bandied about over the years, they DID! If not then, then shortly thereafter. Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.10.3/394 - Release Date: 20/07/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SETPTR MODE 1
Goo'day, John, At 09:52 09/06/06 +1000, you wrote: I have been looking at Universe in PICK flavour on Windows. Does anyone know where the output goes with setptr mode 1 and HOLD. (I have always used mode 3) file name = HOLD Every report creates a new item Is it accessible in basic with a file read. It's a file - go for it where is the SPOOL - LIST job description data kept and can i access this in basic It seems like there is a gui front end for spooler management under unix but not in windows I would like to be able to come up with something that works with either if thats possible. jak --- 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.394 / Virus Database: 268.8.3/359 - Release Date: 08/06/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08/06/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SETPTR MODE 1
OOPS! Sorry! Misread the question At 09:52 09/06/06 +1000, you wrote: I have been looking at Universe in PICK flavour on Windows. Does anyone know where the output goes with setptr mode 1 and HOLD. (I have always used mode 3) It's available/spoolable from the Windows printers environment. AFAIK, it's only a temporary file... I'd be tempted to look in the Temp directory Is it accessible in basic with a file read. where is the SPOOL - LIST job description data kept and can i access this in basic It seems like there is a gui front end for spooler management under unix but not in windows I would like to be able to come up with something that works with either if thats possible. jak --- 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.394 / Virus Database: 268.8.3/359 - Release Date: 08/06/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08/06/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FOLD can mutilate {Unclassified}
At 23:26 30/05/06 -0400, you wrote: Trivia Question: What's the name of the language used for the traditional 80 column IBM punch cards. Obscene if they're in series and you drop a box of the b..s Sorry... had to change the question slightly Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.0/352 - Release Date: 30/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FOLD can mutilate {Unclassified}
At 10:10 29/05/06 -0400, you wrote: You guys had punch cards? We had to use Sears catalog pages, cut to the proper size Yeah, maybe. Well do I recall.one of my early DP jobs was putting the chads back in punch cards so they could be re-used.and Quality Control insisted I put the right ones back in the right holes. I also remember being sent to the ironmongers for a long weight to make the job easier..grin Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.7.4/351 - Release Date: 29/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Changed BASIC varname1,-1
Goo'day, Kate, At 17:56 23/05/06 +1200, you wrote: Previously, code of A1,-1 = B, when B was blank made no change to A. Now a value mark is added. If the last char is a value mark, it doesn't add another one. I consider this a bug, as it changes old behaviour. Does anyone but me think this is a problem? Just quickly... IIRC, somebody mentioned a UV OPTION to give you either which way... Last week or so. Sorry, but check the archives And some people say various LOCATEs are a problem but I find this inserting a null to be a bigger bugger Using Universe 10.1.18 PICK flavour on Windows. Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland, New Zealand Phone +64 9 360 5310 Fax +64 9 376 0750 --- 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.392 / Virus Database: 268.7.0/345 - Release Date: 22/05/06 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.392 / Virus Database: 268.7.0/345 - Release Date: 22/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with non functional printer
Goo'day, Louis,At 06:56 22/05/06 +0800, you wrote: It's a Canon PIXMA iP4000 printer using the driver off the installation CD. Needless to say the printer works fine under windows. When I do a SPOOL -LIST UV lists:- Printer: Microsoft Office Document Image Writer no entries. Printer: Canon PIXMA iP4000 no entries When I append the GDI,NODEFAULT it prints but it lists the file with line numbers and a Record 1 File HOLD Account ... and time and date Header and Footer The escape character is printed as ^027 graphic characters printed as ^218^196^194 etc Thanks, at least it prints sofar. More help please. As far as I can determine, a PIXMA printer is a jet printer, and as far back as I can recall, jet printers are all Windows GDI printers, that is, they have no local intelligence, all work is done by the printer driver. They usually come with a minimum of PCL capability (a sub-set of PCL3, normally), and because of this, are unsuitable for UV work. They normally can't even draw a straight line. You are limited, in all probability, to straight text, and with a very limited number of fonts - at least we always were. We have found sometimes, as a previous poster said, that we can redirect printing from a fully-capable PCL printer to a jet printer and get reasonable output, but not without a deal of work, and support thereafter (Users? It's a printer, isn't it? What's wrong with your software? Everything else prints ) About the only permanent fix we've found is usually bound up in non-freebie third-party tools... or a change, now from UV to Reality (I believe Northgate now supports Windows GDI printers)... And, don't let UV's SETPTR option of GDI fool you... It's not really there to support el-cheapo Windows GDI printers. There is a difference... Sorry I cannot be of more assistance. Louis - 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.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with non functional printer
Goo'day, again, Louis, At 10:53 22/05/06 +0800, you wrote: With further messing about using the GDI,DEFAULT addition I now can print text at least. It doesn't seem to support even PCL3 as a simple orientation string (to select landscape printing) is ignored. Also the graphic set, like light down and left/light down and right/light horizontal etc are completely screwed. As I said... A sub-set of PCL 3, but I'm surprised it doesn't support ESC:'l0O' for landscape. Perhaps as time passes, these sorts of printers are further removed from the ability to programatically control them. But you should consider sending the PCL landscape, A4 (??), etc to the printer as a page separator (.sep file). We also use: GDI FONTNAME Courier New --- Notethe Upper/lower case FONTSIZE 8 in SETPTR statements which gives about 178 charsx60 lines per A4 page. Perhaps *you* will be the one who gives IBM the straw that breaks the camel's back and they set about looking to use Winblows printer drivers, but you'll have to fight the *nix side of the fence first Nobody that I know of in the past 12 years has been able to convince anybody involved with UV (from VMark onward) that Windows printer drivers are used by the rest of the world. HTH Well, at least I can now print text so that is a gain but any further suggestions to print graphic characters would be appreciated. I am really puzzled as under Windows it is a superb printer. Does everything I hoped it would but un UniVerse Bits vs characters... Thanks for the responses so far, Louis - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 22, 2006 9:02 AM Subject: Re: [U2] Help with non functional printer Goo'day, Louis,At 06:56 22/05/06 +0800, you wrote: It's a Canon PIXMA iP4000 printer using the driver off the installation CD. Needless to say the printer works fine under windows. When I do a SPOOL -LIST UV lists:- Printer: Microsoft Office Document Image Writer no entries. Printer: Canon PIXMA iP4000 no entries When I append the GDI,NODEFAULT it prints but it lists the file with line numbers and a Record 1 File HOLD Account ... and time and date Header and Footer The escape character is printed as ^027 graphic characters printed as ^218^196^194 etc Thanks, at least it prints sofar. More help please. As far as I can determine, a PIXMA printer is a jet printer, and as far back as I can recall, jet printers are all Windows GDI printers, that is, they have no local intelligence, all work is done by the printer driver. They usually come with a minimum of PCL capability (a sub-set of PCL3, normally), and because of this, are unsuitable for UV work. They normally can't even draw a straight line. You are limited, in all probability, to straight text, and with a very limited number of fonts - at least we always were. We have found sometimes, as a previous poster said, that we can redirect printing from a fully-capable PCL printer to a jet printer and get reasonable output, but not without a deal of work, and support thereafter (Users? It's a printer, isn't it? What's wrong with your software? Everything else prints ) About the only permanent fix we've found is usually bound up in non-freebie third-party tools... or a change, now from UV to Reality (I believe Northgate now supports Windows GDI printers)... And, don't let UV's SETPTR option of GDI fool you... It's not really there to support el-cheapo Windows GDI printers. There is a difference... Sorry I cannot be of more assistance. Louis - 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.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 --- 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.1.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 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.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] LIST DICT FILE Depth and Assoc
Goo'day, John, At 15:42 16/05/06 +1000, you wrote: Can anyone tell me if there is a way to tell Universe that an A type dictionary item is a single value and not a multivalue like you can in D or I type items. It seems that Universe catagorises these as M Knowing this can be useful when combining dict items with a WHEN via a front end Can't really remember ... I've slept since I last heard about it but hasn't it got something to do with the controlling/dependant attributes of a dict item (Attr 4 5) If it is UV that you're playing with, why don't you just create a D- or I-type item to replicate the A-type?Silly question? jak --- 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.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/06 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.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Executing save-list
Goo'day, Bill... At 16:52 28/03/06 -0800, you wrote: I was following some suggestions to track saved lists and did the following: 1) Created a SAVE-LIST and DELETE-LIST (VOC) entry that look like: SAVE-LIST 001 V 002 U2.LISTINFO 2) Wrote a program U2.LISTINFO that updates a (LISTINFO) file with information then does an EXECUTE \SAVE.LIST \ : LISTNAME. From TCL the SAVE-LIST ... seems to work fine. However, when I EXECUTE \SAVE-LIST \ : LISTNAME from a BASIC program the program U2.LISTINFO isn't called. It's as though there's a global SAVE-LIST command that is used instead of the local one. Is this true? Any ideas how I can overcome this? (ECLTYPE P) If UD is anything like UV, SAVE-LIST is exactly the same as SAVE.LIST, 'cos part of the comaptibility with Pick is that a dot or a dash for TCL verbs are the same As always, thanks. Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- 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.384 / Virus Database: 268.3.3/295 - Release Date: 28/03/06 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.384 / Virus Database: 268.3.3/295 - Release Date: 28/03/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [DC] Dynamic Connect, Ctrl V
At 18:06 22/03/06 -0500, Brutzman, Bill wrote: I have a user who like to use that Ctrl-V, Ctrl-Something to cut and paste. Although it runs as part of the install, I am having trouble finding info on it in the yr 2000 Using Dynamic Connect manual. Suggestions would be appreciated. Isn't it CtrlC to copy and CrlV to paste? (Standard Winblows) The Edit menu of a DC session has copy and paste... and the above seems to work... for mebut not at an INPUT prompt... --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.384 / Virus Database: 268.2.6/288 - Release Date: 22/03/06 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.384 / Virus Database: 268.2.6/288 - Release Date: 22/03/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to the List
Goo'day, At 19:30 15/03/06 -0800, Tony Gravagno wrote: Given those numbers, it seems traffic here has dropped by almost half since the change. Whether that's good or bad is up to the individual, but anything that (seemingly) cuts community traffic by this magnitude deserves some evaluation. Would this dramatic reduction have something to do with Reply now only going to the poster - by default - instead of to the list? How many now know to Reply All if they want a moment of fame on the list? HTH T --- 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.384 / Virus Database: 268.2.4/282 - Release Date: 15/03/06 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.384 / Virus Database: 268.2.4/282 - Release Date: 15/03/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] PCL extra page
Goo'day, Dave and Bill, A further option you might like to consider (in a Windows printer environment) is the use of the printer's Page Separator (for each of the separate and several printers you create) to set a document's properties to whatever you requirelandscape/portrait, font, size, etc, etc, without burying those instructions in your document Using PCL-style instructions... At 12:20 07/03/06 -0800, Dave Taylor wrote: snip -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 07/03/06 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.375 / Virus Database: 268.2.0/276 - Release Date: 07/03/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Changes to mail list configurations
At 14:03 27/02/06 -0800, Tony Gravagno wrote: This is breaking all kinds of things including filters, remailers, and maybe threading for some reader programs. It's going to create confusion when people mail to one another off-list. And for anyone who isn't familiar with this completely unique solution people are going to think they're responding to a list when they're responding to some person - and we might start seeing ongoing inquiries about hey, where did my response go? Sorry folks but I don't believe this is a good long-term solution. I think we should go back to the way it was until a more standard solution can be found. Tony For once, Tony, I totally agree with you All U2 list postings are now going to my trash bucket Please put it back to how it was... The knee jerk goes too far t'other way Larry Hiscock wrote: We have made some changes to the mailing list configuration files in an attempt to reduce some of the problems we have been experiencing these past few days. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 268.1.1/270 - Release Date: 27/02/06 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.375 / Virus Database: 268.1.1/270 - Release Date: 27/02/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Steve Cashman
At 15:57 25/02/06 -0500, you wrote: It's not as simple as you might think. There have been long heated discussions about how to deal with vacation auto-responders on lists - including Majordomo. In the end, there's 2 options: Three, actually. Get him back from holidays, immediately, to deal with the rubbish he left behind. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 24/02/06 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.375 / Virus Database: 268.1.0/269 - Release Date: 24/02/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Stuttering List
Goo'day, To whomever is recycling through already sent/received recent messages, you're not doing the bandwidth much good. And how do I know? Two messages from Chris Day in two days, and we haven't heard from him in over 12 months g (Goo'day Chris) 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.375 / Virus Database: 268.1.0/269 - Release Date: 24/02/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Newbies need love too
Goo'day, Walter, At 17:33 31/01/06 -0500, you wrote: We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I reckon you should enrol you and your people in the classes organised by IBM. Get a grounding in the Multi-Value and UniVerse concepts first, then look at your application from that grounding and get the provider/VAR to add specifics to the knowledge you have already acquired. You might have caught the posting earlier today: Folks: Based on a recent thread about UniVerse 'internals' class availability - I researched. The class is now named 'UniVerse Theory and Practice'. It has recently been added to the IBM US class schedule. June 6-9 in Denver. Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] In point of fact, I'd hazard that's how most of us did it - no matter how many years ago it was... It probably wasn't via IBM, though Alternatively, I think there are still courses available from private sources Perhaps somebody can come up with a list or a local And, if it's not too soon, welcome to the club -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.25/247 - Release Date: 31/01/06 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.375 / Virus Database: 267.14.25/247 - Release Date: 31/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Uv - Conversation from UltPlus
At 15:57 30/01/06 -0500, you wrote: Hi it's me again. We are still doing a conversion from an UltPlus to UniVerse. We have run across a user exit that I am not familiar with. U11AD is the culprit. Is anyone familiar with this exit and if so does anyone have a basic subroutine to emulate it's processes? From memory, 11AD retrieves the multi-values of a File/Item/Field and the user has an option which buffer to stuff 'em into - P = primary input (?? or was it output??) buffer, T = display at terminal, etc. ... It's been years.. Thanks in advance for the help. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- 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.375 / Virus Database: 267.14.24/244 - Release Date: 30/01/06 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.375 / Virus Database: 267.14.24/244 - Release Date: 30/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML mapping file - HELP
OK I'll bite At 15:09 31/01/06 +1300, you wrote: If anyone is interested I solved this by changing the following: ColumnMap Node=EventProgramStack/ProgramStackLevel,ProgramStackAddress Column=ProgramStackAddress/ ColumnMap Node=EventProgramStack/ProgramStackLevel,ProgramStackLevelNumber Column=ProgramStackLevelNumber/ ColumnMap Node=EventProgramStack/ProgramStackLevel,ProgramStackName Column=ProgramStackName/ to ColumnMap Node=EventProgramStack/ProgramStackLevel,ProgramStackAddress Column=ProgramStackAddress/ ColumnMap Node=EventProgramStack/ProgramStackLevel,ProgramStackLevelNumber Column=ProgramStackLevelNumber/ ColumnMap Node=EventProgramStack/ProgramStackLevel,ProgramStackName Column=ProgramStackName/ You changed *what* to *what*?Unless my last 5 minutes were totally wasted, I see no differences... So, I see somebody else has twigged to my support charging Change nothing and charge heaps. G Unless of course, there *is* a difference twixt the two. that escaped me -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.24/244 - Release Date: 30/01/06 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.375 / Virus Database: 267.14.24/244 - Release Date: 30/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML mapping file - HELP
Stand by for the proof reading bill Didn't change anything, but grin got to make a quid somehow. At 17:47 31/01/06 +1300, you wrote: Damn cut paster ;-) -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.24/244 - Release Date: 30/01/06 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.375 / Virus Database: 267.14.24/244 - Release Date: 30/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2UG board activity: [U2] Knowledgebase access
Goo'day, And all of this blithering and dithering leaves the poor bloody PE user just where, exactly? And, no, I'm not one but I do feel for them If my supposition is correct, PE users get no factory support (understandable) and no access to the knowledge base. Isn't that a marvellous way to spread the word...? BBB (Big Blue's Best) Marketing again. And hasn't there been a lot of that over the years? And I'll bet the PE comes with documentation and install instructions, FAQs, conversion advice and a directory of where to go and what to do ifWell, does it? Asking questions of the U2UG is not totally satisfactory, either. There is a time lag waiting for responses, time which most PE users would rather spend on their own investigations of. of. something, somewhere And, at the moment, indexinfocus, even if they know about it, just isn't the place to go and play If IBM VARs have the opportunity of restricting end-users from the knowledge base, which, by extension, means that PE users' access is also verboten, wouldn't IBM be better off bowing totally to their VARs and withdrawing from the PE industry completely letting the PE end of the market go to where they're appreciated? Who asked the VARs for their opinion in the first place? Of course they'd want to maximise their revenue stream, and not have end-users asking possibly embarrassing questions.. Being VAR driven and wanting to have a PE in the market place are two ideas that are a total antithesis to each other. As a consequence of this, do IBM really see the PE as ONLY for existing U2 users to have something to play around with at home?And ask their questions from work? You'd think that somebody, somewhere within the IBM labyrinth'd be charged with just a touch of nous, wouldn't you?But, that'd be only if, corporately, they gave a damn. And nobody, anywhere in there seems to have any sort of priority to do anything about it At 10:13 29/01/06 +1100, you wrote: The U2UG board has followed through on this over the last 6 months as part of the U2UG board and IBM U2 is aware of the issue. Unfortunately IBM U2 has to deal with some of the constraints of the IBM juggernaut that are not always easy to overcome. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06 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.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2UG board activity: [U2] Knowledgebase access
Goo'day, David, As far as I can see the problerm comes from IBM undertaking to protect the VARs revenue streams... The established U2 community, IBM - (Distributor) - (Dealer/VAR) - End User works, works well, and will continue to work, until, that is, IBM provide PE's direct to End Users.End Users of the PE variety want and need all the stuff normally provided with PE's, and as far as they're concerned, it should come from IBMEnd Users of the non-PE variety are used to travelling back up the chain for their needs. I'd hate to have to contact IBM with some of the problems I throw er. threw back up the chain If IBM are not going to provide free access to the U2 knowledge base (at their VARs request), then they've got to get out of the PE business, for their own sake, as well as that of their products... They can't have it both ways. unless they can define their PE as something that will get around the VARs reluctance to get out of the way At 14:19 29/01/06 +1100, you wrote: Hi Bruce, Perhaps IBM (and the other majors as they are not the only ones that are guilty of this) could take a leaf out of the opensource handbook. Look at the documentation/instructions/examples/assistance that comes with MySQL, PostgreSQL and the others. There are some projects out there that are not that great, but in general they are pretty good. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: Sunday, 29 January 2006 12:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2UG board activity: [U2] Knowledgebase access Goo'day, And all of this blithering and dithering leaves the poor bloody PE user just where, exactly? And, no, I'm not one but I do feel for them If my supposition is correct, PE users get no factory support (understandable) and no access to the knowledge base. Isn't that a marvellous way to spread the word...? BBB (Big Blue's Best) Marketing again. And hasn't there been a lot of that over the years? And I'll bet the PE comes with documentation and install instructions, FAQs, conversion advice and a directory of where to go and what to do ifWell, does it? Asking questions of the U2UG is not totally satisfactory, either. There is a time lag waiting for responses, time which most PE users would rather spend on their own investigations of. of. something, somewhere And, at the moment, indexinfocus, even if they know about it, just isn't the place to go and play If IBM VARs have the opportunity of restricting end-users from the knowledge base, which, by extension, means that PE users' access is also verboten, wouldn't IBM be better off bowing totally to their VARs and withdrawing from the PE industry completely letting the PE end of the market go to where they're appreciated? Who asked the VARs for their opinion in the first place? Of course they'd want to maximise their revenue stream, and not have end-users asking possibly embarrassing questions.. Being VAR driven and wanting to have a PE in the market place are two ideas that are a total antithesis to each other. As a consequence of this, do IBM really see the PE as ONLY for existing U2 users to have something to play around with at home?And ask their questions from work? You'd think that somebody, somewhere within the IBM labyrinth'd be charged with just a touch of nous, wouldn't you?But, that'd be only if, corporately, they gave a damn. And nobody, anywhere in there seems to have any sort of priority to do anything about it At 10:13 29/01/06 +1100, you wrote: The U2UG board has followed through on this over the last 6 months as part of the U2UG board and IBM U2 is aware of the issue. Unfortunately IBM U2 has to deal with some of the constraints of the IBM juggernaut that are not always easy to overcome. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06 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
RE: [U2] [UD] T-LOAD
Goo'day, Bill, You probably don't want to hear this about now, but... At 17:25 27/01/06 -0800, you wrote: The biggest problem I have, otherwise, is the paleozic user interface. I'm at least 5 to 10 times more productive with a screen editor (I'm into tons of stuff like programs, VOC entries, dictionaries, and data and have difficulty managing a different editor for each type of item I'm working on) than I am with AE (or ED on UV). This means that I'm probably spending 20 days doing about 2-4 days of work. There are at least 2 freebie screen editors for UD that I'm aware of... UniDebugger from the UD client CD and UniEditor from Martin Scholl www.martinscholl.com We found UniEditor to be excellent... HTH -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06 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.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Knowledgebase access
At 14:50 26/01/06 -0500, you wrote: Time to kick that VAR to the curb! The thought of denying a client access to information like this is unacceptable. In all seriousness, IBM is probably only trying to protect the revenue stream of its VARs, albeit at the cost of possibly alienating them at the coal face. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.23/242 - Release Date: 26/01/06 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.375 / Virus Database: 267.14.23/242 - Release Date: 26/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Knowledgebase access
At 15:58 27/01/06 +1300, you wrote: I used to have a 1 user license which I paid maintenance on, but then this changed to a minimum 4 user license, so I cancelled as it was not worth that much money to me. The distributor suggested that I use the personal edition available off the website instead... And as IBM are now driven by their VARs to open up the knowledgebase to the VAR's customers, for whatever IBM's original reason - and it seems as if Epicor as an IBM VAR, for one, support IBM in this - the ability to access the KB from a downloaded PE ownership seems extremely remote. Your best bet is via this group. There's more than one way to skin this cat... Ask away.I'd hazard you will get the information you want -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.23/242 - Release Date: 26/01/06 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.375 / Virus Database: 267.14.23/242 - Release Date: 26/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata on XP Lap Top
Goo'day, Allen, At 15:39 17/01/06 -0800, you wrote: That goes without saying. I'm developing this program for my own use, but if they ever make a Unidata LITE then I could distribute my code for free for the good of the dieting but likes to make their own recipe's world. Without inviting visitations from those opposed to such a move, might I humbly suggest a quick look at the OpenQM Personal Edition? The licencing provisions attached thereto SEEM NOT to be a hindrance to your vision - Martin?. I'd hazard a guess that conversion from UD wouldn't be huge problem, there is all sorts of assistance availablelots of been there, done that ... and the OpenQM API would help in making your app an icon.. OpenQM ( in total, but without the docs) is of the small footprint brigade even with .pdf docs, the download's still less than 5Mb.That's Winblows... Linux/FreeBSD download - no docs - is less than half a Meg, IIRC... Have a read ... http://openqm.com/personal.htm Respectfully, -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.20/232 - Release Date: 17/01/06 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.375 / Virus Database: 267.14.20/232 - Release Date: 17/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata on XP Lap Top
At 18:51 17/01/06 -0800, you wrote: Tony: It's amazing how much one constantly fights with the dbms, isn't it? :-) Way too much is illogical or is segregated between Pick mode, which is 30 years old, and U mode, which doesn't work well for Pick like environments. For instance, in U mode something so simple like 'SORT VOC = [LIST_]' fails miserably. :-( One always has to ask the question, why would IBM and UD make it so difficult to work in, or move to, this environment? :-) Waay back, late '80s, I was trying to get the Unidata blokes out from under my feet, and the opinion expressed then about the dis-similarity of UD to vanilla Pick was all to do with Dick and litigation. so they made things different, but close, but that seemingly didn't stop Dick I guess UD took a more stringently different path with ECLTYPEs P and U compared with UV and its different modes, Pick, Information, et al, but then again, I wouldn't really know: my 9 years with UV was all in Pick mode I suppose now nobody @ IBM sees any need to unPick, or more correctly, re-Pick, the current product Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Tuesday, January 17, 2006 10:02 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata on XP Lap Top George Smith wrote: I would like to propose to upper management that we replace a single user laptop program using a non-pick database with a Unidata single user system. We would use C# and the uniObjects for the gui front end. This would be on about 400 laptops if successful. Anyone doing this and would like comments from the group. I have Unidata PE on my laptop with XP Pro for development/testing with DesignBais and mv.NET, both of which can use UO for connectivity. I haven't had any problems - outside of being a D3 guy who desperately needs a U2 for Pick Dummies book. :) Rather than letting the system auto-start the services, I start/stop the environment with a single click on BAT files on the desktop. (Provided here on request.) I do this to eliminate CPU/memory usage when the environment isn't in use. That said, UD only has a modest 15MB RAM footprint and zero CPU usage when inactive, so it doesn't interrupt other processes anyway - this is probably what you're interested in. The only other comment I would make is that it might be appropriate to get licenses for production systems, rather than running on personal/development licenses. I don't recall what the actual license text has to say about this. Side comment: One of these days I wish the MV DBMS Vendors would pay attention to requests like this and create Lite versions of these environments with no BASIC compiler, no spooler, no editors, no telnet or serial services, etc. - just a low-profile runtime-only that's easy to install and use with a GUI client, and for a similar cost. So far I think the only candidates we have for this now are Revelation OpenInsight and QM. HTH T --- 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.1.375 / Virus Database: 267.14.20/232 - Release Date: 17/01/06 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.375 / Virus Database: 267.14.20/232 - Release Date: 17/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Goo'day, At 16:28 16/01/06 -0800, you wrote: The convention for specifying alpha data vs numeric data is actually to precede the data with a single quote, not to surround it with double quotes. As far as tab delimited data that includes tabs, since this isn't supported in cells anyway it's not a problem. Tony Gravagno, Nebula RD TG@ removethisNebula-RnD.com Perhaps a quiet look at ftp://ftp.isi.edu/in-notes.txt wil help you in determining .csv standards Thankyou, Martin (private joke...) ... very apt and pertinent... today... Michael Doyle wrote: The convention, as I understand it, for handling embedded commas in of csv data is to wrap each datum in double quotes. This cheerfully introduces the problem of embedded double quotes... TAB-delimited files do avoid this situation, but bank on your not having tabs in your data. I am not aware of any conventional method for dealing with tab-embedded tab-delimited data. ... --- 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.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 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.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] making a .csv file into an .xls file?
Tony, Cripes! I can't even copy and paste properly At 19:37 16/01/06 -0800, you wrote: Bruce, you mean this 2 month old RFC?: ftp://ftp.isi.edu/in-notes/rfc4180.txt Yes, that is indeed what I meant. So sorry, folks Mitigation: I was also talking to a publican at the time... T -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 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.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
Goo'day, Jay Jay and . At 22:29 11/01/06 +, you wrote: It's been a LONG time ... I can remember writing a whole PL suite in MDIS PROC (don't ask...) I recall that in PQN procs you could have a construct such as PQN M RI IP: IF %1 = 1]2]3]4]5 G 10]20]30]40]50 That's the MDIS (MDD) method of multivaluing the input and associated actions, but the OP wanted to have one input and multiple actions, IIRC, so this isn't what was asked AFAIK with UV (we'd changed all of our MDD PQN PROCS on converting ot R83 PQs), you'd have to go to an internal subroutine ([]) and call each action in turn, and return as has already been suggested, or amend your actions programs to CHAIN from one to anotherwhich probably wouldn't be very clever T Bad entry G B 10 XTEN 20 XTWENTY 30 XTHIRTY 40 XFORTY 50 XFIFTY Etc - or whatever (]=value marks by the way) Otherwise PQN IF %1 # 5 G F [USER.PL BASIC.PGM1] [USER.PL BASIC.PGM2] etc M BTW - I don't really like G F and G B - much prefer labels I haven't tried this on UniVerse but I hope this helps.. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: 11 January 2006 17:35 To: U2-Users List Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a menu when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- 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.1.371 / Virus Database: 267.14.17/227 - Release Date: 11/01/06 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.14.17/227 - Release Date: 11/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Totaling oddity on UniVerse
Goo'day, Looks awfully like the old WIDEZERO problem to me At 23:43 07/01/06 +1100, you wrote: A strange oddity I have encountered on UniVerse (10,0,19). I have a file that I build and export to a third party package we have. In this file, the dollar amount values have to be store and sent in OCONV format (that being 123.00 instead of 12300). All the data is MR2 converted and all the data is valid. Before sending, I just like to check that to total dollar amount is correct. So I do a LIST filename TOTALF55 DET-SUPP Dict filename F55 D 55 ATTR 55 12R The output I get is quite bizarre. Instead of the expected value of 134878167.90I get 134878167.890005 Any thoughts ??? Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- 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.14.15/223 - Release Date: 06/01/06 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.14.15/223 - Release Date: 06/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Converting number to word
Goo'day, again, At 16:12 05/01/06 +1100, you wrote: Oops! Mea culpa! Just add TH to everything above THREE and replace ONe TWO THREE with FIRST SECOND THIRD... (I think) Fiveth??I'm sure you'll be able to figure it out 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.14.12/220 - Release Date: 03/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] DCOUNT
Goo'day, Mark, At 00:21 05/01/06 -0500, you wrote: I'm finding that I'm doing a lot of programming for the processing through multi-valued attributes. I'm wondering if the method I'm using is the best way to determine the last element. LAST=DCOUNT(REC15,@VM) FOR I=1 TO LAST (process something) NEXT I There was a REMOVE thread a few months ago and I use that when I expect that the number of elements could test the patience of the EXTRACTs. REMOVE doesn't give you the MV counter for the associated fields by itself. You have to manage separately and hope to keep in sync. That's more code. I know that in VB certain object array variables (a list box for example) has a property for the number of elements. Is there anything in MV that I'm not aware of for determining the last multi-value that's easier to type than the DCOUNT expression. I'm looking at reducing my keystrokes. If this is a serious query, might I suggest a water-cooled keyboard? Thanks in advance. Mark Johnson --- 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.14.13/221 - Release Date: 04/01/06 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.14.13/221 - Release Date: 04/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Converting number to word
Goo'day, David, Dick Pick's gift to the world: At 15:24 05/01/06 +1100, you wrote: Happy New Year, A current project involves printing a number string in its alphabetic description e.g. 1 = one, 3 = three, 11 = eleven etc etc. The precise task is printing a label of book information and in this case the label is edition e.g. first/second. The universe basic manual does not appear to provide a conversion code as in MCN etc ; would someone know of a UV code or algorithm that converts these strings? Regards David Knight --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Just add TH to everything above THREE and replace ONe TWO THREE with FIRST SECOND THIRD... (I think) And discard the cents! 0001: SUBROUTINE(N,S) 0002: S= ''; IF NUM(N) ELSE RETURN 0003: N = N'R26%12' 0004: FOR I = 1 TO 7 STEP 3 0005: X = N[I,3] 0006: SX = '' 0007: IF X 99 THEN SX = SX:' ':FIELD('ONE TWO THREE FOUR FIVE SIX SEVEN EIGHT NINE',' ',X[1,1]):' HUNDRED' 0008: X = X[2,2] 0009: IF X 0 AND SX # '' THEN SX = SX:' ' 0010: IF X 0 AND SX = '' AND S# '' THEN SX = ' ' 0011: IF X 19 THEN SX = SX:' ':FIELD(' TWENTY THIRTY FORTY FIFTY SIXTY SEVENTY EIGHTY NINTY',' ',X[1,1]); X = X[2,1] 0012: IF X 0 THEN SX = SX:' ':FIELD('ONE TWO THREE FOUR FIVE SIX SEVEN EIGHT NINE TEN ELEVEN TWELVE THIRTEEN FOURTEEN FIFTEEN SIXTEEN SEVENTEEN EIGHTEEN NINETEEN',' ',X) 0013: IF SX # '' THEN S = S:SX:FIELD(' MILLION... THOUSAND','.',I) 0014: NEXT I 0015: IF S = '' THEN S = 'ZERO' 0016: IF S = ' ONE' THEN TEXT = ' DOLLAR ' ELSE TEXT = ' DOLLARS ' 0017: S = S:TEXT 0018: IF N[11,2] = 0 THEN 0019: S = S:'ONLY' 0020: END ELSE 0021: IF N[11,2] 9 THEN 0022: S = S:N[11,2]:'/100' 0023: END ELSE 0024: S = S:' ':N[11,2]+0:' CENT' 0025: IF N[11,2] 1 THEN S= S:'S' 0026: END 0027: END 0028: RETURN -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 03/01/06 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.14.12/220 - Release Date: 03/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate 3.x support for Unidata 7
At 11:45 15/12/05 +, you wrote: I understand the if it ain't broke comments. But surely if you have maintenance in place to get the new versions for free and by doing so you ensure you have a long term support option in place, just in case UniData 7 breaks the wIntegrate 3 environment, it makes sense to get the new version in place? E I don't think the path from wIntegrate 4 to wIntegrate 5 was free, maintenance or no IIRC, there was a cost involved, ie, a new per-user licencing fee Otherwise, if you do find something, and it is past the support dates, you stand a big risk of costly fixes - whether paying for changes or purchasing the upgrades. This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- 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.14.0/203 - Release Date: 15/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.14.0/203 - Release Date: 15/12/05 --- 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)
At 17:04 09/12/05 -0800, you wrote: 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 Might it have something to do with Them that can, do. Them that can't, consult. Them that can't consult, teach. Them that are left over from that frame legislation against it? -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.371 / Virus Database: 267.13.13/197 - Release Date: 09/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.13/197 - Release Date: 09/12/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
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/
RE: [U2] Linux to Windows
Goo'day, David, This intrigues me: At 07:33 14/11/05 +1100, you wrote: Hi LeRoy snip An alternative to this is also to host the application centrally and allow customers to access the application through the internet through VPN. This is an area we are investigating and due to the nature of U2 this is easier to achieve than with other database products. In what way do you see either of the U2's permitting easier access via VPN? Regards David Jordan Managing Consultant [EMAIL PROTECTED] DACONO Holdings Pty Ltd www.dacono.com.au PO Box 909 Lane Cove NSW 2066 Australia Phn: 61 2 9418 8320 Fax: 61 2 9427 2371 --- 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.362 / Virus Database: 267.13.0/167 - Release Date: 11/11/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.362 / Virus Database: 267.13.0/167 - Release Date: 11/11/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] To Limit TCL Access Privilege
At 10:31 28/10/05 +0800, you wrote: Dear All I am trying to give some user to have privilege to access to uniVerse TCL level to do some listing but not using updating or deleting or files / data . Is there any idea to set such setting ? DELETE VOC ED DELETE VOC DELETE.FILE removes the editor delete file verbs from the account is this good enough? Or you might want to rename VOC ED and VOC DELETE.FILE to something you can remember and use, without telling *them* . That's the simplest way HTH Thanks in Advance --- 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.362 / Virus Database: 267.12.5/150 - Release Date: 27/10/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.362 / Virus Database: 267.12.5/150 - Release Date: 27/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV][OT]Embed command in CSV file? [ad]
Goo'day, Mark, At 20:44 23/10/05 -0400, you wrote: Tony: What's the fastest path for someone who's been providing the CSV's for the last 10 years and wants to deliver something more complete. I don't want to spend a lot of my client's money on packages. Have you considered (a) the terminal emulator path or (b) DOWNLOAD? I appreciate that there are sites out there infinitly larger than the environments we get involvred in, and that there are managers out there who will spend a dollar or two in getting a better solution, but way down here at the market we're in, CSV or some such seems to be solution of choice to most of our sites. Sure, we've had people look at expanding their bailiwick to include data communications twixt UV and desktop products, but in most situations, the available paths have been discounted - too much money or too complicated with the introduction of middle-ware - We're not computer geniuses. We want something simple. They forgot and as cheap as possible We've had some success with MV-aware terminal emulators with import and export functions, with UV and wIntegrate, but the per-user cost of wIntegrate vs Dynamic Connect (no import or export) normally limits the implementation of wIntegrate to one or two desktops per site (Errr Should I mention what is now called commercial OpenQM with its bundled AccuTerm 2k2? With all its private functions) With UV we also had lots of success, where implemented, with Cedarville Uni's DOWNLOAD - now, that's at the *right* price - but it needs a complete in-house person to keep the outlay *really* low... Users tend to spend a deal of money over time automating their requirements. to the extent, we found, where it falls into disfavour 'cos of the outside (me) cost to produce what we want.. Not prepared to invest in training for staff, not prepared to invest in outside assistance... The assumption is that the users are using Excel. I've taken some other advice on this forum to generate HTML which has had some success but is limited in ease of adding fields or making changes. Perhaps this is my opportunity to get into XML. DOWNLOAD *could* help you there, then an add on reporting facility with XML not an add in . In his original post, Barry was looking for an automatic autofit of data into Excel cells. Tony, in his reply, mentioned DIY XML. I'm assuming that Barry's .csv file/s are a regular occurrence and of a fixed layout. The easiest method we have used in these sorts of circumstances is an up front (saved) Excel macro to add in columns, format columns, add column headers, etc, etc, even to the extent of using Excel's macro recorder. So, it might take a couple of goes to get it right, but once it's there, it's there forever But, I suppose that'd apply to XML as well as .csv It works - and it's cheap Thanks Mark Johnson - Original Message - From: Tony Gravagno [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, October 23, 2005 5:46 PM Subject: RE: [U2] [UV][OT]Embed command in CSV file? [ad] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.361 / Virus Database: 267.12.4/146 - Release Date: 21/10/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.361 / Virus Database: 267.12.4/146 - Release Date: 21/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Double Indexes
Goo'day Mark, At 23:50 20/10/05 -0400, you wrote: I'm wondering if a UD or UV system behaves similarly to a D3 problem I see. File contains 6,000,000 records. First field is DATE and 2nd field is CUST. Both are INDEXed. SELECT FILE WITH DATE = 10.18 quickly returns 11,000 items CLEARSELECT SELECT FILE WITH CUST = 12345 quickly returns 180,000 items CLEARSELECT SELECT FILE WITH DATE = 10.18 AND CUST = 12345 takes forever as if the indexes aren't there. AFAIK, all MV variants only use the first iindex. If you try to use 2 indices, none are used. Must be documented. somewhere The old story applies: Use successive SELECTs to get the benefit of multiple indices I don't know if the double test in the SELECT statement ignores the INDEX on either (or the first) or is encumbered by taking the 11,000 quick DATE items and then hashingly goes through them looking for CUST. If I try SELECT FILE WITH DATE = 10.18 then SELECT FILE WITH CUST = 12345 it still takes longer than I would expect. Is a double INDEX a strange animal. Does U2 support indexing virtual fields, ie DATE.CUST? I don't think D3 can. Why not? The index is built on a DICT item. Wasn't there a discussion somewhere in the past week over indexing null items and the suggestion was to non-null them by adding something else to the key? Thanks in advance. Mark Johnson --- 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.360 / Virus Database: 267.12.4/145 - Release Date: 20/10/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.360 / Virus Database: 267.12.4/145 - Release Date: 20/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Translate question
Goo'day, Mark,At 23:16 17/10/05 -0400, you wrote: I've always used the OCONV(ID,TFILE;X;15;15) form for translates. What is the difference between the first and second '15's. I've seen X;;15 work and X;15 not work. The difference is in ICONV vs OCONV The first 15 is for ICONV's and the second 15 is for OCONV's AFAIK, standard over all implementations... HTH Thanks in advance. Mark Johnson --- 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.12.2/138 - Release Date: 17/10/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.12.2/138 - Release Date: 17/10/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.0.344 / Virus Database: 267.12.2/138 - Release Date: 17/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Date Conversion Codes - iconv
Goo'day, At 16:58 13/10/05 +1000, you wrote: -Original Message- From: [EMAIL PROTECTED] though ISO8601 requires iconv formating : iconv('2005-10-13','dymd') : at least when DATE.FORMAT is ON Ah!Somebody else been in the review compliant bucket this week. Why aren't ISO8601's hours, minutes and seconds back to front, too? -- -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.14/131 - Release Date: 12/10/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.0.344 / Virus Database: 267.11.14/131 - Release Date: 12/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OPEN vs TRANS
Goo'day, At 23:26 11/10/05 -0400, you wrote: I'm still trying to see how this is superior to a READ, which is entirely self-documenting and efficient, and doesn't require you to know about how TRANS behaves. I suspect that most programmers would have to look at the documentation or a help screen to know why you're doing a RAISE, and what the -1 and the 'x' are all about. Maybe I'm wrong about that. It's all neatly explained in HELP BASIC TRANS and I'd hazard that anybody that wanted to go down *that* road (the obfuscation path I'd call it) in their code would soon get used to t'syntax A line that starts out VAR= doesn't immediately say to me, here's where we're doing some I/O. If I'm searching a program for I/O statements, I'm not generally looking for something like this. There's also the overhead of doing the RAISE, which is only there to counteract the behavior of the TRANS. On small records this wouldn't be significant, but if you're processing many large records, it could make a difference. I'm not trying to be difficult here - I'm just trying to see the benefits of this alternative to a straightforward and standard approach. As far as I can see, the only benefit (???) *might* be that if the variable passed to a TRANS as the Item-ID for the file is a multi-valued list, the data returned is a list of fields for each item. This *might* have some benefit in timing. but for all I care, a READ is a READ is a READ (might even be a TRANS) regardless from whence it originates Hope I never get to having to squeeze the nth degree of timing out of anything I write. But, all that aside, I'm sure I can recall a UV support person (who shall remain nameless 'cos I can't remember who he/she is/was... Chris???. Trish??? - yep! that long ago) telling/advising that one shouldn't use TRANS for other than I-types... for some now obscure reason but I think slow was mentioned. Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- 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.14/129 - Release Date: 11/10/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.14/129 - Release Date: 11/10/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.0.344 / Virus Database: 267.11.14/129 - Release Date: 11/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printer problems on UV PE under Windows XP
Goo'day, Eric, At 12:39 12/10/05 -0400, you wrote: Jerry, I have a printer on XP called NORCRON which is the \\norcron-dev\NORCRON printer, however, in the SPOOL -LIST in universe, it shows as \\NORCRON-DEV\NORCRON ... NOT just NORCRON. Eric But have you started the printer a a LOCAL printer on the UV box? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, October 12, 2005 11:50 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Printer problems on UV PE under Windows XP You cannot use the full pathname in the setptr command only the name set up for the printer in XP under printers and faxes. That name must have no spaces in it and, if I remember correctly, a maximum of 8 characters. - Original Message - From: Eric Limbeek [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, October 12, 2005 9:02 AM Subject: RE: [U2] Printer problems on UV PE under Windows XP Bruce, Thanks for the input. The printer name does not have a space in it - it's a network printer called \\norcron-dev\NORCRON ... The setptr does not accept this name Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: Saturday, October 08, 2005 7:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Printer problems on UV PE under Windows XP We'll try again. Too much of a hurry to get to the first cuppa for the day At 08:01 09/10/05 +1000, I wrote: Goo'day, At 10:10 08/10/05 -0400, you wrote: Folks, I've been struggling to set up a printer. After much tweaking and twiddling, I finally can actually see the printer in U2ADMIN, but still can't seem to get anything to print to it. There'd have to be thousands of printer won't's in the archive probably too many. From the top: The first thing is Does the printer name have a space in it?UV doesn't like that.. As it is UV we're dealing with here, UVDEFAULT is probably the best name for a printer, providing, of course, (a) you don't already have a UVDEFAULT printer and (b) you don't mind this printer being UV's default printer. Secondly... You have a SETPTR somewhere where you're actually *starting* the printer, don't you? The SETPTR is a UniVerse verb If it's one of the el cheapo jet printers - or, actually, any jet printer - don't expect it to do any fancy printing: Under UV all you can get out of those sort of printers is a subset of PCL3... no lines, ergo, no boxes, very limited fonts, if any...About all you can get is some, very few, of the normal PCL stuff: IIRC you can go landscape/portrait and with the SETPTR GUI option you can set the font FONTNAME Courier New and size FONTSIZE 8 to permit using an A4 sheet landscape, with small print, to emulate a 15x11 sheet... SETPTR 0,,AT UVDEFAULT,GUI, FONTNAME Courier New,FONTSIZE 8 should get you somewhere. Provided you've named your printer UVDEFAULT. If you get sick of being prompted about setting the printer to:. you can add a ,BRIEF to the above command What sort of printer? UV or UD? Sorry about that Too early in the morning -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/124 - Release Date: 07/10/05 --- 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.13/124 - Release Date: 07/10/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.0.344 / Virus Database: 267.11.13/124 - Release Date: 07/10/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-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.14/131 - Release Date: 12/10/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.14/131 - Release Date: 12/10/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.0.344
Re: [U2] Fw: More U2 programming hints
) LOOP WHILE READNEXT ID READ REC FROM F, ID ELSE NULL REPEAT CRT 'I3', TIMEDATE(), SYSTEM(9) EXECUTED: OPEN [really big file] TO F ELSE STOP CRT 'E1', TIMEDATE(), SYSTEM(9) EXECUTE SELECT [really big file] CRT 'E2', TIMEDATE(), SYSTEM(9) LOOP WHILE READNEXT ID READ REC FROM F, ID ELSE NULL REPEAT CRT 'E3', TIMEDATE(), SYSTEM(9) (Run each a couple times, to allow for i/o differences in loading data buffer cache.) There should be virtually no elapsed time between I1:I2 above, but long elapsed time between E1:E2. I expect I2:I3 to approximately equal E2:E3. Let me explain why this is counter-intuitive. Normally, the BASIC SELECT statement itself does not actually do any select on the file. It merely sets things up behind the scenes so that subsequent READNEXTs each get the next id from the file opened to F.FILE, (next meaning as stored on disk). UV keeps track of where it is in the file, unbeknownst to you. Sorta like it keeps track of where it is for REMOVE or attribute-level EXTRACTs. Exceptions to internal being faster than executed: 1.SSELECT FILEVAR (i.e., 2 S's, SortSelect). You gotta read the whole file First to sort the keys. (and it's an alpha-type sort, even for numeric keys.) 2. $OPTIONS FESLECT Makes SELECT FILEVAR populate @SELECTED and to do so means traversing the file. 3. Louis Windsor. Poor bloke, they're out to get him. Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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.13/126 - Release Date: 09/10/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/126 - Release Date: 09/10/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.0.344 / Virus Database: 267.11.13/126 - Release Date: 09/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Printer problems on UV PE under Windows XP
Goo'day, At 10:10 08/10/05 -0400, you wrote: Folks, I've been struggling to set up a printer. After much tweaking and twiddling, I finally can actually see the printer in U2ADMIN, but still can't seem to get anything to print to it. There'd have to be thousands of printer won't's in the archive probably too many. From the top: The first thing is Does the printer name have a space in it?UV doesn't like that.. Secondly... You have a SETPTR somewhere where you're actually *starting* the printer, don't you? What sort of printer? UV or UD? Does anyone have a manual/ link to information to get this done? Is there some magic piece I'm missing? I posted this before and got no response - I assume this is because: A) It's a really complex thing and no-one knows the answer B) It's a really simple thing and no-one can believe I posted something so stupid C) It didn't get posted last time. Please could someone respond to this, just so I know it's at least making it to the list. Thanks Eric Eric Limbeek Norcron, Inc. 3700 Mansell Rd., Suite 220 Alpharetta, GA 30068 404 459-6500 / (fax) 404 459-6506 www.norcron.com Supply Chain and e-commerce Solutions --- 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.13/124 - Release Date: 07/10/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/124 - Release Date: 07/10/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.0.344 / Virus Database: 267.11.13/124 - Release Date: 07/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Printer problems on UV PE under Windows XP
We'll try again. Too much of a hurry to get to the first cuppa for the day At 08:01 09/10/05 +1000, I wrote: Goo'day, At 10:10 08/10/05 -0400, you wrote: Folks, I've been struggling to set up a printer. After much tweaking and twiddling, I finally can actually see the printer in U2ADMIN, but still can't seem to get anything to print to it. There'd have to be thousands of printer won't's in the archive probably too many. From the top: The first thing is Does the printer name have a space in it?UV doesn't like that.. As it is UV we're dealing with here, UVDEFAULT is probably the best name for a printer, providing, of course, (a) you don't already have a UVDEFAULT printer and (b) you don't mind this printer being UV's default printer. Secondly... You have a SETPTR somewhere where you're actually *starting* the printer, don't you? The SETPTR is a UniVerse verb If it's one of the el cheapo jet printers - or, actually, any jet printer - don't expect it to do any fancy printing: Under UV all you can get out of those sort of printers is a subset of PCL3... no lines, ergo, no boxes, very limited fonts, if any...About all you can get is some, very few, of the normal PCL stuff: IIRC you can go landscape/portrait and with the SETPTR GUI option you can set the font FONTNAME Courier New and size FONTSIZE 8 to permit using an A4 sheet landscape, with small print, to emulate a 15x11 sheet... SETPTR 0,,AT UVDEFAULT,GUI, FONTNAME Courier New,FONTSIZE 8 should get you somewhere. Provided you've named your printer UVDEFAULT. If you get sick of being prompted about setting the printer to:. you can add a ,BRIEF to the above command What sort of printer? UV or UD? Sorry about that Too early in the morning -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/124 - Release Date: 07/10/05 --- 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.13/124 - Release Date: 07/10/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.0.344 / Virus Database: 267.11.13/124 - Release Date: 07/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OPEN vs TRANS
Goo'day, At 14:50 07/10/05 -0700, you wrote: Being independent, you have to listen to what the *client* wants. Do they need me to spend an additional 40 hours at $110 an hour to make something run faster? Most clients say N!! My customers say it louder than that.. Allen www.tortillafc.com -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.13/124 - Release Date: 07/10/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.0.344 / Virus Database: 267.11.13/124 - Release Date: 07/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [OT] [U2] chance encounter with a u2 site
Goo'day, At 20:09 05/10/05 -0400, you wrote: ;-) I had to laugh when I walked into my camera store only to see an extremely old Ultimate terminal. That green screen popped out at me. Apparently someone had installed a simple POS system for him years ago and he had been performing the maintenance after self teaching himself PICK. Mate, it's a MUCH BIGGER shock when you walk into a business and find modules of YOUR OWN software running quite happily and you know nothing about the installation, the company, the owner, nothing. My friend uses it and he got it running for me, too. But, I'd like the company name changed Can you do that? Only happened once -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.10/120 - Release Date: 05/10/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.0.344 / Virus Database: 267.11.10/120 - Release Date: 05/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] the 4 letter word
Goo'day, Stuart, At 12:19 05/10/05 +1000, you wrote: I'd say it's more like collecting cigarette butts out of rubbish bins, wrapping the tobacco in old fish and chip paper and inhaling deeply... Just goes to show how much you know about the subject. grin You have to light it before inhaling. If you don't, it lasts a *bit* longer, but the full aroma and taste are just not there If you're an indigent nicotine addict, it's still satisfying, you get your hit no matter what and you don't care if anyone tells you otherwise. ;-) -Original Message- The-command-that-must-not-be-named is like a fine cigar. You know you shouldn't. You know it's bad for you. Nonetheless, it's satisfying when done right. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- 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.10/119 - Release Date: 04/10/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.10/119 - Release Date: 04/10/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.0.344 / Virus Database: 267.11.10/119 - Release Date: 04/10/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good Programming Practice Question.........
Goo'day, At 09:55 28/09/05 -0600, you wrote: I've got to disagree with this one. This is the job of your source code control system. I've seen applications which were commented in this manner over a number of years and they are almost unreadable due to the sheer volume of mod tags. We take the approach to keep the stamp and story at the top, but remove the tags after a while. -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of Marilyn Hilb Sent: Wednesday, September 28, 2005 8: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. [snip] --- 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.8/113 - Release Date: 27/09/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.8/113 - Release Date: 27/09/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.0.344 / Virus Database: 267.11.8/113 - Release Date: 27/09/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV User Name
Goo'day, At 15:20 22/09/05 -0700, you wrote: It works that way for us, too, although the Password *is* case sensitive. And if you're PTERM CASE INVERT (or probably more correctly, not PTERM CASE NOINVERT) it appears to be insensitive Go figure. Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Steve Moore [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, September 22, 2005 2:15 PM Subject: RE: [U2] UV User Name Windows is case insensitive for the username. What case was used when you created the user in windows, whether as a domain user or as a local user on the UV server? That is the case that shows in the user name field in UV, regardless of the case the user actually used to login with. Or at least that's the way it works for us! HTH, Steve -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Thursday, September 22, 2005 10:52 AM To: [EMAIL PROTECTED] Subject: [U2] UV User Name Dave, I understand where hostname and user name are gotten from, my question is: If I login as devadmin (Windows UV) why does the @ACCOUNT, LISTU, and PORT.STATUS show hostname\DEVadmin ? If I login as rcooper (Windows UV) UV shows RCooper. Is this a UV or OS function that changes the case, how is it controlled ? Does it seem to be happening to anybody else ? Thx, Rudy This is message has been scanned for viruses by Webshield E500, Groupshield for Exchange, and McAfee Virus Enterprise --- 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.5/110 - Release Date: 22/09/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 22/09/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.0.344 / Virus Database: 267.11.5/110 - Release Date: 22/09/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Are there any UniVerse / U2 Basic Language Self-Study materials? {Unclassified}
Goo'day, Ray, At 07:31 21/09/05 +1000, you wrote: Is PROF still out there and, if so, can someone who knows advise how to get a legal copy? Gosh! Haven't seen or heard of, or heard from, Warren Dickens in years! More years than I care to think about. --- 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.3/107 - Release Date: 20/09/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 20/09/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.0.344 / Virus Database: 267.11.3/107 - Release Date: 20/09/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] LPTR / SETPTR / print from a specific tray
0' 116: END 117: END 118: IF START.DATE NE END.DATE THEN 119: CMD:=' AND WITH DATE GE ':START.DATE:' AND WITH DATE LE ':END.DATE: '' 120: END ELSE 121: CMD:=' AND WITH DATE EQ ':START.DATE:'' 122: END 123: IF BEG.JOB.NUM # ALL THEN 124: CMD:=' AND WITH JOB GE ':BEG.JOB.NUM:' AND WITH JOB LE ': END.JOB.NUM:'' 125: END 126: CMD:=' ID-SUPP' 127: IF DEPT.IN http://DEPT.IN = 'ALL' THEN 128: CMD:=' BREAK-ON NP-DIV.DESC ':'V':'' 129: CMD:=' BREAK-ON NP-JOB.DESC ':'V':'' 130: END 131: CMD:=' JOB PROD JMT.R.S.ID http://JMT.R.S.ID WHSE CTR TYP CUST TRANS PERIOD DATE RC.JOB RC.TRAN' 132: CMD:=' TOTAL P.QTY TOTAL S.QTY UM TOTAL MATL.COST TOTAL SALE' 133: CMD:=' HEADING ':'TLC':' JOB MATERIAL HISTORY REPORT ':'LC' 134: CMD:=' PERIOD ':START.PERIOD:' THUR ':END.PERIOD:' - DATE ':START.DATE 135: CMD:=' THROUGH ':END.DATE: 'L':' GRAND-TOTAL' 136: CMD:=' TOTAL FOR COMPANY - ':'U':'' 137: CMD:=' LPTR ' 138: EXECUTE CMD CAPTURING ERRMSG I've checked numerous manuals and reference materials I have readily available to me and can't seem to find a decent example of what I'm trying to accomplish. I know I could re-write this report to not use the LIST ... LPTR statement but instead use PRINTER ON, PRINT, and PRINTER OFF commands...wanted to try avoid having to re-write the report at the present time though. TIA, Andy --- 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/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- 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.3/107 - Release Date: 20/09/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.3/107 - Release Date: 20/09/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.0.344 / Virus Database: 267.11.3/107 - Release Date: 20/09/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Are there any UniVerse / U2 Basic Language Self-Study materials? {Unclassified}
Goo'day, Mike, At 08:45 20/09/05 +1200, you wrote: Listers, I have a less-experienced member of my staff who needs to pass the IBM Certified Solutions Expert -- U2 Family Application Development [i.e. U2 Basic Language] exam. There are no practice exams available from IBM, and it seems very unlikely that the relevant training course will ever be offered in New Zealand, there just aren't enough people interested in attending. So, how does the poor guy get up to speed? * The PDF User Reference Manuals are not designed as instructional guides, and aren't particularly helpful from that point of view. * His supervisor (that's me, unfortunately for him) is not one of the world's great instructors either Are there any UniVerse / U2 Basic Language Self-Study materials out there in the market? CBT? Books? Yes, we would actually *pay* *actual* money* for something useful! :-) Have you looked at Jonathon Sisk's BASIC Programmers book. http://www.jes.com/pb/index.html It's not UV-centric, but it's a good place for you/somebody to start and mark the differences HTH Any help would be very gratefully received Thanks Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- 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.3/106 - Release Date: 19/09/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.3/106 - Release Date: 19/09/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.0.344 / Virus Database: 267.11.3/106 - Release Date: 19/09/05 --- 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'
Goo'day, At 13:53 16/09/05 -0400, you wrote: In a message dated 9/9/2005 6:57:29 PM Pacific Standard Time, [EMAIL PROTECTED] writes: So, now I wonder WHY - what is it about ZoneAlarm and/or other firewall software that might cause this degredation in performance of DC? I suggest that certain software that is supposed to be looking for viral particles is hindered by the nature of many Pick filestructures. It would not be uncommon in Pick to have files that are hundreds of megabytes large. If, each time one of these files *changes* that triggers a police-program to re-check it to see if it now contains a virus that could be a major source of slowness. T'was pointed out to me years ago when I first raised this DC hesitation problem that went away if one disconnected ZoneAlarm Pro, or even used the freebie ZA, that nagling was the source of the problem I'll leave it to someone better qualified than me to explain that.. snip -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 16/09/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.0.344 / Virus Database: 267.11.1/104 - Release Date: 16/09/05 --- 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'
Goo'day, Joe, I've been walking around for 2 days trying to think of THE word, and it has finally come to me... Nagle. We had this issue with Dynamic Connect a few years ago An Infocus search today brought this back: Quite some time (some time within the past 4 years) ago I posed a question to the group regarding half-screen jerkiness as a result of UniVerse (9.6 IIRC) on NT4 and Dynamic Connect, and if I remember correctly ZoneAlarm PRO.. The freebie ZoneAlarm didn't exhibit the problem, only the PRO version. Similarly, wIntegrate doesn't exhibit the problem - only Dynamic Connect IIRC it is/was some sort of timing problem, and our customer was badly affected - one second delay half-way down the screen - predominantly when painting menu screens from PROCS I cannot recall the exact definition but a trawl through Infocus might bring something up At that time the word nagle (or nagling - I still don't quite understand what it means) came up and we had to live with it by upgrading one box form DC to wIntegrate A better Infocus search might reveal more.. HTH At 21:49 09/09/05 -0400, you wrote: Found the cause of problem. Thanks for the feedback everyone. snip -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.20/95 - Release Date: 09/09/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.0.344 / Virus Database: 267.10.20/95 - Release Date: 09/09/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Listserver is Bowdlerising my posts... help
Goo'day, Stuart, At 13:08 09/09/05 +1000, you wrote: I have tried plain text - but even that gets chomped (sometimes) S Perhaps the list's own personal tooth fairy is cutting out all the waffley bits.g ... Sorry! -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.19/93 - Release Date: 08/09/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.0.344 / Virus Database: 267.10.19/93 - Release Date: 08/09/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Formatting Data
Goo'day, I'll include asnippet of ours that works a treat in situations like this: * THIS.DESC = FMT(TRIM(THIS.DESC),27T) THIS.DESC = CHANGE(THIS.DESC,@TM,@VM) * X = DCOUNT(THIS.DESC,@VM) FOR I = 1 TO X PRINT ON 1 THIS.DESC1,1'L#27' NEXT I * where we have a long description that we want to break up over multiple lines, breaking the lines on spaces (word boundaries) at or up to the 27th character. At 16:44 24/08/05 -0500, you wrote: Yesterday I posed the question about reformatting a multi-value down to l or more lines of no more than 55 characters each. I received some great suggestions, but I can't get them to work. The FMT command doesn't seem to want to return anthing more than the first 55 characters. Below I have mocked up comments coming in and how I need them to reformat. I have tried converting all the sub-value marks to spaces and then using FMT. I have tried FMT without converting the sub-value marks. Nothing seems to work. Any help would be appreciated. snip -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.15/81 - Release Date: 24/08/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.0.344 / Virus Database: 267.10.15/81 - Release Date: 24/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: [U2} Formatting data...
Oops!Sorry 1,1 should be 1,I for the sharp-eyed among us... I'll include a snippet of ours that works a treat in situations like this: * THIS.DESC = FMT(TRIM(THIS.DESC),27T) THIS.DESC = CHANGE(THIS.DESC,@TM,@VM) * X = DCOUNT(THIS.DESC,@VM) FOR I = 1 TO X PRINT ON 1 THIS.DESC1,I'L#27' NEXT I * 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.0.344 / Virus Database: 267.10.15/81 - Release Date: 24/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [AD] Position Vacant - Newcastle - Australia
And what's the weather like today? At 10:57 23/08/05 +1000, you wrote: We are at it again! If you would like the opportunity to work as part of a small, highly productive and motivated team using cutting edge technologies, send us a copy of your CV/Resume. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.14/79 - Release Date: 22/08/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.0.338 / Virus Database: 267.10.14/79 - Release Date: 22/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [Maybe spam] RE: [U2] Remove Scenario
Goo'day, Will At 13:27 12/08/05 -0400, you wrote: 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. Ah yes, but If you're walking through and you see a CUSTdotwhatever you *know* - or at least you *should* know, if you're at *that* level - that CUSTdotwhatever is, the CUSTomer record and whatever refers to a particular field. Ergo: In RAID, CUST(field)/ gives the required response.. No downsides just another* way.. So is there a downside to using a construct like A.CUST.ADDRESS = 40 CUST.RECA.CUST.ADDRESS = 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 12/08/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.8/71 - Release Date: 12/08/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.0.338 / Virus Database: 267.10.8/71 - Release Date: 12/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Remove Scenario
Goo'day, Mark, Off the top of the head - your numbers are boggling. And you don't want *another* array with only the unpaid invoices in it? Then you write to *this* array only when you create an invoice and delete from it only when the invoice is fully paid? Or some such? Wastes disk capacity but saves time At 00:25 12/08/05 -0400, you wrote: Here's a doozy. Thanks for the previous suggestion of using REMOVE instead of the extractions. That's working very well. New problem. snip -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.7/70 - Release Date: 11/08/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.0.338 / Virus Database: 267.10.7/70 - Release Date: 11/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] New UV Accout VOC
Goo'day, Bill and Will At 01:41 10/08/05 -0400, you wrote: In a message dated 8/9/2005 8:04:38 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: ED VOC FILENAME 1: F 2: FILENAME 3: D_FILENAME 3. Thus, further commentary would be appreciated. --Bill Bill these sorts of F pointers where attribute 2 is some short thing like MONKEY001 instead of something long like D:\mydir\myotherdir\mymonkey are relative path names. The files they point at, must be present in the local directory of the account. What you've done is copy the File Pointers, but not the files themselves. For each of these files, you need to do a CREATE-FILE MONKEY or whatever the file is named. That will allow you to create these files in a test location with sizes other than what production has. E... Not quite a complete enough explanation, Will.. You'll have to delete the Q-Pointers first, before you CREATE.FILE for a file with the same name otherwise you'll get this response: CREATE-FILE PLTRANS 1 1 PLTRANS is already in your VOC file as a type Q record. File not created. Ergo, failure! snip -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/67 - Release Date: 09/08/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.0.338 / Virus Database: 267.10.5/67 - Release Date: 09/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] SELECT without
Goo'day, At 10:43 11/08/05 +1000, you wrote: I think its COUNT.SUP Still doesn't work Check HELP SELECT Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of rbl000 Sent: Thursday, 11 August 2005 9:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] SELECT without You mean something other than HUSH ON followed by the select, etc., followed by HUSH OFF? Sincerely Best Regards, Richard Lewis Sr Programmer/Analyst Nu Skin Enterprises [EMAIL PROTECTED] Barry queried: When executing SELECT from a PA, is there some keyword that will suppress the message n records selected to select list 0. Because if there is, I can't find it. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/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.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] SELECT without n records selected...
Goo'day Adrian,At 10:53 11/08/05 +0800, you wrote: Very strange that it doesn't work... I wrote a quick paragraph... 1: PA 2: SELECT VOC SAMPLE 5 COUNT.SUP and I receive no message regarding number of records selected. Mate, I take it all back: 14:01:12 11 AUG 2005 SELECT SLMASTER COUNT.SUP Oops!Mea culpa! Is it a GET.LIST rather than a SELECT that's producing the message? COUNT.SUP doesn't seem to work with GET.LIST. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: Thursday, 11 August 2005 9:49 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] SELECT without n records selected... Goo'day, At 08:49 11/08/05 +0800, you wrote: How about using the COUNT.SUP keyword? Try it. I did. Doesn't work Check HELP SELECT. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, 11 August 2005 7:11 AM To: U2-users (E-mail) Subject: [U2] [UV] SELECT without n records selected... When executing SELECT from a PA, is there some keyword that will suppress the message n records selected to select list 0. Because if there is, I can't find it. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- 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.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/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.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- 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.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/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.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] get program name
Goo'day, again, Mark, At 00:37 30/07/05 -0400, you wrote: Migrating from native systems to contemporary systems usually involves a study looking for user exits. Most don't go beyond U50BB or other popular ones (sleep comes to mind). When the USER-COLDSTART includes MLOADs or other custom user exit references, then I'll have to get deeper. I reckon if you're going deeper on MLOAD you'll never get back up. Bring out the Pick Assembler book.Bloody hell! Where do you start from in this thing, again??? But Martin has even bowed to Pick pressure and given us a standard 50BB in QM after he told me to write one yerself Thanks. No probs. - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, July 29, 2005 10:57 PM Subject: Re: [U2] [UV] get program name Goo'day, Mark, At 19:39 29/07/05 -0400, you wrote: Are user exits in U2 fixed in their collection or are they existing in the form that they used to be. IIRC one of my native prospects is still on their prior systems and they mentioned that they had some custom user exits created for them. I know that I probably can replace their function, but I wonder if the mechanism for creating user exits exists on u2. Have a look at APP.PROGS in UV account.. Wh! Just asking. Thanks. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/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.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/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.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] get program name
Goo'day, Mark, At 19:39 29/07/05 -0400, you wrote: Are user exits in U2 fixed in their collection or are they existing in the form that they used to be. IIRC one of my native prospects is still on their prior systems and they mentioned that they had some custom user exits created for them. I know that I probably can replace their function, but I wonder if the mechanism for creating user exits exists on u2. Have a look at APP.PROGS in UV account.. Wh! Just asking. Thanks. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/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.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Personal edition
Goo'day, Last time I looked, not too recently, there was a modulo/separation maximum... And, probably more importantly, isn't u2 PE for private, ie, non-commercial use only?? Might be a spot of bother on both counts. At 11:17 29/07/05 +1200, you wrote: Hi -- we are looking at decomissioning one of our unidata apps but we need to keep the data around for tax department access and occasional queries and reports Only 1 or 2 users. Would PE be a good tool for this? What sort of GUI query tools would be available? Thanks # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. --- 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.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/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.0.338 / Virus Database: 267.9.7/60 - Release Date: 28/07/05 --- 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 local PC
Goo'day, At 16:06 27/07/05 -0700, you wrote: Are there any utilities to pass as comma delimited file from Unidata/Universe and have it open/imported into Excel? If you're using the normal terminal emulators, eg AccuTerm, wIntegrate and whatever HostAccess is called these days, there are the built-in communication MV to desktop Import/Export utilities with them - menu-driven, and all.. If you're not using *them* then you can always write a program to build a .csv file and WRITESEQ it away. Does your implementation support a Query DELIMITER statement?If so, you can put together a RetrieVe sentence and print it to file, by preceeding your sentence activation with a SETPTR ie, SETPTR 0,3,.. (note that's 5 commas, 3) with DELIMITER set to comma, tab, whatever. Or you can get DOWNLOAD from, IIRC, cedarville . and use that.. I dare say, others will come up with even more options 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 27/07/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.6/59 - Release Date: 27/07/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.0.338 / Virus Database: 267.9.6/59 - Release Date: 27/07/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] String compare anomaly {Unclassified}
Goo'day, Wol At 22:46 08/07/05 +0100, you wrote: Isnip As I say, I thought it came from over the pond - looks like I might have been wrong ... Just like billion . We have a perfectly good language and somebody comes along and buggers it up grin Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony W. Youngman Sent: Thursday, July 07, 2005 05:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] String compare anomaly {Unclassified} In message [EMAIL PROTECTED], gerry-u2ug [EMAIL PROTECTED] writes american notation is to use a space as a thousands separator - on which planet is that ? Apologies if I'm wrong, but European usage has always been 1.234,56 while British usage was 1,234.56. Our usage has changed to 1 234.56 and I thought we'd imported it from America, like so many other things... Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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.323 / Virus Database: 267.8.11/44 - Release Date: 08/07/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.11/44 - Release Date: 08/07/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.0.323 / Virus Database: 267.8.11/44 - Release Date: 08/07/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT: London
Goo'day, Matti, At 23:02 07/07/05 +0100, you wrote: snip there will be some attempts to insist that we introduce more authoritarian measures like ID cards, until it becomes clear that they wouldn't make a blind bit of difference. Ah, but they do. They increase the number of criminal offences with which one can be charged ... and that's all ... But, bureaucratic bliss... we've done everything we possibly canwe've legislated for . -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.10/43 - Release Date: 06/07/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.0.323 / Virus Database: 267.8.10/43 - Release Date: 06/07/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] - Determining time sequence
Goo'day, Ross...At 08:50 01/07/05 +1000, you wrote: the god news is that he now has multiple alternatives to trial. Probably have to wait until Eastergrin Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, 30 June 2005 12:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] - Determining time sequence Ross, I'm not derogating the use of sequential IDs but IIRC, the bloke had a reason not to use a sequential id counter and wanted an alternative. The uuid spec states that uuid should cater for time adjustments on the local clock, hence, shouldn't be vulnerable (Of course, in the real world, that depends on how the spec has been implimented). The uuid can be sequentialised and can gauranteed to be unique to a high degree of certainty in time and space. There are no locking or contention issues when a uuid is generated opposed to a heavily used key generator. I stand by my assertion that a uuid is a viable and justifiable solution in the original posters problem space. ;-) Cheers, Stuart [EMAIL PROTECTED] wrote: - This would still make things vulnerable whenever date/time changed on the generating machine the beauty of the sequential ID is that fact that nit WILL be in real time order, regardless of what people do with dae time of the machine ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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.323 / Virus Database: 267.8.7/34 - Release Date: 29/06/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.7/34 - Release Date: 29/06/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.0.323 / Virus Database: 267.8.7/34 - Release Date: 29/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] - Determining time sequence
Goo'day, At 10:42 28/06/05 +1000, you wrote: And how many milliseconds are you allowing in each second Mike? 1000/18 ~= 55 I knew Wellington had its charms, but time going past 10 times more quickly wasn't one that sprang to my mind first ;^) So *that's* why they all look so old and wrinkled. Apparantly nothing to do with the cold at all..grin Cheers, Ken --- 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.323 / Virus Database: 267.8.4/31 - Release Date: 27/06/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.4/31 - Release Date: 27/06/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.0.323 / Virus Database: 267.8.4/31 - Release Date: 27/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AD: UniVerse Analyst/Programmer Required - Wellington, N ew Zealan d
Goo'day, Sara, slightly windy??? What the blazes would windy be??? A Force 10 gale??? At 12:18 17/06/05 +1200, you wrote: Ray wrote - Wellington in winter?!! Brr-rr-rr!!! I must respond to Ray - who has visited us a number of times. This morning I came to work with a beautiful blue sky, sun shining, harbour sparkling. It is almost the shortest day and there was a slight frost. For those that don't know (including our friends over the water in West Island commonly known as Australia), Wellington is very much like San Francisco in more ways than one. Similar geography and climate. Situated at the bottom of the North Island we are surrounded by ocean. This means the climate is temperate and slightly windy. Wellington does not have any pollution. Sara Sara Burns (SEB) Integration Manager Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. Ask us how you can protect your children's future with a family trust from Public Trust. Call 0800 505 405 to request your free copy of our family trust guide. --- 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.323 / Virus Database: 267.7.7/20 - Release Date: 16/06/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.7/20 - Release Date: 16/06/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.0.323 / Virus Database: 267.7.7/20 - Release Date: 16/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] How to release locks (LIST.READU)
Goo'day, At 10:44 15/06/05 -0400, you wrote: Hi Martin, I agree. Personally, I always use UNLOCK USER [userno] [option]. The poster stated: I tried to CLEAR all the locks but was not able to do that. The poster seemed to state that he wished to clear all locks. He might've stated that he wished to clear all locks, but the very nature of his original question showed he appeared to have minimal knowldge of the various locking mechanisms, and therefore IMHO any and all whoa! and lesser cautionary messages, are indeed, more than apt! How many times have we all heard But, he said to do ... just after a catastrophe? -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.5/18 - Release Date: 15/06/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.0.323 / Virus Database: 267.7.5/18 - Release Date: 15/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Help with @RECORD
Goo'day, Barry AFAIK, @RECORD is the data of the record being processed by an I-type function. Therefore you don't have to OPEN the file, or READ the @RECORD, eg: DICT FNAME COST 0001 I 0002 @RECORD3 * @RECORD5 0003 MR2.. etc, etc or DICT FNAME ANOTHER.COST 0001 I 0002 SUBR(MY.SUB,@RECORD) 0003 MR2.. etc etc where MY.SUB starts ofF: 0001 SUBROUTINE MY.SUB(X,REC) 0002 X = '' 0003 CNT = DCOUNT(REC3,@VM) 0004 FOR I = 1 TO CNT 0005 X += REC3,I * REC5,I 0006 NEXT I 0007 RETURN At 18:16 13/06/05 -0700, you wrote: UV 9.6.1.3 on W2K. What's the right way to use @RECORD? I can do- Snip No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/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.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
Goo'day, Bob, At 19:44 13/06/05 -0700, you wrote: Come on, people. A request was made for options. I guess I'm one of those to whom you are referring. Please accept my abject apologies. However, in my defence, and in defence of those others, I'll add that the discourse started with options and then evolved in to SOX and auditors. Your offering came after that, so my (and, I assume, others) response was geared towards the latest level of the discussion. snip Now if you have something better, offer it up! The original poster wants options, so lend a hand instead of a finger. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Steve Johnson Sent: Monday, June 13, 2005 4:29 PM To: U2UG Subject: Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... But this would not keep those pesky auditors happy. In the following sequence, how could they know that item 1*4 was missing? 1*1 1*2 1*3 2*1 etc. Regards, Steve Johnson FXA Group Ltd Bangkok [snip] --- 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.323 / Virus Database: 267.7.0 - Release Date: 13/06/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/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.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Finding last day of month
Oh dear, Oh dear! What ever happend to : DATE = '' FOR I = 31 TO 28 STEP -1 IF OCONV(ICONV(I:rest of date,'D'),'D') = I:rest of date THEN DATE = I:rest of date EXIT END NEXT I IF DATE = '' THEN Come to screeching HALT Of course for the people with backward dates (!!!), the I:rest of date would look like MONTH:I:YEAR with the appropriate separators, wouldn't it At 17:01 02/06/05 -0400, you wrote: I use the method my dad taught me when I was a kid, cuz I couldn't remember Thiry days hath September Hold 2 fists side-by-side, forefingers of right left hand touching. Each knuckle and each valley between knuckles represents a month. Start at the left pinky knuckle and count off months. If a month lands on a knuckle, it has 31 days. If it lands on a valley, it has 30 days. (Except February has that 28/29 thing going on.) _ _ _ _ _ _ _ _ /J\_/M\_/M\_/J\/A\_/O\_/D\_/ \ | F A J || S N | | || | | || | \ / \/ \ / \ / | left | | right | | fist | | fist | view from top QED --- 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.323 / Virus Database: 267.5.0 - Release Date: 02/06/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.5.0 - Release Date: 02/06/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.0.323 / Virus Database: 267.5.0 - Release Date: 02/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2 XML./DB Tool
Goo'day, Phil, At 09:54 27/05/05 +1200, you wrote: Hi, I have just tried using the U2 XML/DB Tool on an existing account and it does not work. After looking at other accounts on which it did work, I started to suspect it is because the account is pick flavour. so I created a dummy account as (newacc) ideal flavour and the tool connects and appears to work, however if I change the flavour of the dummy account to pick the tool stops working, changing it back gets it working again. Questions: 1. Has anyone else used the tool? 2. If so, were they able to get it working on a PICK flavour account? 3. IBM, why would the flavour of an account effect the use of a client tool such as U2 XML/DB Tool? Is this a design oversight? - or was it assumed that users would change the account flavour, something I won't be doing as who knows what might break in the application which is written by another party. 4. Any suggestions to get this tool working in a PICK account? Other than an empty Ideal account full of Q-pointers to your Pick account, no Cheers, Phil. --- 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.322 / Virus Database: 266.11.17 - Release Date: 25/05/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.322 / Virus Database: 266.11.17 - Release Date: 25/05/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.0.322 / Virus Database: 266.11.17 - Release Date: 25/05/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unix copying Universe files
Goo'day, Scott At 23:52 11/05/05 +, you wrote: Hi All, UV9.6 HPUX 11 I have a program that I use to update our test account from time to time using the unix cp command. It works fine except... Every once in a while I run into a corrupted file. I am guessing that it is because the file has yet to be written to disk. Has anyone out there had success in routinely copying files in this manner? Would it help if I issued a sync? Any help would be greatly appreciated. Are you sure everybody's logged off.. and kept off.. for the duration of cp??? -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/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.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/05 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] color laserjet pcl programming for logos
Goo'day, At 11:57 21/04/05 -0700, you wrote: Hi ALL: I have some forms that print to HP printers using standard PCL formatting codes. We now have a requirement for certain areas to be in color and I'm having a problem getting my PCL codes correct for printing on an actual HP (or compatible) printer. I'm using the following PCL commands within a basic program: ESC * r -3 U select simple cmyk color palette ESC * v 3 Sselect blue foreground color This code works correctly when I run the output through visual software's PCL to PDF converter. I get my graphics and my selected text in blue. However, when I print direct to the printer, I get a lot of the logo in blue, but rectangular portions of the logo in black as if the raster portions are ignoring my color selection. Just wanting to know if someone else out there has successfully implemented PCL coloring. We have given up on this sort of thing. PCL to logos, etc, b/w or colour - colour is worse than b/w At least for now We have found the cheapest, easiest, best to be A4 pre-printed with logo - just the logo - and a second bin on the printer... That pre-printed form is then the basis for all printing - invoices, statements, what-have-you . Lines, letters and numbers - tremendous under PCL, but past that.. The cost of a (good) colour laser, toner, etc, and with the vagaries of colour in just the right proportions is just not worth the effort. We are now of the opinion we supply software to the customer or we spend the rest of our life fiddling and farting about trying to get it just right to the end users' satisfaction. And the ones who want it just right usually have the mongrel-est of logos!!! I wish you well... Using postscript on these printers is not an option since I'm already using PCL to generate all the other formatting. Thanks! -Troy --- 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.308 / Virus Database: 266.10.1 - Release Date: 20/04/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.10.1 - Release Date: 20/04/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.0.308 / Virus Database: 266.10.1 - Release Date: 20/04/05 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.10.1 - Release Date: 20/04/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] SQL DELETE on type 19 file
Goo'day, Stuart, At 10:59 07/04/05 +1000, you wrote: Does anyone know why you can do a SQL SELECT but UV restricts you from doing a SQL DELETE on a type 1 or 19 file??? Usually to stop *me* from doing silly things. grin .. they *really do* know, somehow.. But, other than that, I can't really help you .. but IIRC, waay back, Ray Wurlod (or some other extermely knowledgeable person) spoke of this yonks ago would have to have been about 4 or 5 years ago Archives??? -- Regards, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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.308 / Virus Database: 266.9.4 - Release Date: 06/04/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 06/04/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.0.308 / Virus Database: 266.9.4 - Release Date: 06/04/05 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 06/04/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] non-numeric error after passing (ANS MATCHES '0N' ANS0)
Goo'day, Charles, At 18:25 08/03/05 -0500, you wrote: The relevant code ( I am VERY sure source matches object): 072: BEGIN CASE 073: CASE ANS MATCHES '0N' ANS0 074: IF MITM5,ANS# THEN 075: IF MITM7,ANS# THEN GOSUB 200 ; IF ERR THEN GOTO 15 287: 200:*Subroutine For Password Check. 291: IF MITM7,ANS[1,1] = # THEN 310: IF X#MITM7,ANS THEN 4 times in recent months line these have generated the a set of 4 runtime errors Nonnumeric data when numeric required. Zero used. as recorded in uv/errlog: Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 74, Message[040025] Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 75, Message[040025] Mon Mar 7 14:04:03 78 wrc63580 Program MENU.DRIVER: Line 291, Message[040025] Mon Mar 7 14:04:06 78 wrc63580 Program MENU.DRIVER: Line 310, Message[040025] (See SYS.MESSAGES 040025) The only operation on all four lines that requires a numeric is using ANS as the value number in the EXTRACT(). ANS is non-numeric ??? - But how can a non-numeric string get past the test on line 73, (ANS MATCHES '0N' ANS0) ? - Can a non-numeric both match 0N and also be greater than zero? Something involving spaces or ^128, maybe? That's the most likely line of enquiry, as I see it. Quite some time ago, UV 9.something on NT4, IIRC, we had a similar instance and it seemed to come from an accidental keyboarded Ctrl sequence - happened a few times at one site - which UV interpreted as numeric/non numeric depending on the source statement. Different statements seemed to give different responsesWe never got to the bottom of it properly - we changed the code to check for numerics at point of input. This is in our top level menu driver that every interactive user runs. These lines get executed countless times each day, but with only four such errors incidents since last September. Am I missing something glaringly obvious? Any answers? cds --- 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.308 / Virus Database: 266.6.4 - Release Date: 07/03/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/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.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/05 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 07/03/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] making 00001 our of 1
Goo'day, X = STR(0,5-LEN(X)):X At 21:30 02/03/05 +, you wrote: Hi all, I have a need to search through our program files for any code that format a number from 1 through 9 with leading 0's. I have always used R%5 but I may miss programs that use other techniques to arrive at the same result. Can someone give me examples that they have seen for changing 1 to 1? Thanks much, Scott --- 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.308 / Virus Database: 266.5.7 - Release Date: 01/03/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.5.7 - Release Date: 01/03/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.0.308 / Virus Database: 266.5.7 - Release Date: 01/03/05 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.5.7 - Release Date: 01/03/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] uv pe
Goo'day, At 10:40 18/02/05 +1100, you wrote: John, I want to do). The best answer I got was create a virtual field that stored the field in caps and then use that in the select. In fact, the example in an old Unidata manual I found says to do just that. Perhaps there is good reasoning behind that method, but the logic of it completely escapes me. when you create a dictionary entry like this, the data is not stored but generated at run time. In UV (I don't know about UD) you can also use the EVAL statement in a SELECT which does this kind of thing at runtime eg: SELECT MYFILE WITH EVAL UPCASE(@ID) LIKE ...HELLO... Works on UniVerse. Have a look at HELP EVAL from TCL. Or, you could use a MCU conversion .. Craig --- 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.306 / Virus Database: 265.8.9 - Release Date: 17/02/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 265.8.9 - Release Date: 17/02/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.0.306 / Virus Database: 265.8.9 - Release Date: 17/02/05 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 265.8.9 - Release Date: 17/02/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/