Re: EXECUTE COMMAND CAPTURING OUTPUT

2004-04-30 Thread FFT2001
In a message dated 4/30/2004 2:07:27 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: What we have is a case where an open file error may occur and we need to have the user go back into a menu, but we do not want them to see the error. Problem is that the error is waiting for user input

Re: [UD] Union Query

2004-04-30 Thread FFT2001
In a message dated 4/30/2004 10:12:57 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: I have 2 files in separate accounts that are structured the same. I want to do something like: SORT ORDER.FILE AND ORDER.FILE.OTHER WITH DATE 01/01/2004 NAME ADDRESS CITY STATE ZIP Is there any

Re: Memo: RE: [UD] Union Query

2004-04-30 Thread FFT2001
In a message dated 4/30/2004 10:11:05 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: 001: I 002: TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,) 003: 004: NAME 005: 25L 006: S But could'nt you do something like IF TRANS(ORDER.FILE,@ID,3,) = THEN

Re: How far can U2 scale?

2004-04-24 Thread FFT2001
In a message dated 4/24/2004 2:32:16 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: Again, what would an 'x' be in MHZ. Or for that fact, what would a MCD spirit 600 be. One of my clients still has one and I could reference it against some of my 2.4Ghz D3 clients. There is no

Re: We need a web based Forum!

2004-04-23 Thread FFT2001
In a message dated 4/23/2004 4:16:59 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: So will the U2 user group, like to look at this solution? This would give us both a web and mail list presence and would make ALL of us happy. It will also show that this community is happy to embrace new

Re: OT RE: We need a web based Forum!

2004-04-23 Thread FFT2001
In a message dated 4/23/2004 11:32:32 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: I would whole-heartedly agree with this. BUT I have never seen such an animal in action myself. I think it's mythical. Will It is not mythical, one of the forums I use works exactly like

Re: We need a web based Forum!

2004-04-22 Thread FFT2001
In a message dated 4/22/2004 12:29:03 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Seems to me a system where *email (the list) carries on as usual *All emailed responses are submitted as forum responses *All forum responses are whooshed out to the list as email I would

Re: We need a web based Forum!

2004-04-21 Thread FFT2001
In a message dated 4/21/2004 9:43:04 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: I think there are better solutions out there. For example searching the web (having web access allows staff to find solutions for your company!) I was able to find this http://phorum.org/ - Phorum is a

Re: GUI as nice as character-based

2004-04-20 Thread FFT2001
In a message dated 4/19/2004 10:57:17 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: Well, perhaps not DOS or dumb terminal vendors g wanna bet ? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: GUI as nice as character-based

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 7:21:58 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Or if you want browser based cross platform - is anyone on the list using Macromedia flash to talk to U2 through web services? Brian Aren't you missing something there? Or can web services speak

RE: Computer Languages gripe was Re: GUI as nice as character-based

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 8:19:38 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: (scary how much php has moved up lately!) Actually I find it reassuring to know that PHP is still more popular than C# Brian Wasn't C# writen by a programmer who could only type 10 words a minute?

Re: What client platform do YOU use (Parallel to GUI thread)

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 10:01:51 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: However my previous employer (7 years ago) which was based in Portland, Oregon had 90% Macs and 10% MS Windows. The accounting department had the Windows machines. Everyone else (about 200 or so) had

Re: We need a web based Forum!

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 11:34:46 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Yahoo groups works this way. You can either post via the web, or from Email, and receive either web only or also via email. Of course, if the forum being used is canned, and doesn't have those

Re: GUI as nice as character-based

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 12:34:33 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: I'll accept that restatement, Will. My intent was not that there was no footprint on the client, but that the user could go to a URL and would be able to launch what they need to from there. So,

