Re: [U2] OT: Monitoring Program: Can This Be Done?

2013-06-26 Thread Mecki Foerthmann
You really don't want to use TIMEOUT for every user since that can cause a lot of trouble. I only execute it for certain users like shop floor terminals. I put macros into the sbc files on those PCs so you only click on the icon and it logs you on to Linux with the right ID and password for

Re: [U2] How do I get the U2 Metadata Manager to work

2013-06-09 Thread Mecki Foerthmann
-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Saturday, June 8, 2013 3:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work Bill, What I try to achieve is converting production data

Re: [U2] How do I get the U2 Metadata Manager to work

2013-06-07 Thread Mecki Foerthmann
I know, tried it and it doesn't work on our setup because BCI only seems to work if the OS on the UD server is 32 bit. We were told it didn't matter so they built a Redhat Linux 64 bit virtual server and put UD in that. Now if I try to connect trough BCI I only get memory errors. AFAIK EDA is

Re: [U2] How do I get the U2 Metadata Manager to work

2013-06-07 Thread Mecki Foerthmann
64bit and we use BDT ok ??? Also EDT is for unidata to get access to external data sources like sql server so that would also solve the problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent

Re: [U2] How do I get the U2 Metadata Manager to work

2013-06-07 Thread Mecki Foerthmann
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, June 7, 2013 9:54 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I know, tried it and it doesn't work on our setup because BCI only seems to work

[U2] How do I get the U2 Metadata Manager to work

2013-06-06 Thread Mecki Foerthmann
Ever since we finally upgraded UniData at work I have been trying out the new tools and don't seem to have much fun with them. The best one is XAdmin and I use it a lot these days. IMHO the interface is a bit crude and clunky, but I guess that's Eclipse and you can't do much about that. The

Re: [U2] How do I get the U2 Metadata Manager to work

2013-06-06 Thread Mecki Foerthmann
to accomplish this. Tom Whitmore RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 12:06 PM To: U2 Users List Subject: [U2] How do I get the U2 Metadata

Re: [U2] How do I get the U2 Metadata Manager to work

2013-06-06 Thread Mecki Foerthmann
-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, June 06, 2013 1:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How do I get the U2 Metadata Manager to work I'll keep that refresh option in mind. Still a hassle and I would prefer if they would just get rid

Re: [U2] Unidata BCI error

2013-06-01 Thread Mecki Foerthmann
would hazard a guess this is some 32-bit on a 64-bit machine related problem. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, May 23, 2013 9:56 AM To: U2 Users List

Re: [U2] UniData PreStore to change the KEY of a record?

2013-05-29 Thread Mecki Foerthmann
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,

[U2] Unidata BCI error

2013-05-23 Thread Mecki Foerthmann
Unidata 7.2 on Redhat 6.2 64. I got our Sysadmin to install ODBC on our UD server today so I can try to use BCI to access data on SQL Server 2008 R2 directly. After some experimenting we finally got the ODBC part going and can connect to the right database from the command line. He relinked the

Re: [U2] select query..

2013-05-15 Thread Mecki Foerthmann
What do you actually try to achieve? On 15/05/2013 12:18, Sathya wrote: Manu Fernandes efv at infodata.lu writes: Hi Do you have wildcard characters like [] into KEYVALUE ? If not, why do you SELECT ; it's the key of file.name ; you can read directly ! Elsewhere, For performance, set a

Re: [U2] select query..

2013-05-15 Thread Mecki Foerthmann
So you don't need to select at all. Just use READ record FROM FILE.NAME,KEYVALUE ELSE record = '' in your loop. On 15/05/2013 12:52, Sathya wrote: Mecki Foerthmann meckif at gmx.net writes: ___ U2-Users mailing list U2-Users at listserver.u2ug.org

Re: [U2] What tools do you use for data warehouse...

2013-04-26 Thread Mecki Foerthmann
SSIS of course. Why would anybody want to use anything else? On 26/04/2013 18:50, Tom Whitmore wrote: Hi, I was wondering what tools you use to export data to an SQL data warehouse from UniVerse. This export could occur on multiple flavors of Unix. What we would need to do is extract the UV

