RE: Calling UniData subroutines via OLEDB
Steven, Sorry I don't know this for UniData, but I posting just in case it may use similar techniques to those under UniVerse. On UniVerse you can use the CALL statement (that's CALL as in SQL CALL not a BASIC CALL) CALL subroutine(Args) MyCmd.Text = 'CALL MySub(1)' (NOTE : This is considered by ADO to be an SQL command, not a stored procedure). This returns either: A) any printed output as a single column named 'PRINTED OUTPUT', or B) you can execute native uvSQL commands using SQLExecDirect and capture the result into a system variable named @HSTMT. This then passes the results back as an ADO RowSet. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 26 April 2004 23:36 To: [EMAIL PROTECTED] Subject: Calling UniData subroutines via OLEDB Hello We're struggling through the IBM documentation to figure out how to call a subroutine on UniData via OLEDB. (The OLDB.pdf) I'm hoping some one can point us in the direction of some additional documentation or code examples. I've begun searching in the archives, but only limited success so far. thanks in advance for any info. Steven Covey Senior Business Analyst JIA, Inc. (Jenkon) [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Problem reactivating select list
John, Why write a wrapper? ED is a scrudgy BASIC program - (uv Account BP ED.B). You could just modify that. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: 26 April 2004 22:22 To: U2 Users Discussion List Subject: [UV] Problem reactivating select list I wrote a wrapper for the ED command last week to keep an audit trail of any changes made to files outside our applications. I'm just writing a before and after version of an edited record to a temp file and comparing afterwards. All seemed fine until one of my coworkers informed me he could no longer use X to drop back to TCL after editing from a select list. This was due to the fact that I was processing the select list in the wrapper program and just executing ED once for each record. For X to work as it used to, I need to write out all the selected records at the beginning, let ED process the select list, then go back through the list again for comparison. Here's the problem: No matter what I do, I can't get ED to recognize an active select list that is activated within the wrapper program. I use READLIST ITEMS at the beginning to get the list of items to write to the temp file, then SELECTN ITEMS TO 0 prior to executing ED. I also tried writing the list to SAVEDLISTS and executing GET.LIST :TEMP.LIST prior to executing ED, but got the same result. These two test programs illustrate the problem: BP TEST.READLIST 0001: READLIST ITEMS ELSE ITEMS = '' 0002: PRINT 'CONTENTS OF ITEMS=':ITEMS 0003: SELECTN ITEMS TO 0 0004: EXECUTE 'RUN BP TEST.READLIST2' 0005: LOOP 0006: READNEXT ITEM ELSE EXIT 0007: PRINT 'READNEXT ITEM=':ITEM 0008: REPEAT 0009: END BP TEST.READLIST2 0001: READLIST ITEMS ELSE ITEMS = '' 0002: PRINT 'CONTENTS OF ITEMS=':ITEMS 0003: END Output: SELECT BP SAMPLE 10 10 record(s) selected to SELECT list #0. RUN BP TEST.READLIST CONTENTS OF ITEMS=1 2 3 4 5 DD FF MCT1 T2 CONTENTS OF ITEMS= READNEXT ITEM=1 READNEXT ITEM=2 READNEXT ITEM=3 READNEXT ITEM=4 READNEXT ITEM=5 READNEXT ITEM=DD READNEXT ITEM=FF READNEXT ITEM=MC READNEXT ITEM=T1 READNEXT ITEM=T2 Clearly the select list is activated by SELECTN because the subsequent READNEXT works, but the executed program can't see an active select list. Is there any way around this? I'd hate to have to make a modified copy of the UV ED command, but that's the only alternative I see at this point. TIA, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How far can U2 scale?
Dawn, Looking at this from outside, I would suggest that session persistence creates the overheads, so if you are running a traditional application that needs to maintain a single session per user (e.g a green screen or UniOjects application) you are probably limited to several thousand users on current hardware. There are a number of sites over here that run those sort of numbers. If you adopt a 'pure database' model (i.e. not an embedded database running the application) a la SQL Server or Oracle, where you are just farming data in response to requests or calling atomic stored procedures, and using some form of responder architecture, I cannot see why there should be any real scaling limits. After all, we run hundreds of users through RedBack on hardware that is not particularly massy or fast. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: 23 April 2004 14:50 To: [EMAIL PROTECTED] Subject: How far can U2 scale? At what point in the life of application software would it be so large that you could not (or would not want to) support it with your existing UniData or UniVerse database? Is there a point where you would be better served by DB2 or Oracle, for example due to the scale you are working with? I hear people talk about moving way from U2 in order to do ODBC and use standard industry tools (and most find that the grass is not greener for those purposes), but I don't hear about switching because of running into scaling issues. However, we sometimes think of PICK as addressing small-to-mid size businesses and RDBMS folks sometimes think of their products as scaling the best. So, what's the cut-off for U2? Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: GUI as nice as character-based
To go back to Dawn's original post - Dawn, I've been writing GUI applications for UniVerse for about 15 years now. Some have worked, some have - well - been learning experiences. You shouldn't really compare GUI and character based. Why? Because then you inevitably start to think of the GUI in character based terms - the arrangement of controls on a form, or the addition of some buttons. That's my main beef with 'intelligent' terminals - they obscure the real picture. GUI is not about what you put on the screen. It's about the flow of information, and how that flow best suits the application in question. Data entry is part of that flow, but only part: character based is good for some data entry and for administration, but a good application is also about navigation, culture and the ease of finding information again. Here are two very different examples: I did a freight forwarding package for a company that previously was entirely paper based. They took a - let's say flexible - approach to rules, validations, pricing, descriptions etc - and wanted to keep that. Providing a traditional system, with a nailed down design and entry screens just wouldn't work for them. In fact I tried that first as a prototype, and it didn't. Not in their culture. So I designed a system that worked the same way as their forms. Every page matched the standard forms they used, except that information automatically infilled, was sent to their billing systems, collated to their work flow for follow ups and diarising etc ... But all invisibly. What they 'saw' were the forms they had used throughout. Even the validation was fairly soft, and consisted mainly of highlighting things that were suspect. Annoying popups were kept to an absolute minimum, text and codes expanded directly from typing, and generally the whole thing designed to look and feel as unobtrusive as possible: nothing to interrupt their work flow. I couldn't have done that with a character based system because it couldn't have represented the compexity of some of the forms (try doing an airway bill or customs declaration form and you'll see what I mean). As a more traditional example, I have a project management system that I both designed and use. This is based on drill down principles, allowing me to track projects, modules, scheduled and tasks. Here the advantage of a GUI is persistence and workflow: because a GUI allows me to have multiple windows open modelessly, I can track down from the projects or work lists into the individual tasks whilst keeping the lists (heirarchically arranged) still visible, so I don't have to keep closing down windows or reselecting: generally much more efficient. I can also display more, since most of the time I am interested in viewing information rather than changing it - and at the viewing stage I can use smaller fonts to display things that when amended need larger screen estate. The diary is a case in point: I can use colours and smaller fonts to show different entries in a way that a green screen application wouldn't accommodate. And naturally I keep a document path, so any documents/project plans/applications or other materials connected with a task can be opened directly on my desktop. I have seen good GUIs: ones that improve process and work flow and make life genuinely easier. I have seen bad GUIs that interrupt work flow, slow people down (bl**dy mice and message boxes). Good GUI works. Bad GUI is bad bad bad. But too often GUI is blamed for the lack of vision or competence of those implementing it. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: 20 April 2004 02:03 To: 'U2 Users Discussion List' Subject: RE: GUI as nice as character-based Citrix and I don't get along -- too many bad memories trying to set up ODBC so that client machines ... anyway, I know that there are reasons that shops use it, just as there are reasons I hope not to have to touch the product again ;-) And I didn't intend for Java to be the only possible solution to fit the rules -- I just tried to be sure to rule out the V-word ;-) [Just a little joke there -- I actually think that Visage is likely an excellent choice for Microsoft-centric sites and I'm a Ross-fan myself, remember] Cheers! --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Monday, April 19, 2004 7:21 PM To: U2 Users Discussion List Subject: RE: GUI as nice as character-based Dawn, Citrix Server would break DLG (Dawn's Law of GUI) rule 4 anyway, as you would need to pre-install Citrix client software on most platforms. BTW Dawn, do you have a mathematic proof of DLG ? Just wondering, 'cause just like the Great Date Debate, many may be happy to 'bend' these rules because they don't apply to the environment they use ? For example,
RE: GUI as nice as character-based
I was hoping Ross would recognise the possiblity that Windows might go the same way despite current market domination. So write your clients in Delphi - Delphi for Windows native Delphi for .Net Delphi (Kylix) for Linux and D2J - produces Java bytecode from Delphi. Or if you want browser based cross platform - is anyone on the list using Macromedia flash to talk to U2 through web services? I haven't had the chance to experiment with that yet :-( but AFAIK flash is available as a plug in on Windows, Linux and Mac and it should be possible to do some pretty good interactive stuff using that combination ... Brian This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: GUI as nice as character-based
(scary how much php has moved up lately!) Actually I find it reassuring to know that PHP is still more popular than C# Brian This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: GUI from Mv code Re: Crystal Reports
When we advise clients on GUI, we always advise a divide and conquer approach. It is amazing just how small a percentage of a system actually needs to be GUItized, once you have partitioned out the business rules, report and (strange) user menus, admin facilities etc. Use a regular report designer [AD - mvQuery] to handle the reporting. Keep the admin stuff on the green screen. Turn business rules into subroutines and test then from the green screen first. Then look at what is left, and employ someone who understands GUI to create the new front end. You might be surprised how little is left to be reworked, if you use the right tools. We use uvCase, but we don't sell that outside the UK so that won't help you! But there are plenty tools around that can. soapbox moment Sticking a few text and combo boxes on a screen is not a GUI. It's a form with a few text/combo boxes. Desiging an effective GUI is a skill that takes time to learn - like any other computing skill. Do employ someone to help you do it. /soapbox moment Some lateral thinking can help too: One of my favourite demos for mvQuery involves running a Command Before to capture an existing BASIC print job. I have a simple 300 line BASIC program that executes a print job to HOLD, uses a definition record to strip data from the job by locating recognized headings/subheadings and stripping text out at relative x and y offsets, and uses that data to write a number of records into a work file. I can then use mvQuery to select the work file and design e.g. a modern looking PDF or an export. None of that is rocket science, and I can use that technique to redesign a quite number of existing reports in a matter of minutes - without having to analyze how the original report was created! You can do similar things with other tools: it's just takes a little bit of thinking around the issue. Brian This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV to Text Conversion Standard?
Jim, I don't see why on earth you want to use fixed length data with Excel. Do you need to normalize the data or are you intending to use multi-line cells? The best way to importing multiline cells into Excel is to generate a HTML file that represents the spreadsheet cells as an HTML table. You can then import line breaks using the HTML br tag. It requires a few lines of code, but it is pretty trivial. If you are normalizing the data, you can dump the data into an XML format using an exploded SORT with the TOXML keyword. You can then load that directly, at least if you are running Excel 2003. Or - blatant plug - if you are doing this repeatedly, you might want to take a look at mvQuery. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 April 2004 15:34 To: [EMAIL PROTECTED] Subject: UV to Text Conversion Standard? I am hopeful someone can offer me some guidance. I have to move data off of my Universe system and send it to a PC for inclusion in a Excel Spreadsheet. Some background: Source data is alpha/ numeric and contains VM's, SVMs and TM Source data fields are variable lengths Requirements: Output must be fixed length Output must be importable into Excel (column definitions will be based on a fixed length map) My problem: I think Excel will choke on VMs, SVMs and TM characters. Is there a standard , ASCII character that I should use to represent them? To further complicate things, sone of the fields represent data that was input with little (or no restrictions), ie. any character on the keyboard was considered valid. Thanks Jim -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV to Text Conversion Standard?
True, But Jim didn't specify his version of UniVerse. if his version does support TOXML it may still be the simplest option, and avoids having to do any coding. If not, it is always available on the Personal Edition ... Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 April 2004 16:34 To: [EMAIL PROTECTED] Subject: Re: UV to Text Conversion Standard? In a message dated 4/14/2004 8:29:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: If you are normalizing the data, you can dump the data into an XML format using an exploded SORT with the TOXML keyword. You can then load that directly, at least if you are running Excel 2003. Brian, not every implementation supports TOXML keyword Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [ANNOUNCEMENT] Visage Roadshow in NZ
If only ... You shouldnt torture us like that - on our first day back to work after the Easter weekend! Now I'm going to spend the rest of the day thinking about the Black Barn vineyard in Hawkes bay... Enjoy your roadshow you swine grin Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: 13 April 2004 01:28 To: U2 Users Discussion List Cc: [EMAIL PROTECTED]; Nick Suvalko Subject: [ANNOUNCEMENT] Visage Roadshow in NZ For anyone that lives in the Shaky Isles, or is simply after an excuse to visit New Zealand, please mark your diaries for April 29-30. mvSolutions and Stamina Software will be staging a 2 day event in Auckland to showcase Viságe as a GUI development tool, and also Viságe.BIT for Business Intelligence/Data Warehouse applications. If you are a U2 (or other mv DB) user or VAR and haven't been invited, please contact the guys @ mvSolutions for details - the more the merrier ! Ross Ferris Stamina Software Visage - an Evolution in Software Development This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Performance
Duh duh duh Please ignore my last post. I scanned it and missed 'AIX'. It's the end of the day here Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: 08 April 2004 17:08 To: [EMAIL PROTECTED] Subject: Performance We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin Kevin D. Vezertzis Project Manager Cypress Business Solutions, LLC. 678.494.9353 ext. 6576 Fax 678.494.9354 [EMAIL PROTECTED] Visit us at www.cypressesolutions.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
Cliff, We whose lists are about to die, salute you. It's been a great service - you should be held up as a shining example to moderators everywhere in promoting the best blend of discussion, humour and debate amongst a very informative list. More than that, you have made us all into a (not always united, but what the hell) community. I'll miss picking through the 700+ emails when I get back from holidays, and I'm sure my productivity will increase as a result ! but what I will mostly miss is the feeling of being part of an immediate, entertaining and switch-on online community. Brian -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VB / SQL questions
Just to add, And if they clash with SQL keywords like DATE, USER or STATUS. So it's just generally safer to enforce them, as you never know what keywords are likely to be added in the future. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: 26 March 2004 18:20 To: U2 Users Discussion List Subject: RE: VB / SQL questions Can someone tell me why I need INSERT INTO test([field1], field2 instead of INSERT INTO test(field1, field2 Brackets are required around field and file names if they contain spaces or other non-alphanumeric characters. Larry Hiscock Western Computer Services http://www.wcs-corp.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Modern Universe - was: The lists are closing
Joe, I shouldn't even dignify this crap with a reply, but anyway ... 1. Populate UV and Oracle with around 10 Million records. 2. Write fairly complex Web Application against it. 3. Run a Web Application Stress tool(around 1000 Users) switching Databases within the same DB Machine. We've written complex web applications against UniVerse with several hundred permanently active users for local government systems (not just simple e-commerce or dynamic web). And they perform excellently, thank you. UV is used as a FLAT FILE... with a bunch of Stuff..packed on it.. and then use PICK to read through these UV Files. Then you're not using it correctly are you? Which puts you in no position to comment. Don't blame the technology for your incompetence in not making the correct use of it. MVDB is designed for embedded processing. Record level writes that don't have the overhead of a SQL layer. Complex processing managed locally to the database, without having to add external business rule layers. Not as a dumb machine to return or update record sets. In other words, comparing UV and an RDBMS are comparing chalk and cheese. They do different jobs. Try to use UV in the same way as Oracle and don't be surprised if it won't perform. Try to use Oracle in the same way as UV and the same thing happens. It doesn't work. Strangely if I tried to drive a formula 1 car around here it won't perform either. It would just break under the conditions. You need a 4x4. Of course they do the same thing - both go from A to B loudly and guzzle fuel. But I know which one will get me home. Without an array of engineers to retune it every day. but I don't belive Corporations use UV as RDBMS... If they are they should be shot. UV is NOT an RDBMS. It's an MVDBMS. If you can't understand that, no wonder you're floundering. A hell of a lot of local and central governments, defence forces, fortune 500 companies use UV as an MVDBMS though - as does a lot of the SMI sector, that can't afford Oracle. I belive developers should appreciate technology for 1. Performance 2. Scalability 3. Ease Of Integration. 4. Advanced Techniques. 5. Resources for Development... RAD etc. I do. That's why I've developed with Borland products for 10 years and with Microsoft products for 15 years. And MV databases for even longer. Working with primitive data stores like SQL Server and Oracle just loses my will to live. Brian This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Writing a RPC Service
Sounds like a pretty stupid idea to me. Shut down unirpc and write something else instead. Best option - buy redback and restrict access to the RBO designer. Then they can only use the objects and their properties published. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael McRae Sent: 26 March 2004 06:30 To: [EMAIL PROTECTED] Subject: Writing a RPC Service A customer has asked how he could implement some stringent security on the 'unirpc' services. In particular, he wants to only allow certain 'Requests' (like the 'Subroutine' method, etc.) from any users out there writing UniVerse Objects front-ends. To me, this means he wants unirpc to fire off uvserver when requested by UniObjects, but to have uvserver only forward on his allowed Methods (and no other). This would keep developers from writing code that could .Read, .Write, .Delete, etc, and force them to obey his security standards. 1) The first option I can think is to 'intercept' the uvserver executable. Has anyone any experience with writing their own Services for unirpc? 2) Next, how about distributing a cut-down version of the DLL (or is it OCX?) that his users will bind into their app? Hoping there's a chance... Michael McRae -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ANTIVIRUS
We used until very recently to run McAffee on Linux to scan all of our emails. It was slow and difficult to incorporate into our configs, but it was effective. Mind you, our mail server wasn't exactly the most powerful Linux box we were running... Now that is handled corporately, so I dont know what we're running centrally. But each PC is set up with NAV or Symantec as a double check. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Björn Eklund Sent: 25 March 2004 11:47 To: 'U2 Users Discussion List' Subject: SV: ANTIVIRUS Is anyone using AV software on Unix systems like Solaris? Björn Eklund Anknytning 2088 -Ursprungligt meddelande- Från: Anthony Youngman [mailto:[EMAIL PROTECTED] Skickat: den 25 mars 2004 11:52 Till: U2 Users Discussion List Ämne: RE: ANTIVIRUS We use sophos. www.sophos.com Just a dedicated AV company, and does nothing else. Plus you can get bulk licences (or could last I checked) so it is MANDATORY for all personal pcs that they be running sophos if the owner wishes to connect them to the company net. We just give them a cd and tell them they MUST install it. Cheers, Wol -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ANTIVIRUS
Of course, as every article will tell you, the main thing is not what AV you are running. There are lots of good ones out there. The main thing is to ensure that your definitions are kept up to date. Otherwise they are all equally useless. I did run one that used some form of heuristics to try to isolate potential viruses for which it did not have a formal definition. It causes chaos, identifying about one in 10 files as potentially infected. So I gave up on that route and now just keep my auto-update running. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAWES, Ray Sent: 25 March 2004 11:55 To: U2 Users Discussion List Subject: RE: ANTIVIRUS Yes! We use sophos as below. We are pleased with it. Ray -Original Message- From: Björn Eklund [mailto:[EMAIL PROTECTED] Sent: 25 March 2004 11:47 To: 'U2 Users Discussion List' Subject: SV: ANTIVIRUS Is anyone using AV software on Unix systems like Solaris? Björn Eklund Anknytning 2088 -Ursprungligt meddelande- Från: Anthony Youngman [mailto:[EMAIL PROTECTED] Skickat: den 25 mars 2004 11:52 Till: U2 Users Discussion List Ämne: RE: ANTIVIRUS We use sophos. www.sophos.com Just a dedicated AV company, and does nothing else. Plus you can get bulk licences (or could last I checked) so it is MANDATORY for all personal pcs that they be running sophos if the owner wishes to connect them to the company net. We just give them a cd and tell them they MUST install it. Cheers, Wol -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. Thank you. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Suppressing detail in UniObjects command
Sounds like your ECL type is set differently for your login and Objects sessions. Remember, UniObjects doesn't run LOGIN. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell Sent: 15 March 2004 16:15 To: U2 Users Discussion List Subject: Suppressing detail in UniObjects command Trying to run the command SORT FILE WITH ACTION-CODE = NAG BY WEB-IND BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP via a vb6 program using Uniobjects. objCommand.Text = SORT DTA WITH ACTION-CODE = 'NAG' BY WEB-IND BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP objCommand.Exec The program returns immediately with CommandStatus = 0 Error = 0 and response DET.SUPP is not a valid attribute. Any ideas? This works perfectly from the udt prompt. Thanks Nick This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: EVAL
Is there a way to assign a justification to an EVAL item other than having it use the justification of a field used in the formula? I know you can assign different formatting and conversion. Yes, use the FMT keyword. Brian. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Mvquery Client Not Responding
Dave, 1. Please do not post mvQuery questions to this list. Either send them to your mvQuery supplier, or to mvquery support. 2. The task manager will show mvQuery as not responding whilst it is waiting for the server to complete a select or process a record set. This is because control has passed from the mvQuery client across to the UniLink driver which is in turn awaiting messages from the server. mvQuery is still running, and will respond when the selection has completed: but whilst it is waiting it cannot respond to the task manager. You find the same thing whenever a Windows application is busy waiting for another component - e.g. Excel running an ODBC query. This is usually noticeable when you are running large or complex queries, or running against a limited server: for large queries we recommend using the Print Server edition as that does not impact upon the desktop. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: 11 March 2004 15:48 To: [EMAIL PROTECTED] Subject: Mvquery Client Not Responding When running the Mvquery client on my desktop and performing a query, the windows task manager on my desktop will show that the process is not responding. After a few minutes, the task manager wll indicate that the process is running. I am running the 4.2 client on my desktop. The server is running Unidata 6.06 on Windows 2000. - Do you Yahoo!? Yahoo! Search - Find what youre looking for faster. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How do I make this easier to read?
You could either: A: Use two I Descriptors to turn on and off video attributes testing against @NI: IF NOT(MOD(@NI),2) THEN video_chars ELSE B: Buy a reporting tool like mvQuery (blatant ad) and use the report designer to do it for you. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner Sent: 11 March 2004 18:15 To: 'U2 Users Discussion List' Subject: How do I make this easier to read? I'm running UV10 on NT and this is my screen output: 1) 06-3175 12931097 0 14.46 2.66 5.7453.68 Description:TAYLOR HAMMER LRG 7 1/2 CHROME 2) 06-4100 23 115 181.62 78.63 139.41 43.60 Description:KEYES SKIN BIOPSY SET/6 ONBASE 3) 17-1450 31893516 2644 16.74 4.60 9.7452.82 Description:HALSTED MOSQ FCP STR 5 4) 17-1550 47397801 73716.74 4.76 9.4649.70 Description:HALSTED MOSQ FCP CVD 5 5) 17-2155 35123166 1083 16.74 4.46 9.9054.95 Description:KELLY FCP CVD 5 1/2 6) 19-1055 18732311 5317.63 2.75 4.7642.19 Description:SERRATED DRESSING FCPS 5 1/2 7) 19-1110 230 193 11221.73 6.76 10.98 38.41 Description:SERRATED DRESSING FCPS 10 8) 19-1112 32 8223 26.97 8.49 20.64 58.88 Description:SERRATED DRESSING FCPS 12 How do I make every other two lines a different shade of color so it is easier to read? Kind of like the old line printer paper. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UX to NT
Mark, Are you specifying -nodrv when restoring? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: 07 March 2004 22:42 To: [EMAIL PROTECTED] Subject: UX to NT Having trouble with the uvbackup on unix and uvrestore on w2k box. I set up another disk area for my accounts to go into rather that the c:\IBM\UV default. When I do the restore the W2k box always creates the new account on the c:\IBM\ drive rather than my U: drive like I want it to. I have tried uvrestore at the command prompt like the manual says but it creates the account without the necessary structure to do the UPDATE.ACCOUNTSo I may be missing something simple. Thanks in advance Mark -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - Database backup
Firstly - do not tar a running uv system! This is because: A) you will get physical errors if writes are in progress. B) you will get logical errors if transactions are in progress. C) if you use dynamic files, the headers will not be updated. D) 'nuff said uvbackup should be aware of the write context so as to prevent the problems associated with A and C, but not B unless you use transactions. The only safe way to backup the database is if it is either stopped or quiescent. AFAIR you can pause the database using SUSPEND.FILES if you need to run a backup without taking the system down, but make sure any users are aware that the database is stopped and that any application transactions have completed before issuing it. You can the uvbackup to disk (for speed), dump that backup to device and use transaction logging until the next backup. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Armon Group Sent: 08 March 2004 12:20 To: [EMAIL PROTECTED] Subject: UV - Database backup What are the suggested means of backing up a UV system without taking it down ?? Is there a document anywhere with the benifits / drawbacks of the following methods (or any other methods) uvbackup T.DUMP tar mirror disk system + tar etc _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VB primer help ?
I'm just adding a few points to clarify Ian's excellent example -
A. Ian's example uses the Oracle provider. For Access you need:
PROVIDER=Microsoft.Jet.OLEDB.4.0
B. Access has problems with some field names unless you enclose them in
square braces.
Also be careful about delimiters around the data
e.g.
INSERT INTO [MyTableName] ([AString],[A Number],[ADate]) VALUES ('Some
Value',SomeNumber,#Some Date#)
C. You can do the whole thing in VBScript including reading the import file.
However this is a little non-obvious - you need to instantiate a
Scripting.FileSystemObject along the lines of:
set fso = CreateObject(scripting.filesystemobject)
Set F = FSO.OpenTextFile(fn, 1)
Do while not F.AtEndOfStream
s = F.ReadLine
MyFields = split(s,MyDelimiter)
' do some processing here
Loop
F.Close
I'll let you work out the rest yourself!
Brian Leach
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ian McGowan
Sent: 05 March 2004 06:56
To: 'U2 Users Discussion List'
Subject: RE: VB primer help ?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Maybe one of
you has a
trivial example of updating a row in a VB macro? All the examples I
can find are doing it using a macro EXTERNAL to the
database, when the
one I'm using is run from inside the project... did that make sense?
is there any reason you can't use ODBC or OLEDB and just
issue an update statement? that would seem the most direct
route. this link has an example of the connection string to
use for access:
http://www.asp101.com/tips/index.asp?id=98
and here's a vbscript example that inserts a bunch of rows.
you would want to loop over your flat file reading a line at
a time, issuing updates like:
sql = update mytable set fieldx = ' valuex ' where
sql = sql primarykey = ' mykey '
con.execute(sql)
UID = system1
PWD = ***
Service = marin
Set oAux = CreateObject(Sys1Aux.CAux)
Set Con = CreateObject(ADODB.Connection) Set rs =
CreateObject(ADODB.RecordSet) Con.Open(
PROVIDER=MSDAORA;DATA SOURCE= Service ;USER ID= UID
;PASSWORD= PWD)
for i = 1 to 1
sql=insert into trin_temp values (' i ','
GUIDGen(oAux) ')
wscript.echo sql
con.execute (sql)
next
Function GUIDGen(Aux)
Dim sGUID
sGuid = Aux.GuidGen
' Get rid of the cute curly stuff
sGUID = Mid(sGUID, 2, Len(sGUID) - 2)
GUIDGen = sGUID
End Function
--
-
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
__
__
This email was checked by MessageLabs SkyScan before entering
Microgen.
This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.
DISCLAIMER
This email and any attachments are confidential and may also be
privileged.
If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.
In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]
Microgen Information Management Solutions
http://www.microgen.co.uk
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: Pick AP-Pro Discs
Mark, I assume you've asked the question on comp.databases.pick? If not, you may get more joy there. Brian I'll restate the question: snip Does anyone have the box, manuals and installation diskettes for AP-Pro for the Pentium I system that they could give/loan/sell? This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Variable never assigned a value warning
Marco, The problem is that all it can do is warn that there *might* be a route through that would not assign a variable, depending on conditional logic. The Borland compilers do this - and boy is it annoying. For example, you might have a case statement that handles each potential and predictable input to a routine. Depending on the logic this migh lead to a variable referenced later on, based on the result of that case statement, being seen as potentiall unassigned (since the compiler doesn't know the possible incoming values). So it warns you that the variable might not be assigned. So you then pre-assign the variable to remove that warning, and the compiler then complains that this assigned value may not be used! Duh! The real problem is that over a large Delphi project (some of our components run into hundreds of thousands of lines of code) you can get so many unnecessary warnings like this that you might lose a legitimate warning amongst them. Less of a problem on U2 where you are not linking so much code into a single routine, but potentially annoying all the same. Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 03 March 2004 06:32 To: [EMAIL PROTECTED] Subject: [UV] Variable never assigned a value warning Hi All, Is it technically or theoretically possible for the BASIC compiler (or any other compiler for that matter) to catch (during compilation) all the situations that might result in the use of unassigned variable at runtime within the scope of the subroutine being compiled? Under what circumstances does the compiler catch or fail to catch such situations? Regards, Marco - Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: When is developing with UniObjects the correct approach?
Karjala, UniObjects is the quickest route for client/server work with U2. It emulates the native model for direct file and stored procedure operations - you open a file, read a record by key, perform operations, write it back. Fast and very efficient for transactional applications. The advantage/disadvantage of UniObjects is that it is a permanent per-user connection. In other words, each Objects session operates as a database user, just like a TELNET session. This is essential for integrating with BASIC procedures that expect things like common (persistent) variables to remain between calls and that use pessimistic locking (the default for U2 systems). If you are writing a transactional application for a predictable number of users, UniObjects is the way to go. BTW the best way to consider using UniObjects (and we've been using it since day one of its release) is to code all of your procedures in BASIC on the server first, unit test them, then write the front end to deploy against them. Makes debugging in a 'black box' environment very much easier, and allows you to gain performance improvements by keeping the logic close to the server. Now the drawback is if you want to deploy into a Web/Browser based environment, or any environment where you want to scale up the number of users without scaling up the number of sessions on the database (e.g. a public service where the number of users cannot be predicted) UniObjects does not provide that ability (for the reasons above). For that, you need to use a tool like RedBack, which is specifically designed around a responder mechanism. The final IBM options are OleDB and ODBC. I personally wouldn't use either of these for transactional operations: they are too top heavy as they are adding a whole layer of processing just to make U2 look relational. Which is isn't (really). The only time I would consider these is when interfacing to standard packages that don't understand anything else: and then I'd go for OleDB over ODBC for all of the usual client-side performance reasons. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karjala Koponen Sent: 27 February 2004 19:45 To: [EMAIL PROTECTED] Subject: When is developing with UniObjects the correct approach? Can someone lay out, in relatively simple terms for a simple guy, when using UniObjects is the correct approach to developing an application using one of the U2 databases? And, perhaps, when UniObjects would seem attractive but is not, in reality, a good choice? And, yes, I am sure that reality has lots of 'it depends ...'. Thanks, Karjala -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Recursive GOSUB
Yes. Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 01 March 2004 10:08 To: [EMAIL PROTECTED] Subject: [UV] Recursive GOSUB Hi All, Can a UV GOSUB directly or indirectly refer to itself? Something like so: LABEL: IF (SOME.CONDITION) THEN GOSUB LABEL RETURN Regards, Marco - Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Uniobjects Asp
Nick, Depends on how you far you need to scale, and if you are looking to support large numbers of users. UniObjects is NOT thread safe, but you can roll your own connection pooling - ie. write your logic into a DLL that maintains a series of connections with some form of semaphoring, and call that from your ASP pages rather than calling UniObjects directly. There's something to be said for keeping your logic in a DLL anyway as ASP coding tends to fragment quite highly, and complex pages can be more of a pain to maintain than a complex DLL! Otherwise, your best bet is to use RedBack, which is designed explicitly to support the ASP model, and provides connection pooling and thread safety with a pretty decent level of performance and high scalability. We have put together a number of applications running across RedBack supporting large numbers of users for a local government, including call centres, billing and other fairly intensive applications and performance has not been an issue. Regards, Brian Leach -Original Message- From: Cooper, Rudy [mailto:[EMAIL PROTECTED] Sent: 26 February 2004 21:46 To: [EMAIL PROTECTED] Subject: Uniobjects Asp Hello Everyone, I have a requirement to use Asp with Uniobjects. Our OS is W2K and the backend is UV 10.0.10. I was thinking about creating ActiveX Dll's in VB6 that would do things like create a UV session, instantiate subr object, etc. I read in the u2-users list archive something to the effect of Uniobjects not being thread safe. Does that still hold true ? If so how do you make it thread safe ? thx, rudy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: mvQuery's MVQUERY_LOGIN MVQUERY_ABORT features
Denny, Please send any mvQuery questions to [EMAIL PROTECTED] - we'll be happy to help you out! I use MVQUERY_LOGIN and MVQUERY_ABORT (on UniVerse) frequently as a means of testing mvQuery by COMOing trace output and setting DATE.FORMAT. Here are my paragraphs: ED VOC MVQUERY_LOGIN 3 lines long. : p 0001: PA 0002: DATE.FORMAT ON 0003: STARTCOMO Bottom at line 3. ED VOC MVQUERY_ABORT 2 lines long. : p 0001: PA 0002: COMO OFF Bottom at line 2. If you are getting problems with these we'll need to know: a) which transport you are using (UniObjects or UniLink) b) which database you are using C) which version of mvQuery you are running (client and server) We have discovered that if you are using UniObjects against UniData, certain specific commands you might choose to put inside MVQUERY_LOGIN (notably DATE.FORMAT) are lost by the UniData environment (this relates to an issue with UniObjects). If this is your configuration there is a patch we can ship you. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Denny Watkins Sent: 26 February 2004 21:20 To: [EMAIL PROTECTED] Subject: mvQuery's MVQUERY_LOGIN MVQUERY_ABORT features I'm trying to use the MVQUERY_LOGIN MVQUERY_ABORT features and just can't get them to work. Would any mvQuery users have any sample MVQUERY_LOGIN MVQUERY_ABORT paragraphs they could share with me? You can send them directly to me unless you feel some other mvQuery users could benefit. Thanks, Denny Watkins Director Computer Services Morningside College 1501 Morningside Ave Sioux City, Ia 51106-1717 Phone: 1-712-274-5250 Email: mailto:[EMAIL PROTECTED][EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users __ __ This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Very slow SQL query
César, So the problem is not joins or indices. So it must be somewhere else :-) 1. If you use a SORT command, is that as slow? SORT CCMLIAL BY EMP BY ALBA BY NUMLIN WITH EMPABLA = 1*05236 PEDIDO REFART DESART CANDIDAD CANTMODALB NOPAGE 2. If it is, what are these fields doing? Are they Data fields or I Descriptors? Do any call BASIC subroutines, or do translates (TRANS or XLATE functions?) 3. The obvious one - what is the file sizing like? 4. What does the BASIC program do that is different? There should be no reason for this SQL command to be slow. Brian Leach Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: version control software
Jeff, We use a two pronged attack - I don't think I can share it (sorry) but here is what it does - none of it should be too difficult to emulate: First we have some BASIC routines that stamp our programs with a string in the format: ADGVERDATA='Version=x;' ADGVERDATA:= 'VerDate=xx;' ADGVERDATA:='VerHist=xx' etc. The format of the string means that we can search both source and object code for version stamps (being a variable assignment not a comment they get compiled into the object code string table). We have some simple subroutines that return this version information which we can use e.g. from I-Descriptors to list the versions and from setup routines to check versions; and we have wrappers around our installation routines and checks in the routine we use for any global cataloging to ensure that we don't accidentally catalog an older routine over a newer version. Secondly, we use RCS for delta-ing (we could use CVS but RCS was a simpler option for interfacing). To allow it to handle non-source items (eg dictionaries and parameter records) we wrapper the RCS routines (ci and co) through some routines that essentially maintain an index of the UniVerse location (ACCOUNT DICT FILE LEVEL ITEM) to a numbered UNIX file. These allow allow us to things like accept select lists, so the whole thing is command line driven and very flexible. The routines maintain an index between our version stamps (which are 3 level major.minor.build) and the RCS version (which is 2 level major.minor) so we can search on either. We also apply tags in the index rather than using RCS tags, which are a bit flaky. The routines use the index to copy the item to a type 19 file using sequentially assigned IDs, then commit the copy to RCS. The same index is used to retrieve the item again, and optionally copy the item back to its original location OR to a new location (another reason for using the index). As most of our applications are client/server or Web based, we then apply CVS to our whole development environment, including the RCS repository. Hope this helps, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Steinmetz Sent: 19 February 2004 02:20 To: [EMAIL PROTECTED] Subject: version control software I am looking for a version control application for U2 software development. Ideally it would have a check-out/check-in function, ability to track changes, migration dates, etc Does anyone have any suggestions? Jeff Steinmetz Vice President, Store Systems Guitar Center, Inc 5795 Lindero Canyon Road Westlake Village, CA 91362 818-735-8800 ext 2248 [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Swap array values? In UV
It's an 'old as the hills' C programmers' trick Which is no relection on Glenn of course ... Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 16 February 2004 16:47 To: [EMAIL PROTECTED] Subject: Re: Swap array values? In UV In a message dated 2/13/2004 11:10:14 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Within BASIC, try array(x)=BITXOR(array(x),array(y)); array(y)=BITXOR(array(y),array(x)); array(x)=BITXOR(array(x),array(y)); No temp variable used. ROFL. Nice way to take a simple process and make it unintelligible. You get the gold ribbon. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SQL Server and Crystal Reports
Mark, Not quite an answer to your question, but the first thing I would do would be to get your client to set up an MSDN subscription. The library will help you loads once you get past the initial learning curve and need to see how to do things, and has sample applications to check out. Remember that if you want to 'play', you can load a copy of the MSDE (Microsoft Data Engine) which is fully SQL server compatible (available with professional versions of Office, Visual Studio 6 and .Net) but has a smaller footprint and no licence requirements. As well as SQL Server, (SQL and TransactSQL) you will probably need to know about the various interfaces, so the MSDN is a good choice for reference materials on subjects such as OleDB (ADO). I don't know what the various editions cost - we get the Enterprise edition which is pricey, but not for what you get, and includes a 10 user SQL server licence as well as licences for all the MS platforms, office versions, development tools etc. If your client wants to retain you this could be a very good investment on their part. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 11 February 2004 12:17 To: [EMAIL PROTECTED] Subject: SQL Server and Crystal Reports I would like to know the best beginning books for either of these two topics. I don't yet want a reference, rather to know if 'Dummies' Books are appropriate or if anyone else has better beginning selections. My UD client migrating to these wants to keep me and this is the environment. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
Bill, We have run UniVerse on Linux for years (actually about 10 years, originally using the SCO emulation package for Linux). If you know your way around Linux, and if it is UNIX-y enough for you, we have always found it to be solid. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 11 February 2004 17:35 To: 'U2 Users Discussion List' Subject: UV on SCO Unix We bought the year-end UV amnesty upgrade from IBM. Because of an existing ERP license agreement, we need to stay with Unix. While I would prefer to stay with HP-Ux, pricing for a new HP-Ux server seems to be approaching $10,000. Right now, I am not sure if it makes any sense to upgrade hardware in our HP-9000-E45 box. We would rather spend $3k. Thus, I am considering running SCO on say a Dell server. Any comments on running UV on SCO ? Perhaps there is another Unix besides SCO... Bill Brutzman, Manager IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] www.hkMetalCraft.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Real Time Data Warehouse
Tom, I guess I am echoing various other responses, but here's my 2c anyway: 1. There are a whole host of tools that will populate a SQL database from UniVerse. (I recommend mvQuery: it's my product so I would anyway). You will need to consider how far each solution can be automated and what it allows in terms of reformatting information (mvQuery Print Server provides a server based request system that can be used to shedule regular exports, for example) but by and large getting the data across probably won't be your main problem. 2. I would put the actual data migration to one side initially, and consider first what you want to get out of this. I have seen very successful 'decision support' reporting come out of standard reporting when backed up by a knowledge of what an application actually holds. In my experience, it is usually the fact that managers do not know what information is actually available to them from a transactional system that is the key, and closing that knowledge gap (often on both sides as communication of requirements can also be rather thin) is far more important than jumping straight onto a given technical solution. You could go down the Cognos route and then discover what they really want is an Excel pivot table. 3. You might want to consider native OLAP solutions such as MITS, which runs directly on UniVerse. This might be a) cheaper and b) more flexible in the long run. 4. Before you do any of this, you may need to carefully audit what you have on your U2 system. One of the biggest problems with data warehousing is dirty data - missing entries, entries whose meaning has changed over time, similar but non matching data, etc. These should really be cleaned up at source, particularly if the warehouse is liable to change/respecification over its initial period. Verification is important too - the more abstract the data presented (and OLAP is by its nature highly abstract) the more opportunity for errors to go unnoticed. Again the verification may need to be close to the source data: I remember a systems manager saying to me beware the spurious credibility of a well presented report. Brian Leach This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Formatting a Negative
OCONV(value, MDn) where n is your descale factor, e.g. Crt OConv(123.45,MD2) gives 1.23 Crt OConv(-123.45,MD2) gives 1.23 For more detail, HELP CONV MD (UniVerse). Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baruch Salamander Sent: 10 February 2004 15:01 To: [EMAIL PROTECTED] Subject: Formatting a Negative What's the exact command that places parenthesis around a negative number? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help wanted creating an efficient SELECT statement
You can get part way there through SQL, though you cannot (sadly) capture an SQL SELECT to a select list if it contains a GROUP BY clause. So here is a kind of work-around using a scrudgy bit of a program. I'm sure someone can come up with something better, but this is what first came to mind :-) 1. Create dict items for ID (@ID right justified) andMAIN (@ID[".",1,1]). 2. In a program: TCL = "SELECT MAX(ID) FROM yourfile GROUP BY MAIN COL.SUP COUNT.SUP;" Execute TCL, OUT. Text Convert " " To "" In Text ;* remove leading spaces Text = [EMAIL PROTECTED], 3, DCount(Text,@FM)-3] ;* remove leading and trailing blank lines Open "SAVEDLISTS" TO FL Then Write Text On FL, "MyList" End CHAIN "GET.LIST MyList" Hope this helps, Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco ManyevereSent: 04 February 2004 08:20To: [EMAIL PROTECTED]Subject: Help wanted creating an efficient SELECT statement Hi All, I have a file with IDs like this: 1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ... Each ID is N.X where X is a numeric secondary ID number from 1 going upwardsand N is the primary ID number which may or may not be numeric.Different primary IDs have a different number of secondary IDs. For a certain report, I want to select only the records with the highest numerical value of X for each of N. For the above example, I want to end up with 1.3, 2.4, 3.1, 4.1, 5.2, Can aSELECT statement(s) be composed without having to write a program? If not what would be the best approach. Thanks for any help. Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV SELECT Info Display
Mark, This is probably too late, but FYI it's EXPLAIN Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: 03 February 2004 21:59 To: 'U2 Users Discussion List' Subject: UV SELECT Info Display Brain FreezeWhat's the Keyword you enter at end of SELECT statement to display the Index info it's using? TIA -__ This e-mail, including any attachments, may contain information that is protected by law as privileged and confidential, and is transmitted for the sole use of the intended recipient. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying or retention of this e-mail or the information contained herein is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by telephone or reply e-mail, and permanently delete this e-mail from your computer system. Thank you. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COM Exception
Gene,
More information needed, I'm afraid.
What are you actually using to access UniVerse: is it UniObjects, UniOjbects
for Java, ODBC, OleDB ?
Brian Leach
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Gene W. McDonald
Sent: 04 February 2004 13:55
To: [EMAIL PROTECTED]
Subject: COM Exception
I am new to the list and I have search the archives without finding a
result. SO I apologize, in advance, if this is 'old hat' for some of you. I
am in a situation where we are moving from D3 to Universe. I have written a
VB.Net application which will interact with D3 or with Universe depending
upon the value of a switch. I have been successful in setting up the
application to run in a distributed environment (forgive me if that is the
wrong term, the executable and the supporting dll's reside in a centralized
drive on the server and are accessed by the users via a shortcut. The
intention being that when I make mods to the executable I do not have to
reditribute it to each user PC). ANyway, the application runs fine when
accessing the D3 server, but when I try to access the Universe server, I get
the following error:
System.Runtime.InteropServices.COM exception (0x80040154): COM object with
CLSID {blah blah blah} is either not valid or not registered.
at ISOComplaintLog.ISOForm.Connect_To_UV()
at ISOComplaintLog.ISOForm.Build_Employee_List_UV()
at ISOComplaintLog.ISOForm..ctor()
Does anyone have any suggestions or ideas?
Thanks,
Gene
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
This email was checked by MessageLabs SkyScan before entering Microgen.
This email was checked on leaving Microgen for viruses, similar
malicious code and inappropriate content by MessageLabs SkyScan.
DISCLAIMER
This email and any attachments are confidential and may also be
privileged.
If you are not the named recipient, please notify the sender
immediately and do not disclose the contents to any other
person, use it for any purpose, or store or copy the information.
In the event of any technical difficulty with this email, please
contact the sender or [EMAIL PROTECTED]
Microgen Information Management Solutions
http://www.microgen.co.uk
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: The result of VARIABLE[1,3] + 0
Marco, Sounds like a bug inwhatever pointrelease you are running. What happens if you say B = A[1,3] * 1 ? I would be very worried about a runtime errorfrom '123' + '456'. Not good. Brian Leach From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco ManyevereSent: 02 February 2004 04:14To: [EMAIL PROTECTED]Subject: The result of VARIABLE[1,3] + 0 Hi All, What is the correct interpratation of A = '001' B = A[1,3] + 0 PRINT B On UV 9.6 I get 0010 contrary to my expectation of 1. What is the logical explanation of this. Does UV use '+' for string concatenation as well? Then why doesnt '123' + '456' result in '123456' (I get a runtime error)? Regards, Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