Re: GUI as nice as character-based

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 12:43:37 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Also, IMHO the primary usefulness of a GUI (lets face it folks, we're talking about the Microsoft Windows GUI) is the fact that so many people already know how to use it. Wait do you mean the Windoze

Re: MactoPick was Re: What client platform do YOU use

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 2:36:02 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: It is very creatively called MacToPick http://www.carnationsoftware.com/carnation/HT.Carn.Home.html Will Are you saying UD/SB+ runs *natively* on Macs? Or that UD has an OS layer for Macs? Or that you

Re: Uniobjects / php

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 2:20:23 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Not that I'm aware of, but if you're brave you can convince UniObjects for Java and PHP to work together. Look on http://www.pickwiki.com for more information, at least two of us here have done it. So

Re: Uniobjects / php

2004-04-20 Thread FFT2001
In a message dated 4/20/2004 3:12:12 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Do you have a specific project in mind? There are at least half a dozen ways to get U2 data to appear on a web page, the best way depends on what expertise you already have in-house and how complex the

Re: Drilling cubes was Re: Crystal Reports

2004-04-19 Thread FFT2001
In a message dated 4/19/2004 1:34:50 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Now, would anyone care to post any experiences on performance of implementing a star schema in a set of normalized U2 files and doing drill down and roll up strictly with LIST, SORT, and its options?

Re: GUI or Event ? as nice as character-based

2004-04-19 Thread FFT2001
In a message dated 4/19/2004 11:59:57 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Does the requirement to have no client-side setup (other than pointing a user to a web page in a std web browser) eliminate accuterm or not? If not, then does this permit drop-down boxes, combo boxes,

Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread FFT2001
In a message dated 4/18/2004 10:18:11 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: For example, aligning this back to the original post, rather than attempting to use CR for reporting, I'd simply create a Viságe.BIT cube to give the users free-form enquiry and data exploration

Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread FFT2001
In a message dated 4/18/2004 6:08:53 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: Sorry, I'm not going to publish the code here :-) suffice to say that BECAUSE we have had the luxury of time to develop Viságe, we have overcome MANY problems that face this type of technology

Re: GUI from Mv code Re: Crystal Reports

2004-04-18 Thread FFT2001
In a message dated 4/18/2004 9:46:12 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: So YOU, as a developer, would construct a cube with the 6 key fields that the user is interested in. You also get to do things like define an opening view of the information - AND also the query that is

RE: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 9:10:12 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: The tools are there to produce applications on par with anything on the market. Web interfaces via tools like Redback. UOJ, .Net PDP, or the java interfaces are all there to produce great solutions for

Re: can we stop with the pointless displays? was Re: Crystal Reports

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 7:35:30 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: and had to watch the compiler meticulously display those line-by line asterisks during compiling. O speaking of that, thank you that reminds me. When doing BUILD-INDEX is it really necessary to

Re: UV to Text Conversion Standard?

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 6:14:32 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Perhaps we should all capitulate start to use flat CSV files ? Ross Ferris Stamina Software Visage an Evolution in Software Development Having created a system on a MAC that does use flat CSV files

Re: UV to Text Conversion Standard?

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 4:06:38 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: Another standard is that used by the UNLOAD.FILE.B program and its corresponding bulk loader utility loadfile. Here, a line beginning with other than a TAB character or one of /}, /] or \{ contains a

Re: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 4:16:06 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: A key factor that makes CUI non-portable to GUI is the embedded Input and Print statements in the code. I respectfully disagree that this is key. After all event oriented apps also have input statements

Re: GUI from Mv code Re: Crystal Reports

2004-04-17 Thread FFT2001
In a message dated 4/17/2004 10:21:26 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: AFIK, Visage offers users a GUI in a TOTAL WINDOWS LOOK AND FEEL/BROWSER environment, without having to do a total rewrite, but a rewrite none the less, re-using some portions, perhaps, of existing

Re: UV to Text Conversion Standard?

2004-04-16 Thread FFT2001
In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: You can use the UniVerse ODBC Driver to pull the data from UniVerse to Excel, using correct dictionaries UniVerse will normalise the data and sort out the VM and SVM for you. Jonathan can you give a

Re: Database decoupling (Was: Future of U2)

2004-04-16 Thread FFT2001
In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Without this ability, I see no reason why anyone would commence new application development on the U2 platform. Since you will always require another application server (Websphere, Tomcat, Bea, Jboss,

Re: UV to Text Conversion Standard?

2004-04-16 Thread FFT2001
In a message dated 4/15/2004 6:12:27 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Will - your posting mentioned CONVERT(VM,|, mydata) - my version of UV does not seem to like that. Jim, Excel CAN read comma delimited data. Ask again why the requirement for fixed length? Excel DOES

Re: Jbase handles multivalue on RDBMS

2004-04-16 Thread FFT2001
In a message dated 4/15/2004 9:53:43 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: And for the not so faint of heart, jBASE provides the capability to roll your own driver(s) to transform your MV database definition into the relational database without using the jEDI development kit.

Re: Database decoupling (Was: Future of U2)

2004-04-16 Thread FFT2001
I'm just not seeing a great demand for this sort of thing from the majority 10 to 100 user businesses that typically utilize multi-value products. I mean some of my clients, and myself are only just NOW playing with Triggers and transaction sets. Most application are very business

Re: UV Crash on W2K3

2004-04-16 Thread FFT2001
In a message dated 4/16/2004 3:38:16 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: 1.is this a problem with PROCS - does anyone else run a UniVerse system on NT which relies on PROCS to launch several layers of programs? Sara can you explain this more? Perhaps with an example of

Re: Productivity metrics

2004-04-14 Thread FFT2001
In a message dated 4/14/2004 6:36:10 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: I've worked with the function point methods for some time and I don't think MV BASIC has been mapped. You could check with Dave Garmus, who is a central figure in FP (Google him, he comes up near the

Re: UV to Text Conversion Standard?

2004-04-14 Thread FFT2001
Jim the short answer is you can't. You can however strip all non printable characters by passing the data through OCONV(mydata, MCP) This turns all non printables into the period character . To seperate your fields, pass the data through a conversion like CONVERT(VM,|, mydata) which will turns

Re: UV to Text Conversion Standard?

2004-04-14 Thread FFT2001
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,

Re: Performance

2004-04-09 Thread FFT2001
In a message dated 4/8/2004 12:20:45 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: 1.) Application files have all been analyzed and sized correctly. 2.) IBM U2 support analyzed Universe files, locking, swap space and all have been adjusted accordingly or were 'ok'. 3.) We are