Re: [U2] Date conversion..

2013-03-22 Thread Mecki Foerthmann
I use OCONV(DATE(),'D') and that works just fine because it displays today as 22 Mar 2013. On 22/03/2013 11:19, Martin Phillips wrote: Hi, Try OCONV(DATE(),'DDMY[,A,Z4]') M ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] Social Networks for MV

2013-03-16 Thread Mecki Foerthmann
Facebook is pure evil (even George Orwell couldn't imagine something so sinister when he wrote 1984) and Twitter is nothing but a waste of time. On 16/03/2013 01:49, Charlie Noah wrote: I don't want to offend my friend Tony, but I have to agree with Bob. I don't trust anything I see on

[U2] I Descriptor no longer working in UniSQL after UD upgrade

2013-03-05 Thread Mecki Foerthmann
Hi we upgraded from UD 5.2/Solaris to UD 7.2/RH about a month ago and so it looked fine so far. Now I had a call that there are purchase orders missing on a Cognos report. When I investigated I noticed that from the day of the upgrade I have rows in the table used for that report with missing

Re: [U2] *** GMX Spamverdacht *** Re: I Descriptor no longer working in UniSQL after UD upgrade

2013-03-05 Thread Mecki Foerthmann
syntax. On 05/03/2013 13:52, David A. Green wrote: Have your compiled your i-descriptor? Is it marked as MV? 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 Mecki

Re: [U2] : Evaluating DCOUNT

2013-02-12 Thread Mecki Foerthmann
The speed increase is more likely due to the use of REMOVE not the RAISE since REMOVE works also on values or sub-values and I don't think it makes much difference which delimiter you use. On ADDS Mentor we used to Basic select arrays to variables and then READNEXT FROM in a loop since REMOVE

Re: [U2] Record locks (Unidata 7.2)

2013-02-11 Thread Mecki Foerthmann
The lock isn't released since another user set it. On 10/02/2013 22:35, Peter Cheney wrote: In the example below what happens to the lock? Does it release if the write is not executed? If not shouldn't you have a RELEASE statement at the end after the last END? -Original Message-

Re: [U2] Record locks (Unidata 7.2)

2013-02-08 Thread Mecki Foerthmann
Oh no, you don't have to add a label and you don't have to use GOTO. TRY_AGAIN = 1 LOOP WHILE TRY_AGAIN READU STU.REC FROM STU.FILE, STU.ID LOCKED CRT STU.ID: RECORD IS LOCKED SLEEP 2 END THEN STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID

Re: [U2] Record locks (Unidata 7.2)

2013-02-08 Thread Mecki Foerthmann
NOT(TRY_AGAIN) REPEAT STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID On 08/02/2013 20:12, Mecki Foerthmann wrote: Oh no, you don't have to add a label and you don't have to use GOTO. TRY_AGAIN = 1 LOOP WHILE TRY_AGAIN READU STU.REC FROM STU.FILE, STU.ID

Re: [U2] Record locks (Unidata 7.2)

2013-02-07 Thread Mecki Foerthmann
The READU statement has a LOCKED clause that is true if a record is locked. You can put all your locking ha logic in there. READU record FROM filevariable,itemID THEN code if record exists and isn't locked (optional) LOCKED code to handle locked record condition (optional) END ELSE code

Re: [U2] Another job ad written by people who have no clue

2012-11-02 Thread Mecki Foerthmann
Come on Charlie, texting is cool and it is easy. If I want to talk to my son in France for instance, I send him a text to switch on his PC so we can use Skype to actually talk and vice versa. The workshop sending me a text that my bike is ready to be collected - now how cool is that? You're an

Re: [U2] SB+ question

2012-10-23 Thread Mecki Foerthmann
I always leave one input field usually containing the line number set as controlling the other fields but don't allow changes to the field. You obviously need an input field for the cursor so you can use page up or down. On 23/10/2012 00:46, Lunt, Bruce wrote: Hi All, I have a question that

Re: [U2] Etymology of Q-Pointer

2012-09-07 Thread Mecki Foerthmann
I guess it always depends on where you come from and what you know. I would say the account philosophy is much cleaner than having duplicate file pointers. And of course we have accounts in U2 too - it is the working directory. I have to admit I always hated to work on PI sites - it was not

Re: [U2] Etymology of Q-Pointer

2012-09-07 Thread Mecki Foerthmann
I have no Idea what you are talking about. What is wrong with LOCATE A IN B SETTING C ? On 07/09/2012 20:44, Wols Lists wrote: On 07/09/12 18:28, Mecki Foerthmann wrote: I guess it always depends on where you come from and what you know. I would say the account philosophy is much cleaner than

Re: [U2] Scrub Hangs Up

2012-08-29 Thread Mecki Foerthmann
I would expect this not to work. D_INVOICE is a dictionary file so it hasn't got a dictionary. If you try copy FROM DICT INVOICE TO DICT INVOICE_TEST it should probably work. On 28/08/2012 23:39, Bill Brutzman wrote: More help is needed... 1.copy FROM DICT D_INVOICE TO DICT D_INVOICE_TEST

Re: [U2] Variable Interpolation

2012-08-24 Thread Mecki Foerthmann
Sorry but I always thought iterpolation means describing a mathematical function like Y=2X for instance by producing a graph from it or describing key parameters in a system of coordinates (x,y) like where it crosses the y- or x-axis, if it rises or falls and in which degree etc. . On

Re: [U2] CSV to Array

2012-08-16 Thread Mecki Foerthmann
The moment you start working in the engineering or manufacturing industry where it is not uncommon to have double quotes embedded in a field (i.e 5 1/4 Steel Bar) your code will bite you. On 15/08/2012 23:24, David Wolverton wrote: I've done this in the past by doing this: SWAP DQUOTE WITH

Re: [U2] *** GMX Spamverdacht *** UniVerse LIST statement question [not-secure]

2012-07-02 Thread Mecki Foerthmann
Since we don't have outer joins I would build a work file starting with selecting all employees, then select the calls and merge them together in a loop. How you do it depends on how you want to present the data. If you're happy with showing the calls as multi values you can build the records

Re: [U2] Reasons to continue with Software vendor support

2012-06-29 Thread Mecki Foerthmann
I can understand your concern and also the reasoning of your boss. Since you are dealing with Epicor cancelling the maintenance for ManFact will most likely mean that they will cancel your U2 support too. The company I work for went through the same drama. 'You cancel the support contract for

Re: [U2] Really trying to understand dynamic file sizing

2012-06-29 Thread Mecki Foerthmann
So if I understand this correctly - a dynamic file will only split when it goes into level 2 overflow? If that is so than wouldn't decreasing the block size as I suggested earlier make the file split much earlier than using a larger block size? Why then don't you just double the modulo, find the

Re: [U2] Reasons to continue with Software vendor support

2012-06-29 Thread Mecki Foerthmann
Well, we now have 'real' U2 and SB+ licenses. I don't know how it was done, but I guess 'by the book' Rocket can also sell new tranferable licences for whatever price they want to whoever they want. None of Epicors beeswax, really! Better than loosing a paying customer at least in my book. ;-)

Re: [U2] Can of worms FILE.STATUS

2012-06-21 Thread Mecki Foerthmann
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, June 20, 2012 12:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Can of worms FILE.STATUS Nothing really - less than 10

Re: [U2] Regarding: Unidata dictionaries

2012-06-20 Thread Mecki Foerthmann
UniData Dictionaries Every UniData data file has a corresponding dictionary file. A dictionary contains a set of records that define the structure of the records in the data file, called D-type records. A dictionary may also contain phrases, called PH-type records, and items that calculate or

Re: [U2] U2 accounting software question

2012-05-23 Thread Mecki Foerthmann
Or because that's what they know best... On 23/05/2012 15:13, Bill Brutzman wrote: To me, this is a question for the accounting department there. Corporate accountants that I know favor Oracle financials... for their functionality, reporting, and ease of use. --Bill

Re: [U2] Case Statement with only two cases... or for that matter... one case

2012-04-21 Thread Mecki Foerthmann
Well, I prefer: IF A = TEST THEN GOSUB DO.SOMETHING ;* Say why END ELSE GOSUB DO.SOMETHING.ELSE ;* The reason END IMO much more readable - because you see immediately that is is a conditional branching. It is also easier maintainable if you want to add

Re: [U2] Remove items from lsit in DICT

2012-04-06 Thread Mecki Foerthmann
That will not remove the Bs but only replace them with nulls. You will have to remove the value marks as well. Of course that will not work on single values and if the last value is a B. My first thought was to use MODIFY command but I think that can also just replace an attribute or value with

Re: [U2] Remove items from lsit in DICT

2012-04-06 Thread Mecki Foerthmann
You could try selecting BY-EXP dictname # B On 05/04/2012 23:05, Holt, Jake wrote: This is probably really simple, but I can't seem to find a way without writing a sub. Is there an easy way to simply remove items from a MV field in a dictionary? For instance if I have a MV with A,

Re: [U2] Remove items from lsit in DICT

2012-04-06 Thread Mecki Foerthmann
to remove our house rep account from the list of rep numbers when I trans them to the sales order file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 4:05 AM To: U2

Re: [U2] Logging on to UD 7.2 on RH Linux using Active Directory andwinbind

2012-04-06 Thread Mecki Foerthmann
are currently being reported by winbind with wbinfo -u. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, April 05, 2012 9:08 AM To: U2 Users List Subject: [U2] Logging on to UD 7.2 on RH

[U2] Logging on to UD 7.2 on RH Linux using Active Directory and winbind

2012-04-05 Thread Mecki Foerthmann
We are finally in the process of upgrading our old UD 5.2 system on Solaris to 7.2 running on a virtual RH Linux server. So far everything seems to work OK. We can log into the database as the root user fine. We can log into the database as a local linux user fine. But we don't want to create

Re: [U2] Record lock

2012-03-23 Thread Mecki Foerthmann
I don't know about Universe but UniAdmin displays the time the lock was set in UD. On 23/03/2012 06:06, Namacha, N. (Nicholas) wrote: Is it possible to know for how long a record has been locked in universe? Kind Regards Nicholas Namacha Nedbank Limited Reg No

Re: [U2] Turn a device and inode into file name

2012-03-17 Thread Mecki Foerthmann
You can also use UniAdmin. That will show the file name as well. On 17/03/2012 17:12, dia...@aptron.com wrote: Thanks!!! Quoting Charles Stevensonstevenson.c...@gmail.com: Diane - Here's a short LIST.READU envelope that replaces dev/inode with filenames. Look up these UV-supplied tools

Re: [U2] Unusual code

2012-03-15 Thread Mecki Foerthmann
The code will perform the Enter Problem codes sub if anything except Y or 1 are entered. So why test for N and 2 at all? Just to let the terminal beep which doesn't work on a terminal emulator anyway? I would have just used IF THEN ELSE. On 15/03/2012 19:18, Susan Joslyn wrote: For

Re: [U2] Including Code - A Best Practice?

2012-02-08 Thread Mecki Foerthmann
Like with most things I'd say it depends. I have worked with quite a few systems that use standard includes and haven't noticed that those were harder to maintain than those that don't. The reason being that those includes never get changed. Usually these include equates (TRUE, FALSE, VM, AM

Re: [U2] Building an Excel File

2012-02-07 Thread Mecki Foerthmann
R.I.P. On 07/02/2012 17:52, Brian Leach wrote: what a horrible thought ... some things rightly belong in the trash can of history. Jet and Runoff are definitely in that category. Brian Sent from my ASUS Eee Pad Wjhonsonwjhon...@aol.com wrote: Dig it up and market it because Universe is

Re: [U2] Passing by Value

2012-01-27 Thread Mecki Foerthmann
Thanks, I'll try it out next time I'm chasing a variable. On 27/01/2012 22:52, Wols Lists wrote: On 26/01/12 21:26, Mecki Foerthmann wrote: What does -X do? Sorry if this has already been answered, but I guess it's what I know as XREF. It creates a listing of all the variables used

Re: [U2] Passing by Value

2012-01-27 Thread Mecki Foerthmann
I 100% agree with you Tony. I really feel put off by the arrogant attitude in his replies. First asking bloody beginner's questions and then accusing seasoned professionals when they offer a (free) solution that they don't know what they're talking about. Who does this guy think he is? I

Re: [U2] Passing by Value

2012-01-26 Thread Mecki Foerthmann
What has the length of the program to do with it? I always abide to the rule that a for next counter in any internal subroutine has to be unique. That way even if the sub is called from within a for next loop the counters never conflict. So it doesn't make any difference whatsoever if a program

Re: [U2] Passing by Value

2012-01-26 Thread Mecki Foerthmann
No, you are completely wrong if you think that is only your world. Who in our game has the luxury working only with their own code? I have been doing what you describe for over 25 years now and probably most of the contributors here do the same thing for a living too and not just since

Re: [U2] Passing by Value

2012-01-26 Thread Mecki Foerthmann
Are you trying to be funny? Who in his or her right mind would use 1 letter variables in a 8000 line program except maybe as loop counter or as throw away variables? And you have just explained why that is a stupid idea. And if you have a program like that? Tough luck, sounds like hard earned

Re: [U2] Passing by Value

2012-01-26 Thread Mecki Foerthmann
pieces into the first. As long as the object didn't exceed 32K, it worked. Ah, those were the days! :-) Regards, Charlie Noah On 01-26-2012 2:54 PM, Mecki Foerthmann wrote: No, you are completely wrong if you think that is only your world. Who in our game has the luxury working only

Re: [U2] Passing by Value

2012-01-26 Thread Mecki Foerthmann
What does -X do? I'd probably compile it with -Z2, run the program in debug and put a trace on A. On 26/01/2012 21:22, u2ug wrote: BASIC -X !!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent:

Re: [U2] Passing by Value

2012-01-26 Thread Mecki Foerthmann
Not to mention L ;A= and L ;A = On 26/01/2012 21:15, John Hester wrote: One of these searches should eventually work: L A= L A = L A= L A = Unless the original author used some kind of ridiculous syntaxt like: A = 500 Granted, you're also going to get results for any IF/THEN

Re: [U2] Brilliant? or not?

2012-01-16 Thread Mecki Foerthmann
I agree, if it took you more than 4 seconds to work that piece of code out you shouldn't be a programmer. But if it requires working out and thus at least twice as long than reading a simple if-then-else statement it's definitely not a brilliant piece of code. On 16/01/2012 20:16, Symeon

Re: [U2] Brilliant? or not?

2012-01-13 Thread Mecki Foerthmann
What's wrong with IF S1 S2 THEN SMAX = S1 ELSE SMAX = S2? Definitely more readable! If it was hard to write then it should be hard to read, I guess. On 13/01/2012 17:41, Wjhonson wrote: SMAX = (S1 S2) * S1 + (S2= S1) * S2 ? ___ U2-Users mailing

Re: [U2] SB Missing Screen

2011-12-23 Thread Mecki Foerthmann
You should use SRC (or F8 in PRC) to check if all processes are actually part of your project. When working on multiple projects it can easily happen that part of one project ends up in a different one. So while everything works fine in development or test when you load it parts of the project

Re: [U2] Extract first and last name from free-form name

2011-12-14 Thread Mecki Foerthmann
And the list goes on and on and... That's why free form names are an absolute pain and should be avoided. It's so much easier to have Title, First Name(s), Last Name(s) fields in the input screen and keep them as separate attributes. You never get it 100% right. In your list take Dean or Prince

Re: [U2] Extract first and last name from free-form name

2011-12-14 Thread Mecki Foerthmann
-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 14 December 2011 08:22 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Extract first and last name from free-form name And the list goes on and on and... That's why free form names

Re: [U2] Dynamic Connect TimeOut

2011-11-17 Thread Mecki Foerthmann
You need the AUTOLOGOUT to kill off processes that are left behind if a user turns their PC off without disconnecting. So it's not a good idea to turn that off. That's why SBClient and I guess DC too send a keep-alive signal to the server. This worked fine under XP but on Win7 machines this

Re: [U2] Code Collaboration

2011-11-17 Thread Mecki Foerthmann
I think a major problem is the lack of training/documentation. Great that there are all these new possibilities, but if you have to figure everything out yourself it becomes very difficult to keep up with the technology. A lot of VARs (especially ours) are no help if you get the feeling they

Re: [U2] Dynamic Connect TimeOut

2011-11-16 Thread Mecki Foerthmann
I experience the same problem with SBClient and mvDeveloper (UD 5.2 on Solaris) ever since I swapped my old PC running XP to a new 64 bit Windows 7 PC. After about an hour and a half of inactivity I get disconnected. I have the suspicion that Win 7 doesn't send the keep alive that is expected.

Re: [U2] Dynamic Connect TimeOut

2011-11-16 Thread Mecki Foerthmann
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 16 November 2011 17:06 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Dynamic Connect TimeOut I experience the same problem with SBClient and mvDeveloper (UD 5.2 on Solaris) ever since I swapped my old PC

Re: [U2] Dynamic Connect TimeOut

2011-11-16 Thread Mecki Foerthmann
Thanks John, I'll have a word with the system admin if I actually (need to) have the firewall switched on. Win7 is new to us. I have been the guinea pig and can live with it. But all new PCs in the company are now Win7 so getting this sorted would be nice. Mecki On 16/11/2011 19:53, John

Re: [U2] Using 'MATCH'

2011-11-04 Thread Mecki Foerthmann
Well, you still won't find the first occurrence with INDEX() since it hasn't got a comma in front. Using the right tool (in this case LOCATE) for the job always helps! On 01/11/2011 15:05, Charles Stevenson wrote: What Wol George Smith said. MATCH's raison d'etre is _PATTERN_ matching. That

Re: [U2] Using 'MATCH'

2011-10-31 Thread Mecki Foerthmann
I don't get the problem. Why would you want to do this in the first place? Why not just convert the commas to @VM, use LOCATE and convert the @VM back to commas? BTW if the first string is HELL or it is the first entry then counting ,HELL, won't find it either. KISS! Mecki On 31/10/2011

Re: [U2] Avoiding deadly embraces

2011-10-27 Thread Mecki Foerthmann
I think Asvin means this ;D On 27/10/2011 17:33, Wjhonson wrote: First explain what you mean, then I can answer it. How do I do what? Will wrote: It seems like some of you have only ever worked on rather simple systems, built by yourselves :) Try working on systems that have been

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-26 Thread Mecki Foerthmann
You are right, you don't always know in advance which records you need to lock. If the processes are human controlled this can be solved by letting each user know who is locking whom out and they can solve the problem hopefully themselves. If phantom processes are doing this you don't have this

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-26 Thread Mecki Foerthmann
Come on, get real. Do you suggest the deadly embrace would be better and he would get his results any quicker? And anyway, an ER doc not getting his lab results because of a mass update process running as a phantom encountering a locked record? And who would hold a lock on those lab results

Re: [U2] Avoiding deadly embraces

2011-10-26 Thread Mecki Foerthmann
What do you think I am doing day in day out? I work with Avante 9.2 from Epicor and I definitely didn't write that myself. And this isn't the first system I've worked with in nearly 25 years in the MV world. And to be honest I have barely scratched the surface of Avante since I only look at

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-26 Thread Mecki Foerthmann
I never said anything about blindly (I guess that's what you meant) skipping records. I suggested writing the locked record ids somewhere else and process them later for Wills not necessarily life-threatening sales rep update phantom. I at least don't feel threatened by accountants. If

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-25 Thread Mecki Foerthmann
Firstly a file isn't empty any more after the first WRITE. Secondly we have item and not file locking so if the file is empty or not is irrelevant. And last but not least only if you have exclusive use of a work file for instance you may not have to worry about locks and waiting since you are

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-25 Thread Mecki Foerthmann
Oh yes there is a very easy solution. If you write a mass update process like in your example you skip the records with a lock and write them to an error log file. That way you never end up in a deadly embrace. After you finished the mass update you can then check for skipped records and

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-25 Thread Mecki Foerthmann
So you just examine the errors at the end of the process and fix them automatically. The accountants will never know ;-) Where there is a will there is a solution! On 25/10/2011 19:20, Wjhonson wrote: Your second solution only works if one of the processes is controlled by a human. I've

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-25 Thread Mecki Foerthmann
You could do it all in one program and run only one phantom, but of course you can make it a lot more difficult if you want too. KISS On 25/10/2011 20:13, Wjhonson wrote: I know I'll write a phantom to monitor the phantom and write an error log read by a third phantom! I'll be at the top of

Re: [U2] DataVu

2011-10-24 Thread Mecki Foerthmann
Yeah right, if you can get it to connect. On 24/10/2011 22:20, David Jordan wrote: The cost is a fraction of Cognos and DataVu provides more development functionality. You also don't have the cost of adding an SQL Server database and work to copy from UniData to the SQL Server that you would

Re: [U2] [UV] LIST.READU EVERY's waiters when there are writes w/o explicit readu.

2011-10-24 Thread Mecki Foerthmann
Now why would anybody want to use a WRITE without a READU? I can possibly understand that somebody would want to do it with a WRITEV (i.e writing a flag on a record) but WRITE? And WRITE totally ignoring locking would be outright stupid. On 24/10/2011 22:28, Woodward, Bob wrote: I would think

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-07 Thread Mecki Foerthmann
Well said Charlie. I was going to say something similar but you beat me to it again. :-) Mecki On 07/10/2011 11:08, Charlie Noah wrote: I agree with Ross here. Updates every 3-4 weeks sounds like an awful lot. I get cranky when I have to install updates for any program that often. I've

Re: [U2] SLOW

2011-10-07 Thread Mecki Foerthmann
Maybe you should get him to buy FAST? sorry, couldn't resist either Mecki On 07/10/2011 21:21, Drew William Henderson wrote: with apologies to Jeff and Peggy...and, ok, everyone else, too! My boss has noticed today that we've been running SLOW, and isn't happy about it. He wants to know

