Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
The only thing I could think of is it could validate it as being a number, but then So would NUM(). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
It doesn't do nothing - it rounds - if the input value is 55.5 you get 56 as output. It only does nothing if your input is a whole number.; -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Yes, it would do that. Have to keep that one in mind, instead of the old INT(#+.5) if going to a whole number -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Wednesday, May 08, 2013 9:40 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. It doesn't do nothing - it rounds - if the input value is 55.5 you get 56 as output. It only does nothing if your input is a whole number.; -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Dave, I guess you're right, I originally stated it because the ICONV/OCONV is just a standard method I use for rounding to shorter decimals. When I started Pick, I found so many ways to do things that I usually adopted one and from there on it's just repetition until you discover a problem. Dale On 05/08/2013 08:40 AM, Dave Davis wrote: It doesn't do nothing - it rounds - if the input value is 55.5 you get 56 as output. It only does nothing if your input is a whole number.; -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonataol.comwrites: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. ThanksRegards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Dave Davis Team Lead, RD P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/ 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
NUM() will validate '' (null string) as numeric, and I believe some implementations would validate '.' (decimal point) as numeric, although the version of Jbase I'm on, running Universe emulation, does not. Charlie On 05-08-2013 8:39 AM, George Gallen wrote: The only thing I could think of is it could validate it as being a number, but then So would NUM(). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
I Usually use NUM(xx) and xx# to combat that one. Never really thought about . - I would think that would be treated as 0.0 in any calculations? Guess I'll have to test that one out... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, May 08, 2013 10:34 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. NUM() will validate '' (null string) as numeric, and I believe some implementations would validate '.' (decimal point) as numeric, although the version of Jbase I'm on, running Universe emulation, does not. Charlie On 05-08-2013 8:39 AM, George Gallen wrote: The only thing I could think of is it could validate it as being a number, but then So would NUM(). George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
VAR 0 rounds to a whole number just as OCONV(VAR, 'MD0') does. If you want to drive the next programmer who comes along absolutely nuts, you could use that. ;) Charlie On 05-08-2013 8:45 AM, George Gallen wrote: Yes, it would do that. Have to keep that one in mind, instead of the old INT(#+.5) if going to a whole number -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Wednesday, May 08, 2013 9:40 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. It doesn't do nothing - it rounds - if the input value is 55.5 you get 56 as output. It only does nothing if your input is a whole number.; -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
I normally use VAR MATCHES '1N0N]1N0N.1N0N' where ] is a value mark. Different strokes, I guess. There are many ways to skin a cat, but no matter which one you use, the cat ain't gonna like it. Charlie On 05-08-2013 9:38 AM, George Gallen wrote: I Usually use NUM(xx) and xx# to combat that one. Never really thought about . - I would think that would be treated as 0.0 in any calculations? Guess I'll have to test that one out... George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Wednesday, May 08, 2013 10:34 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. NUM() will validate '' (null string) as numeric, and I believe some implementations would validate '.' (decimal point) as numeric, although the version of Jbase I'm on, running Universe emulation, does not. Charlie On 05-08-2013 8:39 AM, George Gallen wrote: The only thing I could think of is it could validate it as being a number, but then So would NUM(). George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Not to be too obtuse, but if the only point is to convert MM.MM to you could just use CONVERT . TO -Original Message- From: Charlie Noah cwn...@comcast.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 7:34 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. NUM() will validate '' (null string) as numeric, and I believe some implementations would validate '.' (decimal point) as numeric, although the version of Jbase I'm on, running Universe emulation, does not. Charlie On 05-08-2013 8:39 AM, George Gallen wrote: The only thing I could think of is it could validate it as being a number, but then So would NUM(). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Wednesday, May 08, 2013 9:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. George, After sending it I thought, Well,... that OCONV acomplishes nothing! Dale On 05/08/2013 08:32 AM, George Gallen wrote: What purpose will the OCONV(var,MD0) serve? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
That wouldn't work however, for say: 123.45 and MD3 conversion You would get 12345 instead of 123450 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Not to be too obtuse, but if the only point is to convert MM.MM to you could just use CONVERT . TO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Yes but the original request was just to take MM.MM and write -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 9:11 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. That wouldn't work however, for say: 123.45 and MD3 conversion You would get 12345 instead of 123450 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Not to be too obtuse, but if the only point is to convert MM.MM to you could just use CONVERT . TO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Same thing... 12.2 would give 122 instead of 1220 To not take into account dropped trailing zeros would be badalmost as bad (well maybe worse) Than a goto? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Yes but the original request was just to take MM.MM and write -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 9:11 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. That wouldn't work however, for say: 123.45 and MD3 conversion You would get 12345 instead of 123450 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Not to be too obtuse, but if the only point is to convert MM.MM to you could just use CONVERT . TO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Haha yes, but again, the original request... If a client sent me dollar figures where 12.2 was supposed to mean 12.20 I would go like ... what kind of system do you run where 12.2 means 12.20 ? I'm assuming that a file you want to read into a Pick system, with embedded MM.MM dollars is coming from an outside source. I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 9:28 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Same thing... 12.2 would give 122 instead of 1220 To not take into account dropped trailing zeros would be badalmost as bad (well maybe worse) Than a goto? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Yes but the original request was just to take MM.MM and write -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 9:11 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. That wouldn't work however, for say: 123.45 and MD3 conversion You would get 12345 instead of 123450 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Not to be too obtuse, but if the only point is to convert MM.MM to you could just use CONVERT . TO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
They call it Excel! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Haha yes, but again, the original request... If a client sent me dollar figures where 12.2 was supposed to mean 12.20 I would go like ... what kind of system do you run where 12.2 means 12.20 ? I'm assuming that a file you want to read into a Pick system, with embedded MM.MM dollars is coming from an outside source. I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
No when I tell Excel that a column is dollars, or time, it always leaves the trailing zero. What are you doing that makes it remove that? -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 9:36 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. They call it Excel! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Haha yes, but again, the original request... If a client sent me dollar figures where 12.2 was supposed to mean 12.20 I would go like ... what kind of system do you run where 12.2 means 12.20 ? I'm assuming that a file you want to read into a Pick system, with embedded MM.MM dollars is coming from an outside source. I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Actually, Excel does NOT keep the trailing zero, but simply displays it that way. The underlying data (what you get if you retrieve the data from the cell programmatically) is 12.2. Or worse, it could be the result of a division, and you could get 12.20333, but you told Excel to display 2 decimal places. You're right that the original explanation was that we were transforming MM.MM, but this raises two concerns. First, what happens with numbers greater than 99.99? The user gave me a definition and I'm always going to either clarify VERY CAREFULLY or assume that they are making all kinds of assumptions. In short, there are some reasonable human assumptions that you should always account for. Secondly, even if the customer intends that we always get 12.20 stored, someone, someday will look at the data and say to themselves, 'Hey, I can store 12.2! That will save space, and the decimal makes it clear what the number is!' and they'll make a change that breaks your code. I always try to account for reasonable assumptions. E.g: 112.2 and 112.20 and 0112.2000 are the same number. Even a child knows that. If my code isn't at least as smart as a 5th grader, it's too stupid to go to production. ICONV(var,MDn) will always give you a number with 'n' implied decimals, and on most MV platforms will round for you (check your platform - don't assume this one, either!) INT((var * 100) + 0.5) do the same to 2 decimal places (in this case 'n' is the number of zeros you are multiplying your number by.) Simply stripping the decimal out is a very brittle solution, and one I'd never accept in a code review. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: May-08-13 9:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. No when I tell Excel that a column is dollars, or time, it always leaves the trailing zero. What are you doing that makes it remove that? -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 9:36 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. They call it Excel! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Haha yes, but again, the original request... If a client sent me dollar figures where 12.2 was supposed to mean 12.20 I would go like ... what kind of system do you run where 12.2 means 12.20 ? I'm assuming that a file you want to read into a Pick system, with embedded MM.MM dollars is coming from an outside source. I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
That's assuming you are the one who created / imported the data into Excel. However, I receive Excel files very frequently where the user who created it Has little knowledge of formatting cells. So very often I am forced to import data with dropped trailing zeros. That and phone numbers being converted to E notationHate those. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. No when I tell Excel that a column is dollars, or time, it always leaves the trailing zero. What are you doing that makes it remove that? -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 9:36 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. They call it Excel! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Haha yes, but again, the original request... If a client sent me dollar figures where 12.2 was supposed to mean 12.20 I would go like ... what kind of system do you run where 12.2 means 12.20 ? I'm assuming that a file you want to read into a Pick system, with embedded MM.MM dollars is coming from an outside source. I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
You have obviously never watched Are you smarter than a 5th grader?! I wouldn't write off those gradeschoolers quite yet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Wednesday, May 08, 2013 1:04 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. If my code isn't at least as smart as a 5th grader, it's too stupid to go to production. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
But the problem is that those 5th graders are already programming! They get number theory (better than some of us) and they get that 12.2 is the same as 12.20. When you tell them that your program can't handle real numbers, they'll look at you with a look that says Boy, these old guys are DUMB! and then you'll be embarrassed! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: May-08-13 10:15 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. You have obviously never watched Are you smarter than a 5th grader?! I wouldn't write off those gradeschoolers quite yet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Wednesday, May 08, 2013 1:04 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. If my code isn't at least as smart as a 5th grader, it's too stupid to go to production. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Are you implying that I program like a fifth grader? -Original Message- From: Robert Houben robert.hou...@fwic.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 10:17 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. But the problem is that those 5th graders are already programming! They get number theory (better than some of us) and they get that 12.2 is the same as 12.20. When you tell them that your program can't handle real numbers, they'll look at you with a look that says Boy, these old guys are DUMB! and then you'll be embarrassed! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: May-08-13 10:15 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. You have obviously never watched Are you smarter than a 5th grader?! I wouldn't write off those gradeschoolers quite yet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Wednesday, May 08, 2013 1:04 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. If my code isn't at least as smart as a 5th grader, it's too stupid to go to production. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Do you find yourself talking like Jeff Foxworthy?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 1:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Are you implying that I program like a fifth grader? -Original Message- From: Robert Houben robert.hou...@fwic.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 10:17 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. But the problem is that those 5th graders are already programming! They get number theory (better than some of us) and they get that 12.2 is the same as 12.20. When you tell them that your program can't handle real numbers, they'll look at you with a look that says Boy, these old guys are DUMB! and then you'll be embarrassed! :) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
You know you're a red-neck 5th grader when -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, May 08, 2013 10:28 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Do you find yourself talking like Jeff Foxworthy?? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 1:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Are you implying that I program like a fifth grader? -Original Message- From: Robert Houben robert.hou...@fwic.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 10:17 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. But the problem is that those 5th graders are already programming! They get number theory (better than some of us) and they get that 12.2 is the same as 12.20. When you tell them that your program can't handle real numbers, they'll look at you with a look that says Boy, these old guys are DUMB! and then you'll be embarrassed! :) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
On 08/05/2013 18:11, George Gallen wrote: That's assuming you are the one who created / imported the data into Excel. However, I receive Excel files very frequently where the user who created it Has little knowledge of formatting cells. So very often I am forced to import data with dropped trailing zeros. That and phone numbers being converted to E notationHate those. With our phone numbers ... we are forced to use a database that exports to excel ... And if you don't put spaces and whatnot in phonenumbers to force excel to realise it's text, all your phone numbers have their leading zeroes stripped ... (I believe it's written by outside consultants, but the lady internal to the organisation who looks after it thinks it's wonderful. As a database programmer forced to use it, my opinion of it is unprintable ... I can't be too rude though because this lady is a good friend of and sort-of-boss-to my wife) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
From: Wjhonson I'm assuming that a file you want to read into a Pick system, with embedded MM.MM dollars is coming from an outside source. I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. This is weird, I've seen a few discussions within the last week where people can't tell the difference between data storage format and rendering or transport format. With regard to: I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. I have news for you - they ALL do. Other systems don't store data with trailing zeros because they have no need to store them. It's up to each individual user/application to decide whether to use 1 digit, 2, 4, or none. Data is stored with as few characters as possible, which is part of the reason why we tend to store integer-only in MV. Our system of storing integers with implied 4 digit precision is flawed and archaic, but we all live with it, except where apps have been written where the author was unaware of such conventions. When importing data we can expect to see just about anything. The format is determined by accepted convention and is largely unimportant. Most applications use classes to define their data types, whether Integer, Float, Decimal, or Currency. When discussing data transfers the discussion usually includes how do you want your numbers?. To that I generally respond, I don't care, whatever works for you, just document it and keep it consistent. If they say Integer, I mask it as required. If they mask it, I convert to integer. If they want to send a dollar amount, it's usually sent with two decimals as an output format, but since we all know it's just data, it's not unreasonable to expect dollar figures with 0 or 1 decimal. In other words, there are no conventions - we make it up with each project and site, following app-specific standards as possible. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
var = int(var * 100) Nick Tilstra -Original Message- From: dale kelley [mailto:dalekel...@dalewkelleyinc.com] Sent: Tuesday, May 07, 2013 6:06 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
You can create a custom format in Excel containing a zero mask of how ever many characters you like and that will preserve (well, actually replace the already stripped) leading zeros. Anthonys Lists wrote: With our phone numbers ... we are forced to use a database that exports to excel ... And if you don't put spaces and whatnot in phonenumbers to force excel to realise it's text, all your phone numbers have their leading zeroes stripped ... (I believe it's written by outside consultants, but the lady internal to the organisation who looks after it thinks it's wonderful. As a database programmer forced to use it, my opinion of it is unprintable ... I can't be too rude though because this lady is a good friend of and sort-of-boss-to my wife) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
There are a couple ways to prevent automatic numeric reformatting in Excel: 1) Any value preceded by a single quote is not treated as a number and is thus not reformatted. So a telephone number becomes '123-456-7890. 2) If the document is real Excel and not just CSV rendered in the Excel application, you can format the column to be Text. This also has the advantage of avoiding a warning which may display from 'values, where Excel keeps trying to let you know that a value looks like a date or some other format. [ad] And of course all of these situations are avoidable by using NebulaXLite. http://Nebula-RnD.com/products/xlite.htm [/ad] HTH T From: Jeff Schasny You can create a custom format in Excel containing a zero mask of how ever many characters you like and that will preserve (well, actually replace the already stripped) leading zeros. Anthonys Lists wrote: With our phone numbers ... we are forced to use a database that exports to excel ... And if you don't put spaces and whatnot in phonenumbers to force excel to realise it's text, all your phone numbers have their leading zeroes stripped ... (I believe it's written by outside consultants, but the lady internal to the organisation who looks after it thinks it's wonderful. As a database programmer forced to use it, my opinion of it is unprintable ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users