Re: Objectcall headache...

2004-04-09 Thread FFT2001
In a message dated 4/8/2004 8:01:13 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: We have a DataStage job which is still relying on ObjectCall (until we can rewrite it to utilise the new UniData6 stage), unfortunately, after the UniData upgrade ObjectCall ceased to function no matter

Re: BETWEEN in a CASE structure

2004-04-08 Thread FFT2001
In a message dated 4/8/2004 8:58:16 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Case VALL#3 = 600 I don't want to start a flame war but, to me, this falls in the category of unnecessarily complicated programming tricks. I'd kill one of my programmers who did that. Testing the

Re: BETWEEN in a CASE structure

2004-04-08 Thread FFT2001
In a message dated 4/8/2004 12:10:33 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: And yet it is between 6000 6999. 6555.555 is another example. (There might be even more examples, but I haven't checked!) The context is integer. -- u2-users mailing list [EMAIL PROTECTED]

Re: Pro-4

2004-04-07 Thread FFT2001
In a message dated 4/7/2004 6:53:52 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: I'm looking for someone who maybe be able to assist with support of a customer using PRO-4 (ex McDonald Douglas ALL) I think. Support will be required in Sydney, Australia. My first job was on a

Re: Modern Universe (TESTING)

2004-04-05 Thread FFT2001
In a message dated 4/4/2004 11:28:33 PM Eastern Standard Time, [EMAIL PROTECTED] writes: The other day.. i was inspecting a UV File with a UV Developer, he ran a COUNT FILENAME on our Customer Master... (BTW Quad CPU 4GHZ)... It took 12-15 Minutes to get a result back from UV. The file only

Re: Modern Universe (TESTING)

2004-04-05 Thread FFT2001
In a message dated 4/4/2004 11:30:24 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Personally I would be surprised if either database had a way of handling leading wildcards other than an exhaustive scan. Use Contains/English Query. See MS-SQL Server Docs. Joe Eugene Joe you

Re: Modern Universe (TESTING)

2004-04-04 Thread FFT2001
In a message dated 4/4/2004 9:11:10 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: One thing I think everyone's missed (deliberately or otherwise) wildcard (WHERE address LIKE '%EXPLORATION'). I brought this up a couple of times, nobody seemed to be interested to check the

Humour: was Re: Conversions

2004-04-03 Thread FFT2001
In a message dated 4/2/2004 10:06:39 PM Pacific Standard Time, [EMAIL PROTECTED] writes: Tony, Stupid question... If you and I built a company which was strictly Hey my name's not Tony but if there's money involved you can call me anything you want. Will -- u2-users mailing list

Re: XML or WORD Format???

2004-04-02 Thread FFT2001
In a message dated 4/1/2004 5:40:16 PM Pacific Standard Time, [EMAIL PROTECTED] writes: The resulting documents can be re-purposed with a variety of applications, including word processors and screen reader software. Is re-purposed the same as read because if it is I prefer read Will

Re: How to launch remote browser from UniVerse server?

2004-04-02 Thread FFT2001
In a message dated 4/2/2004 5:27:20 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. Bruce the Help on QVT might indicate the ability to run scripts, launch windows, etc so that's where to start. However, there are two

Re: How to launch remote browser from UniVerse server?

2004-04-02 Thread FFT2001
In a message dated 4/2/2004 5:27:20 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. Bruce the Help on QVT might indicate the ability to run scripts, launch windows, etc so that's where to start. However, there are two

Re: How to launch remote browser from UniVerse server?

2004-04-02 Thread FFT2001
In a message dated 4/2/2004 5:52:10 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I've created the html file from a spooled hold file and placed it in a Samba drive, but the icing on the cake would for the user to generate the file and launch the browser from within the unidata session.

Re: Modern Universe - was: The lists are closing

2004-03-30 Thread FFT2001
In a message dated 3/30/2004 12:35:32 AM Eastern Standard Time, [EMAIL PROTECTED] writes: You are partly correct when you say UV treats all data as strings. However, if the UV programmer is careful he/she can get it to do maths processing. Variables within UVBasic are string unless the result

Re: The lists are closing

2004-03-30 Thread FFT2001
In a message dated 3/30/2004 5:18:37 AM Eastern Standard Time, [EMAIL PROTECTED] writes: Listen, Will the blind, deaf and possibly dumb Johnson Are you hearing nothing? Please don't start insulting me you ignorant fat slob. Will -- u2-users mailing list [EMAIL PROTECTED]

Re: The lists are closing

2004-03-30 Thread FFT2001
In a message dated 3/30/2004 11:02:13 AM Eastern Standard Time, [EMAIL PROTECTED] writes: 6. The U2UG web site has U2 fora as the means of communication, something which people have been asking for for a long time. The decision to start the fora was made when the lists were also available so

Re: U2UG Contract

2004-03-30 Thread FFT2001
In a message dated 3/30/2004 11:24:36 AM Eastern Standard Time, [EMAIL PROTECTED] writes: There have been *zero* discussions as to what our TOS should be other than to make sure that we indemnify U2UG from copywrite issues. If you are concerned about the wording of any part of the TOS

Re: Modern Universe - was: The lists are closing

2004-03-30 Thread FFT2001
In a message dated 3/30/2004 7:34:27 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Trevor, I *think* the issue is that the mv runtime does typecast variables on the fly, transparently. Which means that assigning a number or the result of a numeric expression (AVAR = 1 * 3) results

Re: Data typing in MV Basic

2004-03-30 Thread FFT2001
In a message dated 3/30/2004 8:19:18 PM Pacific Standard Time, [EMAIL PROTECTED] writes: A = 1 assigns a numeric integer. The expression need not contain operators (+,-,etc) to be numeric. A = 1 assigns a string however, as you have explicitly declared it to be string. A = 1 + 2 assigns a

Re: The lists are closing

2004-03-29 Thread FFT2001
1) We DO want to leave the archives at indexinfocus. 2) We DONT want to replicate the archives onto u2ug 3) We DONT want the lists to continue Go to the web site, and enter each forum you are interested in and click on SUBSCRIBE this will make all responses come to your email box just as they do

Re: Modern Universe - was: The lists are closing

2004-03-29 Thread FFT2001
In a message dated 3/29/2004 11:07:24 AM Eastern Standard Time, [EMAIL PROTECTED] writes: 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

Re: Modern Universe - was: The lists are closing

2004-03-29 Thread FFT2001
In a message dated 3/29/2004 11:27:02 AM Eastern Standard Time, [EMAIL PROTECTED] writes: e.g. We pull XML Reports from our Vendors Real Time. I have to parse through the XML and give UV/PICK Guys a FLAT TEXT File... cause either UV Cannot handle the storage and Retrival of XML Data Using

Re: What are embedded databases

2004-03-29 Thread FFT2001
In a message dated 3/29/2004 11:55:51 AM Eastern Standard Time, [EMAIL PROTECTED] writes: embedded data base support The other day, someone asked me if I used an embedded database. And I was like ... what? Can someone give ten words or less of what an embedded database is? And then

[OT] Joe Eugene was Re: Modern Universe - was: The lists are closing

2004-03-29 Thread FFT2001
Please Speak LOUDER!!! *throws you a raw steak* Will raw steak Johnson In a message dated 3/29/2004 12:26:29 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Going MainStream and staying with BIG THREE is Better for the future of the Company's Needs. BIG THREE has A LOT OF INVESTMENT in