Re: [U2] The math just doesn't work.

2011-09-29 Thread Mecki Foerthmann
You didn't read Martin's answer, or did you? So to what value is WIDEZERO set on your UV system? On 29/09/2011 16:40, Oaks, Harold wrote: Running Martin's code on a Universe system, got: (A+B) = C? YOU ROCK A = 4096.9, B = 106.19, (A+B) = 4203.09, C = 4203.09 Interesting - Universe does better

Re: [U2] The math just doesn't work.

2011-09-29 Thread Mecki Foerthmann
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, September 29, 2011 8:53 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] The math just doesn't work. You didn't read Martin's answer

Re: [U2] I-type Subvalue question

2011-09-13 Thread Mecki Foerthmann
That may be right but most of the examples are for single value attributes and most of the problems we face are with multi-valued ones. On 13/09/2011 02:13, Boydell, Stuart wrote: For future reference, the doc set comes with a full-text index (the .pdx file) that allows you to search (words,

Re: [U2] Unidata 7.1.22 Index Issue

2011-09-09 Thread Mecki Foerthmann
You may have a problem with leading zeroes. Are there by any chance 2 records with 9 in Record120,2? On 09/09/2011 04:08, Kevin King wrote: What can I get you Wally? We did a CREATE.INDEX WO SHOP.CODE NO.NULLS followed by BUILD.INDEX WO SHOP.CODE. The index seems to work fine immediately

Re: [U2] Lock Status

2011-09-08 Thread Mecki Foerthmann
I dare to disagree. If you ALWAYS use a subroutine that records the pid, the file, item Id and program on a logfile when you want to read and lock a record and ALWAYS use a subroutine that removes the info from the logfile to write or release this could work. Otherwise it won't. On

Re: [U2] Lock Status

2011-09-08 Thread Mecki Foerthmann
Now that's a program I'd like to see. I've been trying to write one that makes cups of coffee, but so far no luck.:-D I always tell my clients when they ask me for things that can't be done without rewriting the whole system, that I will do the impossible straight away, but miracles may take a

Re: [U2] DataVu Query [ad]

2011-09-07 Thread Mecki Foerthmann
] On Behalf Of Mecki Foerthmann Sent: Wednesday, 7 September 2011 9:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install software like that without having to search the documentation for hours. I don't mind

Re: [U2] DataVu Query [ad]

2011-09-07 Thread Mecki Foerthmann
I haven't tried the slashes. Maybe that does the trick. On 07/09/2011 00:08, Wjhonson wrote: I also have a weirdness with that server name. Either it wanted the \\ in front or it didn't I can't remember which. I do remember fiddling with that field. Too bad it can't query What drives are you

Re: [U2] DataVu Query [ad]

2011-09-06 Thread Mecki Foerthmann
David, I bet you are right, but what users want is to be able to install software like that without having to search the documentation for hours. I don't mind if I have to search for and download a JDBC driver from the net to connect to SQL Server, DB2 or Oracle data sources but I expect a

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-02 Thread Mecki Foerthmann
Doug, Your scenario may work for the classical programmer who just types in code that somebody else has written on paper all day, but who actually does this these days? Certainly not me! And it is not the number of lines of code you can type in a certain amount of time, it is the quality of

Re: [U2] PC based UniBasic program editor for 64 bit OS

2011-09-01 Thread Mecki Foerthmann
Doug, How does my company save money if they have to buy and pay an annual license fee for an editor? They might as well ban going to the toilet or making and drinking coffee during working hours. I probably could be even more productive if the company would pay ME more and not you. I can

Re: [U2] Simple Masking of Password Input (Universe Basic)

