RE: [U2] UV 10.1.2 bug

2005-01-18 Thread Brian Leach
Sounds like the kind of thing that would happen if the file had a lot of overflow. Or a very badly designed index, or trigger. Any of those possible? Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, January

RE: [U2] [UV] xml and socket functions

2005-01-18 Thread Brian Leach
They are in the UniVerse Basic Extensions manual in the online PDF documentation. Blink and you'll miss it. IBM have been a lot better at adding new facilities to UniVerse than they have been at telling anybody they are there. Brian -Original Message- From: [EMAIL PROTECTED]

Re: [U2] How to exit out mulitple loops?

2005-01-18 Thread CWNoah2
Ken, Except that in real life Q, T and X would be variable names which mean something in the context of the program. ;^) Regards, Charlie Noah [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) writes: Clifton Oliver wrote In that case, a determinate structure like FOR-NEXT is

RE: [U2] Report Printer

2005-01-18 Thread George Gallen
Laser or impact? How much usage? We have had fairly good success with the not too bottom of the line HP printers (ie. hp4050). PCL was fairly easy to implement. You can always get a fairly inexpensive lpd/lpr generic paralell network adapter to make it a network printer as well. (much cheaper

RE: [U2] Uniobjects automation error

2005-01-18 Thread Richard Taylor
I remember having similar problems and the issue came down to how I referenced the library. Are you doing a 'Reference' or a createobject? I think the solution for me was to do a createobject, but it has been awhile. Another thing to keep in mind is that when you work in the IDE sometimes

RE: [U2] UV 10.1.2 bug

2005-01-18 Thread karlp
quote who=Brian Leach Sounds like the kind of thing that would happen if the file had a lot of overflow. Or a very badly designed index, or trigger. Any of those possible? Brian We don't have any triggers on those files. There are no indexes on one of the files and the other one has 5

RE: [U2] UOJ DataSet Class

2005-01-18 Thread Wendy Smoak
David Cason wrote: I've just discovered the wonderful world of the UniDataSet class thanks to a post in the archives by Dave Meeks. There's even a snippet of code provided. I'm very interested in learning more about this wonderful class I posted an example that might answer your first

RE: [U2] UV 10.1.2 bug

2005-01-18 Thread karlp
Okay, tested the process against the file with no indexes. It ran in 19 minutes. it was taking hours before. I didn't save a copy of LIST.INDEX FILE ALL DETAIL but it did have some very skewed groups, as I watched it scroll by. But mostly it looked very even... I've never seen this behavior

[U2] Wintegrate SQL query

2005-01-18 Thread k_hw
I am trying to build SQL query using Wintegrate. One of the fields that I select is the location of a product in the warehouse. The SQL query output truncates the location and puts one or two characters in a blank line. How to resolve the column width issue? Thanks Krish --- u2-users

[U2] Determining compile date and time

2005-01-18 Thread Bruce Lunt
Hi All, We would like to determine if any of the programs that were run in a certain timeframe were re-compiled. Does anyone know how (or if) I could see the date and time of the last compile? HPUX 11 UDT 6 TIA, Bruce Lunt --- u2-users mailing list u2-users@listserver.u2ug.org To

Re: [U2] UV 10.1.2 bug

2005-01-18 Thread Clifton Oliver
I've seen this kind of thing when an index of a sparsely populated field was created without the NO.NULLS option. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com

Re: [U2] Determining compile date and time

2005-01-18 Thread Allen Egerton
On Tue, 18 Jan 2005 13:11:15 -0800, you wrote: Hi All, We would like to determine if any of the programs that were run in a certain timeframe were re-compiled. Does anyone know how (or if) I could see the date and time of the last compile? HPUX 11 UDT 6 Unix box, right? So do a ls in the

RE: [U2] Determining compile date and time

2005-01-18 Thread James Canale, Jr.
Take a look at the directory that contains the program you are running and look at the timestamp of _NameOfProgram. HTH. Regards, Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Lunt Sent: Tuesday, January 18, 2005 4:11 PM To:

RE: [U2] Determining compile date and time

2005-01-18 Thread Rod Hills
From unix shell prompt, do ls -l BP.O/PROGRAM. This will display the last modify date of the object program. -- Rod Hills -Original Message- From: Bruce Lunt [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 18, 2005 1:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] Determining

[U2] Edit / Remove a record with no ID

2005-01-18 Thread Simon Adams
Running in UniVerse on Windows. I have a select list of say 140 records from a file, then when I drill down further by say a 'list' or 'sort' on the selected list, I only have 139 records shown. I suspect I have a record with no 'real' ID. How can I select and / or remove this record ? Cheers,

RE: [U2] Determining compile date and time

2005-01-18 Thread Alfke, Colin
Look in the directory where they are compiled. The compiled version of the program begins with an underscore. The time/date stamp on that file is the time/date of the last compile for that program. hth Colin Alfke -Original Message- From: Bruce Lunt Hi All, We would like to

[U2] UniData ODBC / Prompt for selection criteria

2005-01-18 Thread Amy Cook
I know this issue has been reported to IBM (don't know what IBM calls it, but the 'bug' # is 144655). I'm trying to figure out if anyone has a workaround (or if this has been fixed at a later version). When I prompt for selection criteria from a 3rd party client (i.e. Access), the unidata odbc

RE: [U2] Edit / Remove a record with no ID

2005-01-18 Thread Allen E. Elwood
Do a select, copy all the records to a temp file, clear the data in the original file and copy the records back. In one system that I worked with, just editing a null record and deleting it, would end up deleting the entire file. Nice featurenot!!! -Original Message- From: [EMAIL

[U2] UniSession process suddenly not going away!

2005-01-18 Thread Wendy Smoak
Suddenly today we started seeing 'No more LCTs' when we tried to log in. Checking the process list shows LOTS and LOTS of udcs and udapi_slave processes, which I can tell from the userid are coming from my UniObjects for Java code. But I don't hold sessions open. I connect, perhaps run a

RE: [U2] Edit / Remove a record with no ID

2005-01-18 Thread Kevin King
It may be that it actually has an ID, but that ID has a delimiter (a value mark or attribute mark) in it. If it's really no key, can you: SELECT filename '' ED filename ?? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: [U2] Edit / Remove a record with no ID

2005-01-18 Thread Hanley, Iain
Simon, Have you tried to do a SSELECT (Ok, I only know Unidata, but UV is similar), and then Edit that list. Anything that has a NULL ID in the file will float to the top and then just delete that record. Iain. -Original Message- From: Simon Adams [mailto:[EMAIL PROTECTED] Sent:

RE: [U2] UV 10.1.2 bug

2005-01-18 Thread John Jenkins
Karl This sounds like an index overload issue - check NO.NULLS and for overloads. I have seen similar problems with extreme overload on a file with 99%+ of all the records with the same key (and yes - it was NULL). If there is stuff you do NOT want to index and it is not NULL then consider a

RE: [U2] Determining compile date and time

2005-01-18 Thread Bruce Lunt
Thanks, Jim! That gives me just what I needed. Thanks to everyone for the fast response! Regards, Bruce From: James Canale, Jr. [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] Determining compile date and time Date: Tue, 18 Jan 2005

Re: [U2] UniSession process suddenly not going away!

2005-01-18 Thread Scott Richardson
Operating System, and version? Can you run your process list command and redirect it's output to a ps_out.txt file? Then cut paste a few representative lines of these processes? Run a netstat -a ns_out.txt command and take a look at the output from it. Maybe a little cut paste from there?

RE: [U2] UniSession process suddenly not going away!

2005-01-18 Thread Wendy Smoak
Scott Richardson wrote: Operating System, and version? Can you run your process list command and redirect it's output to a ps_out.txt file? Then cut paste a few representative lines of these processes? HP-UX 11 The usual stopunirpcd script wouldn't work-- said that the RPC daemon was

Re[2]: [U2] Edit / Remove a record with no ID

2005-01-18 Thread David Tod Sigafoos
Iain, Tuesday, January 18, 2005, 2:36:41 PM, you wrote: HI Simon, HI Have you tried to do a SSELECT (Ok, I only know Unidata, but UV is similar), HI and then Edit that list. HI Anything that has a NULL ID in the file will float to the top and then just HI delete that record. You might also

RE: Re[2]: [U2] Edit / Remove a record with no ID

2005-01-18 Thread Kieran Clulow
Have you tried SELECT tblname WITHOUT @ID DELETE tblname ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Tod Sigafoos Sent: Wednesday, 19 January 2005 12:19 PM To: u2-users@listserver.u2ug.org Subject: Re[2]: [U2] Edit / Remove a record with

RE: [U2] UV Pre-printed forms

2005-01-18 Thread Larry Kessler
Mark Johnson [EMAIL PROTECTED] posted: :: One of my clients would like to replace their pre-printed forms :: with those generated by the system. Basically the form has been :: re-created in MS Publisher and saved as a PRN file. :: :: I understand that there is some magic to send the form, keep

RE: [U2] UniData ODBC / Prompt for selection criteria

2005-01-18 Thread Alfke, Colin
Do you mean you're trying to do an inline prompt through an ODBC connection? You're a brave soul. I would prompt for imput in the 3rd party client and pass the full string through... hth Colin Alfke -Original Message- From: Amy Cook I know this issue has

RE: [U2] Edit / Remove a record with no ID

2005-01-18 Thread Kurt Neumann
Are you using indices? This sounds like it could be a case of the index needing to be rebuilt, as it is finding 140 records matching your criteria yet there are only 139 on the actual file. HTH Kurt Neumann -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of