Re: Data typing in MV Basic

2004-04-01 Thread Simon Lewington
Anthony Youngman... 'A = 1' and 'A = 1' both result in IDENTICAL p-code. This is certainly how the UD compiler works. I say its a bug, because 'A=1.1' and 'A=1,1' *don't* result in the same p-code - and it doesn't just differ by the comma - one is stored as a string the other as a number.

RE: Data typing in MV Basic

2004-04-01 Thread Anthony Youngman
And seeing as I'm playing around with a p-code compiler ... It's very simple for the compiler to do it that way. All the compiler cares about is is it a string or literal?. And if it's a literal, it processes it as unquoted ascii text. So, as far as I'm concerned, as it comes from the lexer into

IOPS Per Unidata user

2004-04-01 Thread Martin Thorpe
Hi guys Hope everybody is well. Very simple question, does anybody have any ideas as to an average IOPS count per user in Unidata 6.0.9 running on the Sparc version of Solaris 5.9? Thanks Martin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: Fora posts

2004-04-01 Thread Dennis Bartlett
In fact, knowing who wrote the message would help greatly too (as I always make a point of reading the posts from the greats...Glenn Herbert, Ray Wurlod, Leroy Dreyfuss...etc, and avoid those written by contentious souls, eg Joe...) Knowing a post comes from [EMAIL PROTECTED] really does nothing

Consult about SQL

2004-04-01 Thread Cesar Riba
Hello, I'm a problem when use a SQL query that have one or various INNER JOIN this is very very slow. How I can accelerate this tipus of query. Thanks. César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: Volunteer Board

2004-04-01 Thread djordan
Hi Ross Australia and the UK is represented on the board as well as the USA Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Thursday, 1 April 2004 10:38 AM To: U2 Users Discussion List Subject: RE: Volunteer

Question re SB+

2004-04-01 Thread Muhammad Shoaib Patel
Hi, I would like to ask a question regarding SB+ or SystemBuilder Plus. Can I use SB+ in Windows 2000 which I am already running on SCO UNIX system. I mean that can I simply copied the SB+, SB+.DEFN and SBDEMO directories from UNIX to Windows 2000 and use it. Is there any other thing I need

RE: Question re SB+

2004-04-01 Thread Eric Limbeek
Shaoib, I do not believe that that object code is compatible between these platforms. You're going to have to get SB+ versions for Windows from IBM. If you're on maintenance, there may not be a charge. Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of

XML or WORD Format???

2004-04-01 Thread Haas, John
Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS

Re: How to launch remote browser from UniVerse server?

2004-04-01 Thread Mark Johnson
I believe WIN.PCRUN requires 2 parameters. Please provide the other. Thanks. You could provide your desired browser in the first parameter and the URL in the second. Just because a small fraction doesn't use IEXPLORE doesn't mean that 99.9 percent don't either. Everyone can figure this out for

RE: XML or WORD Format???

2004-04-01 Thread Anthony Youngman
In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if

RE: XML or WORD Format???

2004-04-01 Thread Haas, John
Thanks, The goal is to have a copy of our invoice that can be opened in WORD or Excel. I only mentioned the PCL and .pdf formats because these are already produced when we create an invoice. If there is another way please let me know. We are running Universe version 9.6. John.

RE: How to launch remote browser from UniVerse server?

2004-04-01 Thread Anthony Youngman
If WIN.PCRUN requires 2 parameters, then I guess the second parameter should be null. And which way of doing things is best? To throw up the url in the USER's choice of browser, or the PROGRAMMER's choice of browser? I'm afraid I come from the old school - give the user what they want, if it's

RE: XML or WORD Format???

2004-04-01 Thread Anthony Youngman
Ah ... This looks good. Are your invoices prettied up in any way, or are they just courier on preprinted paper? If the latter, any nix programmer worth his salt ought to be able to faff about with awk, sed or similar to strip out escape sequences, make sure the right characters are used for line

RE: XML or WORD Format???

2004-04-01 Thread Donald Kibbey
Are you running LMS from TMC?? If so, then I have a solution that will do what your after. I use a couple of perl scripts and a Word macro to allow our billing staff to get a text version of the invoice in Word, mark it up and then re-print it back to the HP-UX machine. The reprint process

RE: XML or WORD Format???

2004-04-01 Thread Haas, John
Unfortunately, the invoices themselves have the graphics embedded. However, I can capture just the text without loosing the structure. John. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:54 AM To: U2 Users Discussion List Subject:

RE: XML or WORD Format???

2004-04-01 Thread Haas, John
Don, We are using LMS from TMC. John. -Original Message- From: Donald Kibbey [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 8:56 AM To: [EMAIL PROTECTED] Subject: RE: XML or WORD Format??? Are you running LMS from TMC?? If so, then I have a solution that will do what your

RE: XML or WORD Format???

2004-04-01 Thread Anthony Youngman
If that's the case, then play with the files and see what happens. Actually, another thing I've just thought of. Try opening the pdf in Acrobat, then do a cut-n-paste into Word. That might (or might not) achieve what you're after. Cheers, Wol -Original Message- From: [EMAIL PROTECTED]

RE: XML or WORD Format???

2004-04-01 Thread Donald Kibbey
LMS only knows raw, plain text. That's all it's putting out. Have a look at /usr/spool/uv/drv. There's probably a couple of fancy scripts in there that are installing the image for you. If not, give me a holler offline and I can point you to the subroutine that puts out the invoice. Don

RE: How to launch remote browser from UniVerse server?

2004-04-01 Thread Michael Polak
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It depends on what you use for a terminal emulator. For Accuterm you need to place something like the following in a Basic program to open IE: PRINT CHAR(27):CHAR(2)::iexplore:CHAR(13): There are numerous ways to get reports to display in the

RE: XML or WORD Format???

2004-04-01 Thread Haas, John
Don, Although we have LMS, it has been extremely customized over the years. The line draws are part of the print program using a different character set. So you are correct that the output is just text. The graphics I am referring to are the lines and the company logo that is also just a

RE: [OT] America Has First Flight (?)

2004-04-01 Thread Lettau, Jeff
And also don't forget that we have total freedom of speech and there is no propaganda in the media like other countries. Freedom comes at a price, and the more money you have the freer you are. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED]

RE: [OT] America Has First Flight (?)

2004-04-01 Thread George Gallen
no propaganda in the media.WOW what an understatement. our media has more propaganda than I'd like. How many times have the news only reported one side of a story? or left out a lot of important facts? - That's propaganda. However, at least we have access to multiple views of propagranda

RE: dhl shipping software integration

2004-04-01 Thread George Gallen
no right now Fedex is not our primary non-postal shipper. Depending on who we get our best deal from. In the past when we used DHL, we would just type in the info. They DHL are supposed to let us know our options for connection, but so far, have not had any meetings with the tech. Just checking

RE: [OT] America Has First Flight (?)

2004-04-01 Thread Barry Rogen
Can we turn off this road now, before this thread explodes into another endless geopolitical debate. I think we have had enough of those within this venue. Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The

RE: Volunteer Board

2004-04-01 Thread Don Verhagen
ye vote shall determine the makeup during the board elections Don Verhagen Tandem Staffing Solutions, Inc. Obviously American [EMAIL PROTECTED] 7:37:32 PM 03/31/2004 That said, I think that it would be nice to have some representation from each 'major' country where U2 is used ... UK is

RE: DATA statement Clearing?

2004-04-01 Thread Larry Hiscock
Not sure about UniVerse, but UniData has a CLEARDATA verb. Rather than stuffing the data buffer with all this stuff, wouldn't it be just as easy to open the file from within a program and read/process it? Larry Hiscock Western Computer Services -Original Message- From: [EMAIL

Re: Consult about SQL

2004-04-01 Thread Horacio Pellegrino
You might try creating indexes or using the EXPLAIN clause to see if they are being used. --- Cesar Riba [EMAIL PROTECTED] escribió: Hello, I'm a problem when use a SQL query that have one or various INNER JOIN this is very very slow. How I can accelerate this tipus of query.

Re: DATA statement Clearing?

2004-04-01 Thread Karl L Pearson
The theory is that our database (old version of ACCESS) will get on the client systems and clean up the data, thus making the different uses of this step unnecessary. Good old data consistency would be nice. Karl On Thu, 2004-04-01 at 10:50, Eugene Perry wrote: One thing you could do would be

UniOLEDB setup

2004-04-01 Thread Kebbon
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, I presume). They are using a database