2011-08-17 Thread Mecki Foerthmann
When I was a Junior programmer I wrote pretty much the same piece of code. Unfortunately the users hated it! For the sake of displaying something when they typed a password they lost the ability to correct typing mistakes. Because with INPUT,1 the Backspace key doesn't work! So I had to go back

Re: [U2] Why Pick U2 ?

2011-07-14 Thread Mecki Foerthmann
So what are libraries? They are nothing but a collection of subroutines that somebody else has written. And what do you do if you can't find a function in your library that does exactly what you need? You write your own, right? And by the time you have found the right function in your library

Re: [U2] Why Pick U2 ?

2011-07-14 Thread Mecki Foerthmann
I don't even know what JSON is supposed to be good for, so why would I want to use a web service that emits it? I don't have a need for a JSON parser, so why should I write one? And what if I don't need serialization, compression and PDF generation? Well, I have tools for generating PDFs, but

Re: [U2] Epicor and Eclipse

2011-07-08 Thread Mecki Foerthmann
Colin So I wouldn't be allowed to write a single line of code using U2 or SB+ if I were one of your customers? Because that line of code wouldn't be part of your application and therefore would invalidate my U2 license, right? In that case I would never buy any application software from you.

Re: [U2] Epicor and Eclipse

2011-07-08 Thread Mecki Foerthmann
£100/hr really pissed them off. It isn't per-seat licensing but greedy software vendors that come up with rip-off schemes like that which give MV a bad name. Mecki On 08/07/2011 17:53, Tony Gravagno wrote: From: Mecki Foerthmann As I see it - I either buy a license for your application

Re: [U2] Epicor and Eclipse

2011-07-07 Thread Mecki Foerthmann
Well, I don't know Eclipse, but the company I currently work for is running Avante from Epicor. When the company wanted to cancel the Avante maintenance agreement Epicor claimed that this would automatically cancel UniData and SB+ support as well. Avante maintenance was a total waste of money

Re: [U2] Saying Goodbye... Reasons not to say goodbye.

2011-04-29 Thread Mecki Foerthmann
Doug, Fine, Eclipse may be a full blown IDE, but I still can download it from the net for free and use it without having to pay an annual license fee. Why? Because it is open source perhaps? So where do the 'hundreds of millions of development dollars' come from? Donated by companies like

Re: [U2] Saying Goodbye... Reasons not to say goodbye.

2011-04-28 Thread Mecki Foerthmann
Doug Do you really believe staff are more productive if they can play around with skins and colours all day? And I still have to see the office where people use smart phones and tabloids instead of PCs. Fine, maybe the top brass wants to see KPIs and fancy graphics on their toys to show off

  1   2   3   >