Re: [U2] REMOVE results as promised.
I tried that method (styles 7 8) and got a longer time. Perhaps my test system isn't as fast (workload?) and as such, allowed the differences to be more pronounced. Here's my fastest version DIM A(5) ; MAT A= FOR I=1 TO 5 A(I)=I NEXT I B=A CONVERT 254 TO 253 IN B ;* LOWER (sic) Your method has 5 (49,999) extraneous IF statements that I would have considered detrimental. I'll try it verbatim on the same system and get back to you. In case anyone cares about the system's workload, I tried each test several times in an out of sequence to post their average times. It ain't a virtual memory issue like years (decades) ago. Thanks. - Original Message - From: Dzevad Dizdar [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, August 22, 2005 12:27 AM Subject: Re: [U2] REMOVE results as promised. Hi Mark, There is another fast method to consider A= FOR I=1 TO 5 IF A = THEN A := I END ELSE A := @VM : I END NEXT I It will take less then 1 second to finish on our system. Dzevad - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, August 21, 2005 12:27 PM Subject: [U2] REMOVE results as promised. As promised, here are the results of 9 different methods of appending. Basically program went like this: A= FOR I=1 TO 5 A1,-1=I NEXT I Style 1: 1,-1 straight...1 minute, 29 seconds Style 2: -1 attribute level then CONVERT to 253...41 seconds Style 3: DIM(50,000), MATWRITE, READ CONVERT.2 seconds Style 4: DIM(50,000), then assign to variable and CONVERT to 2531 second Style 5: Target = null, [] replacing40 seconds Style 6: Target=Space(100), [] replacing then TRIM8 minutes, 55 seconds. Style 7: Append, VM assigned inside loop..41 seconds Style 8: Append, VM assigned outside loop then remove last..34 seconds. Style 9: 1,MV with MV+=MV as pointer.1 minute, 28 seconds 60 user D3 system on W2000 during normal business day. It appears that Styles 3 4 escaped the suggestions and rose to the top. Apparently the CONVERT (or RAISE/LOWER) functions are pretty quick. The DIM is incredibly quick. I learned a lot and hope others can as well. Thanks for everyone's suggestions. Mark Johnson If anyone wants further coding for any of the styles then don't hestitate to ask. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] REMOVE results as promised.
Not that it seems to matter these days but both this method and the ..-1 notation (which is an implicit form of the same thing) could be said to be needlessly evaluating whether or not A is null 49,999 times. An alternative would be : A = 1 FOR I = 2 TO 5 A := @VM : I NEXT I I also found (many years ago) that :- A = '' FOR I = 1 TO 5 A:= @VM : I NEXT I DEL A1,1,0 or A = A[2,99] was faster than repeatedly testing whether A was null Piers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dzevad Dizdar Sent: Monday, August 22, 2005 05:27 To: u2-users@listserver.u2ug.org Subject: Re: [U2] REMOVE results as promised. Hi Mark, There is another fast method to consider A= FOR I=1 TO 5 IF A = THEN A := I END ELSE A := @VM : I END NEXT I It will take less then 1 second to finish on our system. Dzevad --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] REMOVE results as promised.
Which platforms don't support system(11)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dzevad Dizdar Sent: Monday, August 22, 2005 12:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] REMOVE results as promised. Hi Mark, There is another fast method to consider A= FOR I=1 TO 5 IF A = THEN A := I END ELSE A := @VM : I END NEXT I It will take less then 1 second to finish on our system. Dzevad - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, August 21, 2005 12:27 PM Subject: [U2] REMOVE results as promised. As promised, here are the results of 9 different methods of appending. Basically program went like this: A= FOR I=1 TO 5 A1,-1=I NEXT I Style 1: 1,-1 straight...1 minute, 29 seconds Style 2: -1 attribute level then CONVERT to 253...41 seconds Style 3: DIM(50,000), MATWRITE, READ CONVERT.2 seconds Style 4: DIM(50,000), then assign to variable and CONVERT to 2531 second Style 5: Target = null, [] replacing40 seconds Style 6: Target=Space(100), [] replacing then TRIM8 minutes, 55 seconds. Style 7: Append, VM assigned inside loop..41 seconds Style 8: Append, VM assigned outside loop then remove last..34 seconds. Style 9: 1,MV with MV+=MV as pointer.1 minute, 28 seconds 60 user D3 system on W2000 during normal business day. It appears that Styles 3 4 escaped the suggestions and rose to the top. Apparently the CONVERT (or RAISE/LOWER) functions are pretty quick. The DIM is incredibly quick. I learned a lot and hope others can as well. Thanks for everyone's suggestions. Mark Johnson If anyone wants further coding for any of the styles then don't hestitate to ask. --- 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] REMOVE results as promised.
Note that Mark is reporting results from D3. A= FOR I=1 TO 5 A1,-1=I NEXT I Style 2: -1 attribute level then CONVERT to 253...41 seconds UniVerse caches the last-accessed field position in a dynamic array. On my 1.7 GHz pentium laptop, 0001: A = 0002: S = system(9) 0003: for I = 1 to 5 0004:A-1 = I 0005: next I 0006: E = system(9) 0007: print E-S reports 40, but that is in milliseconds. Appending a 0 to make a loop iteration count of 500,000 0001: A = 0002: S = system(9) 0003: for I = 1 to 50 0004:A-1 = I 0005: next I 0006: E = system(9) 0007: print E-S yields a result of 4.447 seconds. Mark A. Baldridge Principal Consultant North American Lab Services DB2 Information Management, IBM Software Group (607) 351-5666 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] REMOVE results as promised.
My results were different. Substring assignment is very fast, but not as fast as -1 and CONVERT. *** * substring assignment *** STIME = TIME() ITEM = SPACE(99) PTR = 0 FOR J = 1 TO 5 L = LEN(J)+1 ITEM[1+PTR,L] = J:@VM PTR += L NEXT J ITEM = ITEM[1,PTR-1] ETIME = TIME() - STIME DISPLAY ETIME ; * 0.141 seconds FAST! *** * field append *** STIME = TIME() ITEM = FOR J = 1 TO 5 ITEM-1 = J NEXT J CONVERT @FM TO @VM IN ITEM ETIME = TIME() - STIME DISPLAY ETIME ; * 0.062 seconds FASTER! *** * value append *** STIME = TIME() ITEM = FOR J = 1 TO 5 ITEM1,-1 = J NEXT J ETIME = TIME() - STIME DISPLAY ETIME ; * 72.5 seconds UGH! END --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Problems with uvrestore
I am trying to restore a backup from a UV 10 system running on AIX to a UV 10 system running on Windows. I can run the uvrestore -i command just fine but when I try to run the actual restore I get the following error: Unhandled exception raised at address 0x101F4198 : Access violation Attempted to read from address 0x Aborting UniVerse. I am running 10.1.3 on Windows and the backup was done on a 10.1.something on AIX. Any ideas? Thanks in advance, Jay Jay Falck, CISSP, CHSS Unicorn Computing 512-563-4132 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Trend to SHIMS conversion
I am looking for someone in the Detroit area that has a working knowledge of the SHIMS software. We are converting data from the Trend software into SHIMS. This person/company would need to be available this week on site. We are also looking for possible long term/permanent programmer. Please include your email or phone number to be contacted. CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to John Deere Landscapes, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Formatting Help
I have a multi-value field within a multi-value field (sub-values). The length of each sub-value can be up to 70 characters. I need to reformat and print the value so that each sub-value is no longer than 55 characters. To complicate matters I need to know ahead of time how many lines the reformatted value takes up so that if it's greater than the page length I can do a page eject and new headings before I print the value. I've never do this before so how should I approach this? Al DeWitt Stylmark, Inc. 763-574-8705 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Help
Are you wanting to do a word-wrap somewhere around the 55th character of each subvalue? In other words, if I have two subvalues in one value where the first one is 69 characters and the second is 45, is it acceptable that you end up with three subvalues (one ~55, next ~15, and then the next being 45)? Or are you wanting to take that short second line and wrap it onto the front of that line that might have 45 chars? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Monday, August 22, 2005 9:17 AM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2] Formatting Help I have a multi-value field within a multi-value field (sub-values). The length of each sub-value can be up to 70 characters. I need to reformat and print the value so that each sub-value is no longer than 55 characters. To complicate matters I need to know ahead of time how many lines the reformatted value takes up so that if it's greater than the page length I can do a page eject and new headings before I print the value. I've never do this before so how should I approach this? Al DeWitt Stylmark, Inc. 763-574-8705 --- 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.13/78 - Release Date: 8/19/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trend to SHIMS conversion
We are a whole distributor of household hardware [hinges, slides, door knobs...etc], we surveyed the software market and the top makers were Intuit-Eclipse, NxtTrend, Navision [Now Microsoft owned] and Prelude. My understanding is that SHIMs has not had any feature development in the last 10 years. If you are a mutli-value DB shop you might want to seriously consider the Eclipse [Universe] or the Prelude [Unidata] software packages both which are excellend distribution packages with on-going software enhancements. -Original Message- From: Weiss Dan [SMTP:[EMAIL PROTECTED] Sent: Monday, August 22, 2005 7:49 AM To: U2-USERS@listserver.u2ug.org Subject: [U2] Trend to SHIMS conversion I am looking for someone in the Detroit area that has a working knowledge of the SHIMS software. We are converting data from the Trend software into SHIMS. This person/company would need to be available this week on site. We are also looking for possible long term/permanent programmer. Please include your email or phone number to be contacted. CONFIDENTIALITY. This electronic mail and any files transmitted with it may contain information proprietary to John Deere Landscapes, or one of its subsidiaries or affiliates, and are intended solely for the use of the individual or entity to whom they are addressed, shall be maintained in confidence and not disclosed to third parties without the written consent of the sender. If you are not the intended recipient or the person responsible for delivering the electronic mail to the intended recipient, be advised that you have received this electronic mail in error and that any use, dissemination, forwarding, printing or copying of this electronic mail is strictly prohibited. If you have received this electronic mail in error, please immediately notify the sender by return mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] REMOVE results as promised.
Thanks Mark. Great job. You can satisfy some of the people some of the time but you can never satisfy all of the people all of the time. This obviously took some time to do and I appreciate the effort. Tom Dodds [EMAIL PROTECTED] 630-235-2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, August 21, 2005 11:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] REMOVE results as promised. As promised, here are the results of 9 different methods of appending. Basically program went like this: A= FOR I=1 TO 5 A1,-1=I NEXT I Style 1: 1,-1 straight...1 minute, 29 seconds Style 2: -1 attribute level then CONVERT to 253...41 seconds Style 3: DIM(50,000), MATWRITE, READ CONVERT.2 seconds Style 4: DIM(50,000), then assign to variable and CONVERT to 2531 second Style 5: Target = null, [] replacing40 seconds Style 6: Target=Space(100), [] replacing then TRIM8 minutes, 55 seconds. Style 7: Append, VM assigned inside loop..41 seconds Style 8: Append, VM assigned outside loop then remove last..34 seconds. Style 9: 1,MV with MV+=MV as pointer.1 minute, 28 seconds 60 user D3 system on W2000 during normal business day. It appears that Styles 3 4 escaped the suggestions and rose to the top. Apparently the CONVERT (or RAISE/LOWER) functions are pretty quick. The DIM is incredibly quick. I learned a lot and hope others can as well. Thanks for everyone's suggestions. Mark Johnson If anyone wants further coding for any of the styles then don't hestitate to ask. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Problems with uvrestore
Hi Jay You could try UVRESTORE -verify image name to allow uvrestore to verify the image In addition, check what blocksize was used on the original uvbackup image, and specify the appropriate -b size uvrestore parameter HTH Regards Arnold Bosch IT Administrator Taeuber Corssen SWA (Pty) Ltd Jay Falck unicorncomputing [EMAIL PROTECTED] To ting.com u2-users@listserver.u2ug.org Sent by: cc [EMAIL PROTECTED] stserver.u2ug.org Subject [U2] Problems with uvrestore 22/08/2005 15:19 Please respond to [EMAIL PROTECTED] er.u2ug.org I am trying to restore a backup from a UV 10 system running on AIX to a UV 10 system running on Windows. I can run the uvrestore -i command just fine but when I try to run the actual restore I get the following error: Unhandled exception raised at address 0x101F4198 : Access violation Attempted to read from address 0x Aborting UniVerse. I am running 10.1.3 on Windows and the backup was done on a 10.1.something on AIX. Any ideas? Thanks in advance, Jay Jay Falck, CISSP, CHSS Unicorn Computing 512-563-4132 --- 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] LIST EVAL and DATES
When I request a date field inside an eval statement the date is returned in the internal numeric format. Is there a function I can use to return the textual format? AIX 5.1 UniData 6.1.8 Uniobjects for Java Thanks in advance. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] LIST EVAL and DATES
When I request a date field inside an eval statement the date is returned in the internal numeric format. Is there a function I can use to return the textual format? For UniVerse, try LIST ... EVAL DATE CONV D2 For Unidata, change CONV to CNV. The CONV field qualifier sets the conversion code to be used. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [Potentially SPAM Please delete if you do not recognize] - [U2] LIST EVAL and DATES - Bayesian Filter detected spam
EVAL DATE() CONV D2- 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Monday, August 22, 2005 1:10 PM To: u2-users@listserver.u2ug.org Subject: [Potentially SPAM Please delete if you do not recognize] - [U2] LIST EVAL and DATES - Bayesian Filter detected spam When I request a date field inside an eval statement the date is returned in the internal numeric format. Is there a function I can use to return the textual format? AIX 5.1 UniData 6.1.8 Uniobjects for Java Thanks in advance. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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/
RE: [U2] LIST EVAL and DATES
You could do something like this: LIST filename EVAL @RECORD6 CONV D2/ Where the CONV D2/ would be applied to the result of the EVAL @RECORD6. Is that what you were looking for? Tom Dodds [EMAIL PROTECTED] 630-235-2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Monday, August 22, 2005 12:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] LIST EVAL and DATES When I request a date field inside an eval statement the date is returned in the internal numeric format. Is there a function I can use to return the textual format? AIX 5.1 UniData 6.1.8 Uniobjects for Java Thanks in advance. --- 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] Undefined Vars
On unidata I'm looking for a way to test if a variable has been defined or not. I'm aware of $DEFINE, $IFDEF, $IFNDEF and $UNDEFINE but they're not what I need. I have a subroutine and would like to check to see if one argument on entry is defined or not. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 ...our behavior matters more than the beliefs that we profess. Elizabeth Deutsch Earle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Help
snip I have a multi-value field within a multi-value field (sub-values). The length of each sub-value can be up to 70 characters. I need to reformat and print the value so that each sub-value is no longer than 55 characters. To complicate matters I need to know ahead of time how many lines the reformatted value takes up so that if it's greater than the page length I can do a page eject and new headings before I print the value. I've never do this before so how should I approach this? snip There is a little used @ variable (in UD at least) that may help. It's the @TM variable. Format the string first: STRING = FMT(STRING,55T) This forces the string to be at least 55 chars long, but doesn't truncate any word. DCOUNT the @TM to get the number or lines. ex. 001: STRING = 'The quick brown fox jumped over the slow lazy dog.' 002: NEW.STRING = FMT(STRING,'15T') 003: CONVERT @TM TO @SM IN NEW.STRING 004: CRT NEW.STRING 005: NEW.STRING = FMT(STRING,'40T') 006: CONVERT @TM TO @SM IN NEW.STRING 007: CRT NEW.STRING Bottom. *--: FIBR Filed STRING in file BP unchanged. Compiling Unibasic: /XX/X/BP/STRING in mode 'u'. compilation finished The quick|brown fox|jumped over|the slow lazy|dog. The quick brown fox jumped over the|slow lazy dog. Notice the placement of the subvalue marks. ___ Mark Olarte / System Support Manager Puget Sound Truck Lines 206 / 654.7341 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] REMOVE results as promised.
Hey, the evaluation of various methods is great, it would be even greater if the folks doing the evaluating would let us know what sort of hardware. One poster mentioned a laptop, that's good info. The original guy mentions a production system that is in use, that's good too. But, it would be much more useful if we had the make model and os specs for the machines. After all, these days it's not too hard to buy some honkin hardware that will mostly mask sloppy or inefficient programs. Just a suggestion though, don't get all worked up over it... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Undefined Vars
Are you looking for UNASSIGNED()? Colin Alfke Calgary, AB -Original Message- From: Jeffrey Butera On unidata I'm looking for a way to test if a variable has been defined or not. I'm aware of $DEFINE, $IFDEF, $IFNDEF and $UNDEFINE but they're not what I need. I have a subroutine and would like to check to see if one argument on entry is defined or not. -- Jeff Butera, Ph.D. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [AD] Position Vacant - Newcastle - Australia
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. Experience with Manufacturing, Accounting, Distribution, POS, Engineering ... lets just say we have an extensive ERP system, and any experience you bring to the table is likely to get utilized, and if you have exposure to web technologies you might even find yourself working on Visage development. If you don't have the experience, put an application in anyway, 'cause we will train you ! (but if you are reading this message I doubt you are a fresh, bright young grad, BUT you might know someone that is :) Ross Ferris Stamina Software Visage Better by Design! --- 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: [U2] Formatting Help
I'll take a stab at this, off the cuff... GOSUB PRINT.HEADINGS NUM.FIELDS=DCOUNT(@RECORD,@FM) FOR F.POS = 1 TO NUM.FIELDS NUM.VALUES=DCOUNT(@RECORDF.POS,@VM) FOR V.POS = 1 TO NUM.VALUES NUM.SUBVS=DCOUNT(@RECORDF.POS,V.POS,@SVM) FOR S.POS = 1 TO NUM.SUBVS PLINE=FOLD(@RECORDF.POS,V.POS,S.POS,55) PLINE.CNT=DCOUNT(PLINE,@FM) IF PLINE.CNT + LINE.CNT GT MAX.LINES THEN GOSUB PRINT.FOOTER GOSUB PRINT.HEADER END FOR LINE.NUM = 1 TO PLINE.CNT PRINT PLINELINE.NUM LINE.CNT += 1 NEXT LINE.NUM PRINT LINE.CNT += 1 NEXT S.POS NEXT V.POS NEXT F.POS You will need to supply the additional supporting internal subroutines and logic to populate @RECORD but this should be a pretty easy to understand core from which you can expand to your needs. This should work for both UV and UD but in all honesty, I've not used UD directly. Hope that helps. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Monday, August 22, 2005 8:17 AM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2] Formatting Help I have a multi-value field within a multi-value field (sub-values). The length of each sub-value can be up to 70 characters. I need to reformat and print the value so that each sub-value is no longer than 55 characters. To complicate matters I need to know ahead of time how many lines the reformatted value takes up so that if it's greater than the page length I can do a page eject and new headings before I print the value. I've never do this before so how should I approach this? Al DeWitt Stylmark, Inc. 763-574-8705 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] REMOVE results as promised.
Remember, folks, that you don't have to start with 1 in a FOR-NEXT loop. A=1 FOR I = 2 TO 5 A := @VM:I NEXT I Just a peanut from the gallery being thrown. smile BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dzevad Dizdar Sent: Sunday, August 21, 2005 9:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] REMOVE results as promised. Hi Mark, There is another fast method to consider A= FOR I=1 TO 5 IF A = THEN A := I END ELSE A := @VM : I END NEXT I It will take less then 1 second to finish on our system. Dzevad - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, August 21, 2005 12:27 PM Subject: [U2] REMOVE results as promised. As promised, here are the results of 9 different methods of appending. Basically program went like this: A= FOR I=1 TO 5 A1,-1=I NEXT I Style 1: 1,-1 straight...1 minute, 29 seconds Style 2: -1 attribute level then CONVERT to 253...41 seconds Style 3: DIM(50,000), MATWRITE, READ CONVERT.2 seconds Style 4: DIM(50,000), then assign to variable and CONVERT to 2531 second Style 5: Target = null, [] replacing40 seconds Style 6: Target=Space(100), [] replacing then TRIM8 minutes, 55 seconds. Style 7: Append, VM assigned inside loop..41 seconds Style 8: Append, VM assigned outside loop then remove last..34 seconds. Style 9: 1,MV with MV+=MV as pointer.1 minute, 28 seconds 60 user D3 system on W2000 during normal business day. It appears that Styles 3 4 escaped the suggestions and rose to the top. Apparently the CONVERT (or RAISE/LOWER) functions are pretty quick. The DIM is incredibly quick. I learned a lot and hope others can as well. Thanks for everyone's suggestions. Mark Johnson If anyone wants further coding for any of the styles then don't hestitate to ask. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [AD] Position Vacant - Newcastle - Australia
Ahh, you guys freezing down south near the border ! It's a balmy 22 again ... Hey, have YOU considered moving your business a little further North :-) OK, worth a shot! If you know of anyone reasonable who is after a sea change, keep us in mind we seem to be always looking Last ads we ran in the local paper for general Web skills, we had 6 applicants - 3 turned up for interviews, and we didn't hire ANYONE ! Have now approached the Uni directly to see if they can help I DID learn from the newspaper ad though, and decided to exclude the paragraph that said We offer lousy pay, long hours, contact with irate customers and dinghy offices On another note, how is your QM based product going ? Whilst the list has relatively few active contributors, more traffic these days than CDP I think Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: Tuesday, 23 August 2005 11:30 AM To: u2-users@listserver.u2ug.org Subject: 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [AD][oops] Position Vacant - Newcastle - Australia
Hmmm, meant to send that direct Bruce :-( Should I explain about my sense of humour? nahh, if you come here you will learn that we are a light hearted lot, and if not you can treat us as weird ozzies ohh, and for those in the US, that is 22 degrees Celsius ! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: Ross Ferris Sent: Tuesday, 23 August 2005 12:42 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [AD] Position Vacant - Newcastle - Australia Ahh, you guys freezing down south near the border ! It's a balmy 22 again ... Hey, have YOU considered moving your business a little further North :-) OK, worth a shot! If you know of anyone reasonable who is after a sea change, keep us in mind we seem to be always looking Last ads we ran in the local paper for general Web skills, we had 6 applicants - 3 turned up for interviews, and we didn't hire ANYONE ! Have now approached the Uni directly to see if they can help I DID learn from the newspaper ad though, and decided to exclude the paragraph that said We offer lousy pay, long hours, contact with irate customers and dinghy offices On another note, how is your QM based product going ? Whilst the list has relatively few active contributors, more traffic these days than CDP I think Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: Tuesday, 23 August 2005 11:30 AM To: u2-users@listserver.u2ug.org Subject: 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Help
Also consider using FMTS on the entire string, eg. STRING = FMTS(STRING,55T) This will perform the 55T formatting on each element of the string (in this case: each sub-value). 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/
RE: [U2] Undefined Vars
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Undefined Vars
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