Re: COMMON Variable.

2004-03-29 Thread FFT2001
In a message dated 3/29/2004 1:11:11 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Is there a way to pass some common variable to a Phantom program - which will be called using EXECUTE 'PHANTOM '. I've even tried named COMMON and it lost its value. Yes Carolina. There are a

Re: Question for Donald Kibbey

2004-03-29 Thread FFT2001
In a message dated 3/29/2004 2:28:38 PM Eastern Standard Time, [EMAIL PROTECTED] writes: George, the best commercial integration option available for MV right now is the Pick Data Provider .NET from Raining Data. But doesn't .NET take up like a gazillion bytes of space? And doesn't

Re: Question for Donald Kibbey

2004-03-29 Thread FFT2001
MvBase? I think he was saying best provider for MV not for MvBase Right? And I didn't say it, he did. Will the real Will not the fake posing Will's Johnson In a message dated 3/29/2004 3:09:59 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Will, Unless something has changed since

Re: Question for Donald Kibbey

2004-03-29 Thread FFT2001
In a message dated 3/29/2004 3:15:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: I don't really know what you are after with the integration requiring an object. Can you be more specific? Regards, Jim Yes. Integrate as a verb I think applies to mathematics. But if I say My

Re: VB / SQL questions

2004-03-26 Thread FFT2001
OK thanks for the heads up on using SQL INSERT and UPDATE instead of ADO Recordsets and also using the Prepared property. That made my program run about 7 times faster. Can someone tell me why I need INSERT INTO test([field1], field2 instead of INSERT INTO test(field1, field2 in

[OT] Airplane flights and stuff was Re: Optimisation ?

2004-03-26 Thread FFT2001
The Russians flew an aircraft in 1857! No no the Japanese had one flying in 1831! So? The Chinese flew one in 731 In a message dated 3/26/2004 9:10:14 AM Eastern Standard Time, [EMAIL PROTECTED] writes: I knew this!!! I believe there was also a New Zealander, Richard Pearce, who is eye

Re: [UV] Memory resident hash tables/files

2004-03-23 Thread FFT2001
In a message dated 3/23/2004 2:05:41 AM Eastern Standard Time, [EMAIL PROTECTED] writes: I would like to store records from small static parameter files that are accessed frequently in a memory resident hash table in the common area. What would it take to achieve this in UV BASIC? What

Re: Setting up SQL step 1

2004-03-18 Thread FFT2001
In a message dated 3/18/2004 3:26:32 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Sent: 17 March 2004 19:40 To: U2 Users Discussion List Subject: Re: Setting up SQL step 1 Good news (I think) From what I learned - the admin user is set up when you load the operating system . I

Re: Setting up SQL step 1

2004-03-17 Thread FFT2001
Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I

Re: Help Needed regarding performance improvement of delete query

2004-03-16 Thread FFT2001
In a message dated 3/15/2004 9:54:01 AM Eastern Standard Time, [EMAIL PROTECTED] writes: 10 READNEXT ID ELSE STOP READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10 IF DTE GT DEL.DATE THEN GOTO 10 DELETE F.MASTER, ID DELETE F.REFERENCE, ID GOTO 10 I count three goto's So three

Re: Help Needed regarding performance improvement of delete query

2004-03-16 Thread FFT2001
Gives Mark the most improved player award. Will In a message dated 3/16/2004 5:07:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: LOOP WHILE READNEXT ID DO READV DTE FROM F.MASTER, ID, 5 THEN IF DTE LE DEL.DATE THEN DELETE F.MASTER, ID DELETE

Re: Looking for associated multi-value algorithm...

2004-03-16 Thread FFT2001
It looks like you are using SPECIAL and STARTPOS as paired dummy buffers to walk across the SPECIAL.PARTS, each iteration only searching the remainder from where you left off. That's a little counter-intuitive :) Maybe better nomenclature would make that more apparent. Like Startpos and

Re: Setting up SQL step 1

2004-03-12 Thread FFT2001
I have a client who has never used SQL on their system and I'd like to set it up. It is a Universe 10.0 on Windows setup. When I look at UV_Users I see two users one is NT Authority/System and the other is OSP/administrator My first question is: Is there really a windows login called System ?

Re: Mvquery Client Not Responding

2004-03-12 Thread FFT2001
In a message dated 3/11/2004 8:12:17 AM Pacific Standard Time, [EMAIL PROTECTED] writes: 1. Please do not post mvQuery questions to this list. Either send them to your mvQuery supplier, or to mvquery support. I'm going to buy mvQuery just so I can post twelve questions a day on it to this

Re: UniVerse 10 :Network writes not allowed within a transacton.

2004-03-07 Thread FFT2001
In a message dated 3/6/2004 10:54:23 PM Pacific Standard Time, [EMAIL PROTECTED] writes: As far as I know, the u2 databases and some other Pick-like databases do support some TPM connectivity, but are currently lacking the full functionality required for the phases of 2pc. That's not

Re: Brower based terminal emulator

2004-03-06 Thread FFT2001
In a message dated 3/5/2004 5:58:24 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Fire up an xterm, or konsole, or whatever you fancy, on the client desktop. Telnet into the uv server, SET.TERM.TYPE VT100, and off you go. And you're confident that any old xterm, konsole, or whatever

Re: VB primer help ?

2004-03-04 Thread FFT2001
In a universe database I have a file Customers. In an Access database I have some of the fields of that same file as well, populated from the source universe file via a flat file transport and import. Now however I need to just update those rows that have changed. So in Universe I already have a

Re: [UV] Ever wondered how something works...

2004-03-03 Thread FFT2001
In a message dated 3/3/2004 10:03:01 PM Pacific Standard Time, [EMAIL PROTECTED] writes: Even quicker, who [Enter] Regards T. Are you sure? I think on native pick systems you can use any command. However on Universe you have to use a command that actually uses up a select list. Since

Re: Pick AP-Pro Discs

2004-02-29 Thread FFT2001
In a message dated 2/29/2004 7:42:56 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I would like to acquire or purchase the complete box, manual and all diskettes for an older Pick AP-Pro system or someone's retired AP-Pro system (133-166 P1 preferably). I only need 3-5 users. I think

Re: Printing to local printer

2004-02-27 Thread FFT2001
In a message dated 2/26/2004 12:07:35 PM Pacific Standard Time, [EMAIL PROTECTED] writes: We use AUX ON / AUX OFF for local printers already. The problem is, we want to be able to specify which local printer to use as the AUX. So, when the user is printing a CC receipt, it would print to the

Re: WinteGrate

2004-02-21 Thread FFT2001
In a message dated 2/21/2004 10:23:37 AM Pacific Standard Time, [EMAIL PROTECTED] writes: A simpler way would be: PCFILE=C:\FOLDER\PICTURE.JPEG CALL WIN.PCRUN(IEXPLORE, PCFILE) It opens up a new window with the aforementioned picture. Of course you assume the system has such a command

Re: Swap array values? In UV

2004-02-16 Thread FFT2001
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

Re: Hashing Algorithm

2004-02-14 Thread FFT2001
In a message dated 2/13/2004 6:18:30 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I have the algorithms (from a legal source long before IBM acquired the product) but because they are now secret I cannot divulge the details. They are, however, extremely simple except for the dynamic

Re: The result of VARIABLE[1,3] + 0

2004-02-06 Thread FFT2001
In a message dated 2/2/2004 9:06:43 AM Eastern Standard Time, [EMAIL PROTECTED] writes: It's been affirmed here and other places that MV considers everything as a text variable (keep file handles and arrays out of this discussion) and its numerological properties come into play only when

Re: Proc or Para

2004-02-06 Thread FFT2001
In a message dated 2/4/2004 11:40:41 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Earlier PQ proc didn't have read/write so they developed a sideline language called BATCH which did these tasks. BATCH is officially removed from the direct decendancy of R80/83 as D3 doesn't recognize it

Re: The result of VARIABLE[1,3] + 0

2004-02-06 Thread FFT2001
There is a numeric type or datum as some people call it. Since we are talking MV here and not specifically one vendor. If you look at the opcode of an ADDS machine there is a code for LOADS (string) and also a seperate one for LOADN (numeric). This implies that there are in fact two seperate