RE: UniOLEDB setup

2004-04-01 Thread Nick Southwell
Try removing the Provider element, Its either VB6 or VB.Net that doesn't like it from our experience. Cheers Nick -Original Message- From: Kebbon [mailto:[EMAIL PROTECTED] Sent: 01 April 2004 20:05 To: Info-Ardent List Subject: UniOLEDB setup Other consultants who have previously been

RE: XML or WORD Format???

2004-04-01 Thread Tony Gravagno
It seems the problem here is that you're going from pure data to StructureX, then you want to go from StructureX to StructureY. Going direct to StructureX is a fine first-off approach, but since your needs are now expanding I'd suggest that you need to rethink your approach. You need to go

Running total

2004-04-01 Thread Shrestha, Prabhash
Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111 1 Joe Jones 112 2 Sue

RE: Running total

2004-04-01 Thread Garth Joubert
Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is

TOXML question

2004-04-01 Thread James Canale, Jr.
I am currently using '...TOXML ELEMENTS' and wonder if there is a way to suppress the .../... tags when there is no data in a multi-valued field. If this is possible, will it also remove the '...ASSOC-MV/...ASSOC-MV tags that surround the empty multi-valued fields? Thanks. Regards, Jim --

Re: XML or WORD Format???

2004-04-01 Thread Craig Bennett
John, The goal is to have a copy of our invoice that can be opened in WORD or Excel. try generating RTF or generate XML in Word 2003 format. Craig -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: Running total

2004-04-01 Thread Roger Glenfield
Pick flavor possibility. In your VOC. create item named CNTR 1=A 2=9998 9=R 10=8 (or whatever you think your maximum would be. SORT CUST CNTR CUST.NAME By putting it in your VOC, it's available for all files. Roger -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: How to launch remote browser from UniVerse server?

2004-04-01 Thread LeRoi Keiller
The client uses Attachmate Extra. But I'm thinking perhaps they need a mini-app or service sitting on each PC that responds to instructions over the network. It's possibly time for a shareware search - although how that'd work with a unix/universe server, I'm not too sure. :o) -Original

RE: PDF Manual [Data typing in MV Basic]

2004-04-01 Thread Stuart Boydell
cOOL. Saves having to manually delete nasty unwanted plugins from the plugins folder ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Colquhoun If you use the above don't forget to install Acrobat reader speedup from:

RE: XML or WORD Format???

