Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
On 08/05/13 21:43, Tony Gravagno wrote: [ad] And of course all of these situations are avoidable by using NebulaXLite. http://Nebula-RnD.com/products/xlite.htm [/ad] And of course, all of these situations are UNavoidable when you are just a mere user of the database :-( I'd love to have some input, but I get the impression that criticisms are just shrugged off. It's a classic case of the PHBs trying to impose what should happen structure, when the *volunteers*! on the ground know that things just don't work like that! 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.
On 08/05/13 20:10, Tony Gravagno wrote: 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, Except that precision isn't decimal place. Don't most apps in the real (pun intended) world use six digit precision? UV has a max of 14, no? iirc INFORMATION had arbitrary precision, but then they did provide specialised microcode to do BCD ... I once got a load of kudos by showing my colleagues how to replace an error-prone case statement with a couple of lines of provably correct code to output figures to four significant places. Proved incredibly useful when they brought in the EMS - who remembers the six-digit fixed exchange rates? But when you're working with currencies, from Pounds Sterling where many prices are in pence, through Italian or Turkish Lire where they are in thousands or millions, to hyper-inflated messes like Zaire where all bets are off ... displaying to four digits can be tricky ... 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.
PHBs love to give out tasks that are impossible or illogical. The worker bees just have to throw off made up deadlines like six months knowing that in one month the top priorities will all change and the project will be abandoned. -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Fri, May 10, 2013 2:04 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. On 08/05/13 21:43, Tony Gravagno wrote: [ad] And of course all of these situations are avoidable by using NebulaXLite. http://Nebula-RnD.com/products/xlite.htm [/ad] And of course, all of these situations are UNavoidable when you are just a mere user of the database :-( I'd love to have some input, but I get the impression that criticisms are just shrugged off. It's a classic case of the PHBs trying to impose what should happen structure, when the *volunteers*! on the ground know that things just don't work like that! Cheers, Wol ___ 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.
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
[U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, 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.
OPENSEQ TEMP.FILE1 to temp_file1 else READSEQ... WRITESEQ CLOSESEQ... On 7 May 2013 16:37, Sathya sathya8...@gmail.com wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, 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.
Dennis Bartlett dqbartlett at gmail.com writes: OPENSEQ TEMP.FILE1 to temp_file1 else READSEQ... WRITESEQ CLOSESEQ... Hi Dennis,.. Thanks a lot for your help. However let me explain my requirement. I need to open and read a file from the server. That means a text file from a path and not the Unidata file. Can you please let me know how to do it? as Im facing issues with opening the file. Thanks Regards, Sathya V. On 7 May 2013 16:37, Sathya sathya83aa at gmail.com wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, Sathya V. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at 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.
Hi back, Here's what I usually do. I create a file record in the voc pointing to that directory and give it D_BP as a dictionary. If that VOC record is named TEMP.FILE; I can then open it in a program and read TEMP.FILE1 as a record from that file. Then every flat file record is a field in your U2 record. Fixed length you have to count, space or other delimiter I use the FIELD within a FOR/NEXT. Dale On 05/07/2013 01:37 AM, Sathya wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, 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.
I usually: OPENPATH directory of file to temp_filedir else STOP CAN NOT OPEN directory READ FDATA FROM temp_filedir,filename ELSE STOP CAN NOT READ filedir But creating a VOC file entry: 0001: F 0002: directory of file 0003: D_BP Also works. If you get errors opening the file (esp on unix), it is most like a unix user Permissions issue. George -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 7: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. Hi back, Here's what I usually do. I create a file record in the voc pointing to that directory and give it D_BP as a dictionary. If that VOC record is named TEMP.FILE; I can then open it in a program and read TEMP.FILE1 as a record from that file. Then every flat file record is a field in your U2 record. Fixed length you have to count, space or other delimiter I use the FIELD within a FOR/NEXT. Dale On 05/07/2013 01:37 AM, Sathya wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, 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.
Wjhonson wjhonson at 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.
Use OCONV and ICONV and the MD (Move Decimal) type. Ex. NODEC=ICONV(WITHDEC,MD2) ICONV - moves decimal to the right OCONV - moves decimal to the left MD# - where # is the number of decimal places to move. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, May 07, 2013 1:04 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. Wjhonson wjhonson at 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.
Type HELP BASIC ICONV at the command prompt. You'll see examples of decimal conversions on the 4th page down. Use ICONV to remove the decimal from a number prior to writing to a file. Use OCONV to add the decimal to a number prior to displaying. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, May 07, 2013 10:04 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. Wjhonson wjhonson at 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.
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
