RE: [U2] [u2][ud] Poor select performance

My pet peeve with Universe Indexes is in selecting multiple values of an indexed field The following select might take 10 minutes SELECT CONTRACT WITH I_CONTRACT = "50178227" "50092158" "50006089" "50178228" "50092159" "50006090" "50178229" "50092160" "50006091" "50178230" Whereas SELECT CONTRA

RE: [U2] Justification for removal of savedlists

I personally purge my saved-lists periodically and do not rely on saved-lists for permanent storage. For permanent storage I've created a program that saves the records from a select to a hashed file as one item with the file, date & time saved as well as a comment as to the reason that I'm savin

RE: [U2] CSVs' (Different Question)

Try this, LINE=LOCAL LINE<2>="=":QUOTE(REP.ID) CONVERT @AM TO ',' IN LINE Subject: Exporting leading zero fields in csv. I have been exporting from MV to CSV for years and one of my pet peeves is that leading zero fields, like customer numbers, product codes and zip codes lose their leading ze

RE: [U2] Creating Multiple page RTF documents

I did something similar a few years and just created the source documents in Word with embedded tokens to be replaced dynamically by information from the database. The documents were then saved in .rtf format. Thus page soft breaks were handled by Word and, as I recall, Word would automaticall

RE: [U2] Pro's/cons of keeping UV maint/support contract current (paid)

I've used QM at a 6-user site for 2 years. The site was converted from R83. I found few problems in converting, and these may all be gone as it now supports A & S dictionaries and other things that I had to change. It has options to make locates, wildcards & the like flavor specific. I've been v

RE: [U2] [UV] Distributed SELECTs for distributed (Type30) files

I colleague wrote and used the following code to select from a specific distributed file, the GL.DETAIL file. He loved it, but the system administrator has forbidden him from using it because it's such a resources hog. You might find it helpful Mel Maresh CRT CRT "Enter GL.DETAI

RE: [U2] [UV] RAID debugger

lto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: Wednesday, February 02, 2005 10:19 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] RAID debugger What version of Universe allows this? Brenda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Maresh,

RE: [U2] [UV] RAID debugger

Talking of debuggers, is everyone aware that RAID will now display the values of individual elements in a dynamic array :: D.CHART<10>/ STRING: T r L=114 `34321035593806859869452618551232605421692343520675401124 5611372190936940279115843867302197542611598000' :: D.CHART<10,1>/ STRING

RE: [U2] Universe ODBC

how about something like this YEAR = FIELD(PERIOD,'-',1) MONTH = FIELD(PERIOD,'-',2) IF YEAR GE 30 THEN YEAR = '19':YEAR ELSE YEAR = '20':YEAR MONTH += 1 ; IF MONTH = 13 THEN MONTH = 1 ; YEAR +=1 DATE = ICONV((MONTH:".1.":YEAR),'D') - 1 PERIOD = DATE'DY4':',':DATE'DM':',':DATE'DD' -Original

RE: [U2] [UV] Random number (RND()) help

I ran your code on UV 10.1 on AIX and the highest number generated was 370558 I don't think it's your code Mel UV 9.6.1.3 on NT. I needed to generate some random numbers between 0 and 370570, and just to check the distribution of numbers, I ran this snippet of code: FOR I = 1 TO 99 THIS.N

RE: [U2] telnet problem

I can quickly give you a few pointers. An IP of 192.168.1xxx means that the machine is connected to a router. You have to connect the static IP assigned by your internet service provider or, or if you have a dynamic IP, get a name from a company like TZO. Then your router will need to be pr

[U2] [UV] Triggers

We have recently upgraded to v10.1 and are reconsidering the use of triggers after encountering significant issues with triggers with v9.4. After successfully testing them in our development environment, we encountered random write failures in production. Has anyone experience with triggers at b