2004-04-01 Thread Ross Ferris
Alternatively, if you had a Win2K Pro or better machine on the network, you could consider our WordLynx product to produce your invoices natively into Word format (the WordLynx server component runs as a service on NT style platforms, so the machine can be used for other tasks - and green

RE: PDF Manual [Data typing in MV Basic]

2004-04-01 Thread Stuart Boydell
... except that on first inspection it stops the indexes from working. I normally just move the following plugins out of the plugins directory and Reader goes much faster... Accessibility.api AcroForm.api AcroSign.prc DigSig.api eBook.api MakeAccessible.api -Original Message- From:

RE: PDF Manual [Data typing in MV Basic]

2004-04-01 Thread Stuart Boydell
oops - hit send too soon... ... except that on first inspection the Speed Up stops the (UV docs) indexes from working. This may be an index version thing but I normally just move the following plugins out of the plugins directory and Reader goes much faster... C:\Program Files\Adobe\Acrobat

RE: XML or WORD Format???

2004-04-01 Thread Stuart Boydell
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman In one word - it's IMPOSSIBLE. The beta version of the Save As XML plug-in, a free download for Acrobat 5.0 (http://www.adobe.com/support/downloads/89a2.htm for Windows and

(no subject)

2004-04-01 Thread Steve Mayo
Greetings one and all, I am trying to put together a demo application using UniObject for Java. I would like to be able to create a statement that selects names that start with SMI. In Unibasic I would use the following statement: SELECT UBFMSTR WITH LAST.NAME = SMI] The Java statement I used

Re: Running total

2004-04-01 Thread John Kent
Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST

RE: XML or WORD Format???

2004-04-01 Thread Robert Colquhoun
At 10:47 AM 2/04/2004, Robert Colquhoun wrote: Hello, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. I might be completely

RE: PDF Manual [Data typing in MV Basic]

2004-04-01 Thread Robert Colquhoun
At 11:28 AM 2/04/2004, Stuart Boydell wrote: oops - hit send too soon... ... except that on first inspection the Speed Up stops the (UV docs) indexes from working. This may be an index version thing but I normally just move the following plugins out of the plugins directory and Reader goes much

RE: Running total

2004-04-01 Thread Garth Joubert
Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent

Unclassified RE: (no subject)

2004-04-01 Thread HENDERSON MICHAEL MR
Steve, Is the U2 database UD or UV? This might be a 'flavour' issue, if it's UD try substituting sELECT for SELECT. if it's UV try WITH LAST NAME LIKE SMI... or WITH LAST NAME LIKE \SMI...\ HTH Mike -Original Message- From: [EMAIL PROTECTED]

Re: Running total

2004-04-01 Thread Allen Egerton
On Thu, 1 Apr 2004 17:08:02 -0500, you wrote: Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111

Re: Running total

2004-04-01 Thread John Kent
Garth Thanks, but i was after something like an itemised list for each mv entry such as Field mv1 1 mv2 2 mv3 3 Field mv1 1 mv2 2 etc ive only ever been able to do it as a pick style dict item or as a subr jak - Original Message - From:

RE: Running total

2004-04-01 Thread Mitchell, Stewart
Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:59 To: U2 Users Discussion List Subject: Re: Running total Garth Thanks, but i was after something like an itemised list for each mv entry such as

Re: Running total

2004-04-01 Thread John Kent
Stewart try this, works for me in universe information flavour and on R83 1 D 2 15 3 MV name 7 A;NV 9R 105 from ye olde pick pocket guide version IV NV returns the number of the mulit-value being processed hows life at fauldings ? jak - Original Message -

Re: Running total

2004-04-01 Thread John Kent
Stewart, tried that and all i get is the entry of 1 beside each multivalue instead of incrementing mv numbers. I am wondering if this is a information flavour thing. Tried it in HS.SALES and its the same problem The EVAL works though but its still the pick solution jak - Original

Re: Running total

2004-04-01 Thread John Kent
Stewart, thanks, i agree with the D version but do not get the I type to work as you suggest can you confirm LIST CUSTOMER SMM.CNT SMM.ICNT displays the same data? I would really like the itype work so i can reuse a static field to get an incrementing date against each mv jak -

RE: Running total

2004-04-01 Thread Mitchell, Stewart
John, Try this for your itype SMM.CNT 0001 I 0002 @RECORD11 0003 A;NV 0004 Count 0005 3R 0006 M Stewart -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 15:14 To: U2 Users Discussion List Subject:

Re: Running total

2004-04-01 Thread John Kent
Stewart, that will do nicely I can go home now jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 3:19 PM Subject: RE: Running total John, Try this for your itype SMM.CNT 0001 I