Re: [U2] UniData PreStore to change the KEY of a record?
To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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] UniData PreStore to change the KEY of a record?
Quite. Less lines than the original post. - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 29 May 2013 08:25 To: U2 Users List Subject: Re: [U2] UniData PreStore to change the KEY of a record? To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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 Click https://www.mailcontrol.com/sr/MZbqvYs5QwJvpeaetUwhCQ== to report this email as spam. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData PreStore to change the KEY of a record?
Another excellent suggestion, Mecki, especially if one isn't familiar with paragraphs. I tend to use them a lot for one-offs because I've used them a lot over the years, and am very comfortable with them, but a Basic program would be just as easy. More than once I've built a paragraph to do a job for a user, only to have them scope creep me into writing a program anyway. Charlie On 05-29-2013 2:25 AM, Mecki Foerthmann wrote: To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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
[U2] [AD] Webinar: Mainstream Developer Usage of MultiValue Databases
As a nice follow up to the - UniObjects.Net vs Third-party Products - thread Please join our Webinar: Mainstream Developer Usage of MultiValue Databases June 12, 2013 - 11:30am - 12:30pm EDT (New York) For .NET developers wishing to access MultiValue databases, mv.NET has built a reputation for being the product of choice. Any MultiValue application can be enhanced and new applications can be built using mv.NET without needing to move away from tried, tested and trusted MultiValue database technology or existing business logic. mv.NET Solution Objects takes MultiValue application development to dazzling new heights and, with one simple implementation, provides developers with limitless ways to create amazing application interfaces using the very latest industry standard technologies -- HTML5, ASP.NET MVC, WPF and any other .NET enabled Microsoft environment. Solution Objects allows you to create a unified, single point of access layer around your database platform. This layer can then be leveraged by any kind of application in order provide access to your database content. Using the Solution Objects layer from within the .NET environment is simple and easy and requires no knowledge of MultiValue database technology. Whether you are building a browser hosted application, a mobile app, a desktop rich client or any other kind of service or application, Solution Objects can meet all of your data connectivity requirements - allowing you to utilize your MultiValue resources in a focused and efficient manner and also allowing you to continue leveraging your MultiValue database investment. Additionally, organizations can utilize the massive resource pool of .NET developers to boost application development bandwidth and reduce development timescales. Let BlueFinity's experts show you how easy it can be to unleash your creativity and create state-of-the-art, industry standard applications which can be deployed across any of the wide range of today's interface devices - workstations, browsers, handhelds, phones and other mobile devices. With mv.NET Solution Objects, your MultiValue application can now rival the 'mainstream' competition in terms of presentation, features, functions, performance, stability and efficiency! Register: https://www2.gotomeeting.com/register/327855570 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UniObjects.Net vs Thrid-party Products
Thanks for the reply Tony, I can't speak for anyone but Rocket, but we definitely don't feel threatened and encourage everyone to write great applications and share the story, regardless of what technology you use to connect U2 to your front-end. Did I mention share the story? :) Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, May 28, 2013 1:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products From: Daniel McGrath Tony, out of curiosity, have you looked at UO.NET's replacement: U2 Toolkit for .NET? Not recently bud. Once I settle on a toolkit that works well, my research in that specific area slows down. How much research do we continue to do on cars after we've made a purchase? Do we keep house hunting after we move into a new home? It's appropriate to be informed about what's happening in our industry, but I have dozens of platforms, frameworks, toolkits, and related versions that I need to keep up with - that still means time needs to be allocated for hundreds of permutations of all of these blasted software packages that are all supposed to save us time. Like everyone else here, I need to use whatever free time I have to hone my skills with the latest versions of the tools I already use, rather than continue to look into replacements. Despite professional curiosity, at some point we need to stop playing with tools and just hunker down to write real code. I'd like to say that at some point I'll cycle back around for another look at the U2 toolkit, but remember that for my purposes of writing applications that are the same across all MV platforms, a platform-specific tool is generally off of my radar. Sure, it would be nice to save my clients money using free tools, but I have U2 clients that have been running a single license of mv.NET for years. The tiny cost of the tool is trivial in the big picture. People need to think hard about exactly how much free costs them, or how adverse they are to buying a low-cost license for something that will last years. And that's just the cost of the tool. When a U2 site posts a job ad for someone to do UI work or web services, they might say must know U2 Toolkit for .NET. If they have a tool that anyone in the MV industry can use, the scope of candidates broadens to include U2 developers And everyone else. .NET developers have already broadened their scope to the outside world. Once they/we have made that jump, there's no reason anymore to limit one's self to a single MV platform and related tools. A company that is going in this direction should think hard about branching out and then snapping right back again to platform-specific tools. Sure, you're going to find someone who does U2-only work with .NET, but why limit your scope to U2-only people? The non-end-user developers that I know who use mv.NET aren't interested in limiting themselves to one platform anymore. It doesn't make sense to not have access to that pool of talent just because you want to use a free tool. And no, the DBMS vendors shouldn't feel threatened by this - we're enhancing applications for everyone, not the competition. It's the end-users that win here as well as their up-line channel. So Rocket Software and Tiger Logic and Ladybridge and everyone else should be encouraging their developer channel to use mv.NET rather than somehow feeling threatened by it. (More than I expected to write on that one, sorry.) T Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services http://Nebula-RnD.com/blog http://Twitter.com/TonyGravagno ___ 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] [UV] UniObjects.Net vs Thrid-party Products
And from Bluefinity we certainly welcome Dan's endorsement to technology that enhances the use of U2 and makes for happy, long term users as this is great for everyone. There are certainly a lot of happy mv.NET customers in that category. Regards David Peters, Sales Manager at Bluefinity -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 29 May 2013 15:27 To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products Thanks for the reply Tony, I can't speak for anyone but Rocket, but we definitely don't feel threatened and encourage everyone to write great applications and share the story, regardless of what technology you use to connect U2 to your front-end. Did I mention share the story? :) Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, May 28, 2013 1:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products From: Daniel McGrath Tony, out of curiosity, have you looked at UO.NET's replacement: U2 Toolkit for .NET? Not recently bud. Once I settle on a toolkit that works well, my research in that specific area slows down. How much research do we continue to do on cars after we've made a purchase? Do we keep house hunting after we move into a new home? It's appropriate to be informed about what's happening in our industry, but I have dozens of platforms, frameworks, toolkits, and related versions that I need to keep up with - that still means time needs to be allocated for hundreds of permutations of all of these blasted software packages that are all supposed to save us time. Like everyone else here, I need to use whatever free time I have to hone my skills with the latest versions of the tools I already use, rather than continue to look into replacements. Despite professional curiosity, at some point we need to stop playing with tools and just hunker down to write real code. I'd like to say that at some point I'll cycle back around for another look at the U2 toolkit, but remember that for my purposes of writing applications that are the same across all MV platforms, a platform-specific tool is generally off of my radar. Sure, it would be nice to save my clients money using free tools, but I have U2 clients that have been running a single license of mv.NET for years. The tiny cost of the tool is trivial in the big picture. People need to think hard about exactly how much free costs them, or how adverse they are to buying a low-cost license for something that will last years. And that's just the cost of the tool. When a U2 site posts a job ad for someone to do UI work or web services, they might say must know U2 Toolkit for .NET. If they have a tool that anyone in the MV industry can use, the scope of candidates broadens to include U2 developers And everyone else. .NET developers have already broadened their scope to the outside world. Once they/we have made that jump, there's no reason anymore to limit one's self to a single MV platform and related tools. A company that is going in this direction should think hard about branching out and then snapping right back again to platform-specific tools. Sure, you're going to find someone who does U2-only work with .NET, but why limit your scope to U2-only people? The non-end-user developers that I know who use mv.NET aren't interested in limiting themselves to one platform anymore. It doesn't make sense to not have access to that pool of talent just because you want to use a free tool. And no, the DBMS vendors shouldn't feel threatened by this - we're enhancing applications for everyone, not the competition. It's the end-users that win here as well as their up-line channel. So Rocket Software and Tiger Logic and Ladybridge and everyone else should be encouraging their developer channel to use mv.NET rather than somehow feeling threatened by it. (More than I expected to write on that one, sorry.) T Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services http://Nebula-RnD.com/blog http://Twitter.com/TonyGravagno ___ 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] UniData PreStore to change the KEY of a record?
OK - a program was always a choice -- just wanted to ensure I had not missed a 'simple feature' of AE along the way -- again - 90 records -- I have to alter a single attribute and change the key ... was hoping I could do one 'compound' prestore! No such luck! Thanks all... at least I know I have 'maxed out' the usage of PreStores!! DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, May 29, 2013 2:25 AM To: U2 Users List Subject: Re: [U2] UniData PreStore to change the KEY of a record? To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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] UniData PreStore to change the KEY of a record?
Or, you could download the BPTEST or TRY program from: http://www.pickwiki.com/cgi-bin/wiki.pl?BasicSource ...then write the simple code from the command line. Not only are these programs good to test syntax, but they're great for performing simple tasks that don't work from the command line. Bill - Original Message - *From:* mec...@gmx.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/29/2013 12:25 AM *Subject:* Re: [U2] UniData PreStore to change the KEY of a record? To stay with the picture of not using a hammer to drive in a screw, I would just write a Basic program to do this. Use the right tool for the job! Open the file Execute GET-LIST Then a loop that generates the new Ids including checking that it doesn't already exist, READU record from old Id, WRITE record to new ID, DELETE old record. A few lines of code written in less than a minute. Compile, generate list, run program, job done! On 28/05/2013 21:59, Charlie Noah wrote: Dang, David, you beat me to it. ;^) I was just going to suggest the same thing. Just because the OP wanted to use ED (a hammer) to drive in a screw doesn't mean that it is the best tool ( a screwdriver). Good answer. Charlie Noah On 05-28-2013 3:42 PM, David A. Green wrote: I would take my saved list and copy it to a text editor then using copy commands and a quick macro convert the list into a bunch of COPY FROM FILE.A BAD.KEY, GOOD.KEY commands. Then save it as a PA and then execute it. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, May 28, 2013 10:48 AM To: 'U2 Users List' Subject: [U2] UniData PreStore to change the KEY of a record? I am always using what I call 'PreStore' command... In the AE editor, I need to change Attb 2 from A]thisbad]C]D to be A]thisgood]C]D on a list of items... So I get the list, AE FILENAME and then... =FIX 2`R/thisbad/thisgood/`FI`=FIX Viola! The data is updated. I have a need to 'fix' a KEY to a record... Is there a way to use a PreStore command that could do that? It's 95 records. Too many to hand edit. Too few to write a program. A PreStore would be JUST RIGHT... if there was a way to do it! DW ___ 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