RE: [UV] Consult about SQL

2004-04-02 Thread Cesar Riba
Hello, Another question Because a SQL query executed in Universe it take 20 seconds and the same query in MSAccess take 3 seconds. This is the result of EXPLAIN of this query SELECT LINFAC.GRUPART, SUM(LINFAC.BASPP * LINFAC.CAN) As SUMCANT, GCAREPRE.NOMBRE AS

RE: DATA statement Clearing?

2004-04-02 Thread Anthony Youngman
We have programs that make extensive use of data statements. And they regularly screwed up because people asked us to change the prompt sequence (adding new requests or whatever...) So I've been steadily rewriting them all to use arguments on the command line, retrieving it all from @SENTENCE.

RE: PDF Manual [Data typing in MV Basic]

2004-04-02 Thread Anthony Youngman
Acrobat 6, certainly initially, had, well, issues. Something to do with compatibility, and not liking files created by earlier versions. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Sent: 02 April 2004 00:24 To: U2 Users

Re: UniOLEDB setup

2004-04-02 Thread Simon Lewington
Kebbon [EMAIL PROTECTED] wrote... Other consultants who have previously been accessing my Unidata 5.1.3/HP/UX 11.0 data using ODBC are now trying to do it using OLEDB. Everything appears to be set up correctly - that is the UCI Config file (without making any changes from the ODBC setup,

RE: How to launch remote browser from UniVerse server?

2004-04-02 Thread Bruce McAdoo
Does anyone have an example of how to do this if the terminal emulator is QPC Software, QVT/Term? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Polak Sent: Thursday, April 01, 2004 8:17 AM To: U2 Users Discussion List Subject: RE: How to launch

RE: How to launch remote browser from UniVerse server? (In Training...)

2004-04-02 Thread Donald Kibbey
I will be attending a training session in room 2B. If you require assistance, please page me. Thanks, u2-users 04/02/04 09:44 Does anyone have an example of how to do this if the terminal emulator is QPC Software, QVT/Term? -Original Message- From: [EMAIL PROTECTED]

RE: PDF Manual [Data typing in MV Basic]

2004-04-02 Thread Bill H.
Robert: Thanks for the link. I've been tired of Adobe's slowness for years. If you use the above don't forget to install Acrobat reader speedup from: http://www.tnk-bootblock.co.uk/prods/misc/index.php -- u2-users mailing list [EMAIL PROTECTED]

universe 10.???? - array size

2004-04-02 Thread Peter Olson
is there a native function that will tell me the size of a dimensioned array ? if not are there any suggestions for something graceful ? Thanks, Pete Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or

universe 10.???? - array size

2004-04-02 Thread Peter Olson
the array will contain file handles... Thanks, Pete Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction,

RE: universe 10.???? - array size

2004-04-02 Thread Glenn W. Paschal
If you want to know from the debugger... Example: ED BP TEST 4 lines long. : P 0001: DIM X(10,15) 0002: MAT X = 0003: DEBUG 0004: PRINT Bottom at line 4. : Q RUN BP TEST TEST: 4: PRINT :: X/ MATRIX: X=10 Y=15 :: If you are trying to get the size of the array within the program, use

RE: universe 10.???? - array size

2004-04-02 Thread Peter Olson
thanks! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glenn W. Paschal Sent: Friday, April 02, 2004 12:40 PM To: 'U2 Users Discussion List' Subject: RE: universe 10. - array size If you want to know from the debugger... Example: ED BP TEST 4 lines

Re: universe 10.???? - array size

2004-04-02 Thread Mats Carlid
INMAT( ARRAY )returns the current dimensions of ARRAY as a m-v string with @vm as delimiter. HTH -- mats Peter Olson wrote: is there a native function that will tell me the size of a dimensioned array ? if not are there any suggestions for something graceful ? Thanks, Pete Notice of

RE: universe 10.???? - array size

2004-04-02 Thread Grant.Boice
Pete, In UniBasic, there is a function call INMAT. If memory serves me right, I believe UniVerse has the same function. You might want to check it out. Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110

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: Universe Case Sensitivity

2004-04-02 Thread Mike Pflugfelder
This is a bug in Universe 10.1. It's fixed in the 10.1.2 release, which isn't out to the public yet. We've seen it in the Windows and AIX ports, but I don't know if it's in any other ports. If this is a critical issue for you, contact me directly and we can work on getting you a copy of the

RE: [UV] Consult about SQL

2004-04-02 Thread Ray Wurlod
The first thing to notice is that a file scan is being performed on the LINFAC table. This could be speeded with an index on each of the constraining columns LINFAC.EMP and LINFAC.TIPFAC. The inner joins are being performed via hash lookups, the fastest available method. There are 23469

RE: How to launch remote browser from UniVerse server?

2004-04-02 Thread Bruce McAdoo
Using QVT/Term to connect to unidata 5.1.19 running on AIX 4.3.2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:18 PM To: [EMAIL PROTECTED] Subject: Re: How to launch remote browser from UniVerse server?

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 Bruce McAdoo
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. QVT/Term Help does not mention anything about launching windows, and the scripts seem

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: Quick reference guide

2004-04-02 Thread Jan Shaw and Keith Johnson
The Universe pdf files for Basic and User Reference both have an appendix A which are quick references grouped according to their uses. These are pages 1169 to 1204 (36) for basic, and pages 857 to 888 (32) for userref. Also, appendix B in the basic pdf is the good old ASCII code table and

Re: Running Total- @1?

2004-04-02 Thread Allen Egerton
On Fri, 2 Apr 2004 14:54:14 -0800 , you wrote: LIST CUST EVAL @1+1 CUST.NAME Well OK, I'll 'fess up to being clueless... what is @1? Why does this work? (running UV 9.6.1.3). What other @ variables are left out of my docs? The most common use I've found for @1, @2, etc are within very complex

A proposal for extending the MV data structure

2004-04-02 Thread Jan Shaw and Keith Johnson
Since the list will be closing soon, I thought I'd put up for discussion an idea a friend and I had back in 2000. I put it here partly as a thought provoker, and partly so it doesn't get lost. I had it on Microsoft's community groups, but it never got any traffic so died a death. (By the way, my

RE: A proposal for extending the MV data structure

2004-04-02 Thread Dawn M. Wolthuis
Interesting, Keith. By the way, Berkeley DB Java version just went to beta. I have been looking at how to write an application (using a services architecture) in Java where one could plug in either Berkeley DB or U2 and possibly jBASE or other PICK databases so that it would be database

Conversions

2004-04-02 Thread Mark Johnson
Does anyone have a short paper on the care and feeding of both the company and its employees during a conversion/migration from one system to another. I'm facilitating a migration from MV/Results/Primac to Great Plains and it is a very large mismatch. GP seems to be shopping-cart oriented and

Re: Conversions

2004-04-02 Thread Results
Mark, As a Business Process Consultant (one of my hats), here's how I would approach it. 1. You are already moving in the correct direction by pointing up productivity loss, but you have to frame the argument correctly: 1. We have implied and explicit deadlines in serving our

RE: Conversions

2004-04-02 Thread Tony Gravagno
You have my sympathy/empathy, and I'm sure that of many others here. I have some thoughts that may seem common sense, but they may be worth mentioning: Document everything. -- Downtime -- Delays -- End-user complaints -- Discussions with management and software vendors -- Missing features,

Re: Conversions

2004-04-02 Thread Results
Please IGNORE last post. It was meant to be private. I was meant to be asleep. Sincerely, Charles Barouch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: Conversions

2004-04-02 Thread Tony Gravagno
Smooth bro. Real smooth. Excuse us ladies and gentlemen as I escort our colleague out by his ear and smack him around a little. Please IGNORE last post. It was meant to be private. I was meant to be asleep. Sincerely, Charles Barouch -- u2-users mailing list [EMAIL PROTECTED]

Re: Conversions

2004-04-02 Thread Clif Oliver
Post? What post? I don't see no stinkin' post. On Apr 2, 2004, at 10:10 PM, Results wrote: Please IGNORE last post. It was meant to be private. I was meant to be asleep. Sincerely, Charles Barouch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --