I wonder if this problem is flavour dependent. I'm using PI/Open flavour
UV 10.0.19 and ALL fields show up when listing vertically whether they
are blank or not.
DISCLAIMER:
Disclaimer. This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-
Perry:
Can't you do an EVAL in the selection? When I test this on UniData the
blank field _DOES_ show up on a vertical listing. Go figure. :-0
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor
Sent: Tuesday, August 29, 2006 6:03 PM
To:
I think you can still do something similar using an "S-type" dict item
Trick is to put the "IF" in attribute seven, e.g.
1> S
2> attribute
3> ZIP
4>
5>
6>
7> A;IF attribute = "" THEN " " ELSE attribute
8>
9> L
10> 10
Mark
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECT
I went to pull a fresh copy -- and the name on the web site is the same as
the last download I did for PE.
As a *suggestion* -- is there any way the ZIP name could contain something
that would be 'unique' like the Expiration date? (I didn't even know there
WAS an expiration date, so I'm glad someo
The next U2UG newsletter, (available soon) will have articles about release
10.2
Regards
David Jordan
>Hi all,
>
>Does anyone know:
>When is 10.2 due out?
>What is going to be included? for example Web Service provider.
>
>Regards
>
>Phil.
---
u2-users mailing list
u2-users@listserver.u2ug
Ah, good question...as the Beta of U2 Web Service Developer required a
connection pooling license in order to work.
Regards
David
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of phil walker
Sent: Wednesday, August 30, 2006 9:07 AM
To: u2-users@listserv
Hrm... That's a thought. Problem I see is then I would not be able
to...
LIST PTEMP WITH ZIP = ""
Might be doable though as a secondary set of dictionary items
specifically for this purpose.
Thanks for the suggestion.
Perry
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PR
Hi all,
Does anyone know:
When is 10.2 due out?
What is going to be included? for example Web Service provider.
Regards
Phil.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss
Sent: Wednesday, 30 August 2006 11:01 a.m.
To: u2-users@listse
I've seen an error like this on a WIN version of Unidata. It was their
customer file, and I had to move all the records out of it to another file,
delete the original, recreate it and move the records back
Not a clue what it was...but no matter what program tried to write to the CM
file, it d
All,
Because the current UniVerse 10.1.11 (Windows) and 10.1.12 (Linux)
Personal Editions were about to expire (31 August 2006), we have
reloaded them with a new expiration date. The updated copies will
expire on 31 October 2006, and will be replaced by UniVerse
I will need to check in the morning. But I am almost certain that it
does work this way.
Richard Brown <[EMAIL PROTECTED]> wrote:
If you do multiple selects does it work?
SELECT ORDERS WITH CUST.NO = '12345'
xx items selected
SELECT ORDERS WITH INV.DATE = '12/14/05'
Richard
> We have a
Yes. I do recall having a problem with a Unidata release years ago. After
struggling with the release for several months. IBM finally admitted that they
had a major
bug in that release.
[EMAIL PROTECTED] wrote:
We had a problem with the udtsort.exe in 5.2. IBM actually had us use
the udtsort
Anyone here ever get this error ?
The following error appears using AE to try to save a
record:
[AE] UniBasic WRITE failed, STATUS=40019, --
unrecognized STATUS() after WRITEU.
Quit "RECORD" in file "TESTBP" unchanged.
Trying to save the same program with ED gives an error
also but the ST
You could change the fields to an I type and have a formula something like
this:
I
ZIP;IF @1 THEN @1 ELSE ' '
.
.
.
etc
This will put a space into the field so it will print.
Tom Dodds
[EMAIL PROTECTED]
513-563-2800 Cincinnati Office
708-234-9608 Chicago Office
630-235-2975 Anywhere Cell
-O
I will be out of the office starting 08/29/2006 and will not return until
09/06/2006.
I will respond to your message when I return.
If this is in regards to an open Case please call:
800-729-3553 Option 8
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http
I will be out of the office starting 08/29/2006 and will not return until
09/06/2006.
I will respond to your message when I return.
If this is in regards to an open Case please call:
800-729-3553 Option 8
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http
If you do multiple selects does it work?
SELECT ORDERS WITH CUST.NO = '12345'
xx items selected
SELECT ORDERS WITH INV.DATE = '12/14/05'
Richard
> We have a file that has the customer number and invoice date indexed.
>
> When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH
My bad. It was even earlier. It was a problem in 5.1 fixed in 5.1.18.
Maybe make sure your date dictionary is right-justified???
Hth
Colin Alfke
Calgary Canada
-Original Message-
From: Alfke, Colin (Elite Intl)
We had a problem with the udtsort.exe in 5.2. IBM actually had us use
the
I can't seem to find a way to get UniVerse to display fields for which the
record has no data when the listing goes vertically.
Consider this example...
LIST PTEMP "3" "4" CITY STATE ZIP 02:27:24pm 29 Aug 2006 PAGE1
PTEMP. CITY... STATE ZIP...
3 SALT LAKE CITY UT
Krish
I found this old post on comp.databases.pick
http://groups.google.com/group/comp.databases.pick/browse_thread/thread/
2808b1db159fc2e6/a5df053ce372b7e5?lnk=gst&q=internal+data+excel&rnum=1#a
5df053ce372b7e5
Salient excerpt:
The base date for Excel for Windows is January 1, 1900 and for Exc
OK. I am using double-quotes at TCL.
Timothy Snyder <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote on
08/29/2006 09:53:33 AM:
> When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND
> WITH INV.DATE = '12/14/05'" no items are selected.
Try it with double quotes instead of single
If the indexes are deleted, the select statement works fine.
Kevin King <[EMAIL PROTECTED]> wrote:
>When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH
INV.DATE = '12/14/05'" no items are selected.
And if you disable the index (via DISABLE.INDEX) the select works
fine?
I have done so.
Angelo Collazo <[EMAIL PROTECTED]> wrote: If you have the luxury and can do a
build.index on primetime then do it.
This would rule out corrupted indexes.
Hope It helps.
Cheers,
Angelo
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave
Yes. I am sure.
If for some reason, I can't get this index to work --- I may convert the date
to output
format and store it that way.
Jeff Schasny <[EMAIL PROTECTED]> wrote:
OK, I'll ask the obvious question. Are you sure that there is data
matching this criteria in the file?
Dave S w
We had a problem with the udtsort.exe in 5.2. IBM actually had us use
the udtsort.exe from an earlier version. Now that I think about it, the
problem may not have been resolved until 6.0.12. Please don't start
using different versions of udtsort.exe without verification from IBM of
which versions
We have tried both ways.
I am now tweaking the invoice date dictionary to see if that helps.
Gordon J Glorfield <[EMAIL PROTECTED]> wrote:
It's always been my understanding that the single quotes don't work at
ECL/TCL. I'd try the same thing but use double quotes instead.
Gordon J. Glo
Dave,
I'm not aware of any issues.
UniData will only use one index per Select statement.
What results do you get when you use the NO.INDEX keyword?
Thanks,
David A. Green
DAG Consulting
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave S
Sent: Tues
Do you mean something like this:
SUBR("-FIELDS", Mv_Dict, " ", 2);
SUBR("-FIELDS", @1, "*", 1);
SUBR("-FIELDS", @1, "*", 2);
SUBR("-FIELDS", @, ".", 1);
OCONVS(@2, "D2/");
OCONVS(@4, "MTH");
SPLICE(@5, " ", @6)
Thanks,
David A. Green
DAG Consulting
-Original Message-
From: [EMAIL PROTEC
[EMAIL PROTECTED] wrote on 08/29/2006 09:53:33 AM:
> When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND
> WITH INV.DATE = '12/14/05'" no items are selected.
Try it with double quotes instead of single quotes. It may be taking those
values as primary keys.
---
u2-users mailing
If you have the luxury and can do a build.index on primetime then do it.
This would rule out corrupted indexes.
Hope It helps.
Cheers,
Angelo
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave S
Sent: Tuesday, August 29, 2006 9:54 AM
To: u2-users@listser
OK, I'll ask the obvious question. Are you sure that there is data
matching this criteria in the file?
Dave S wrote:
We have a file that has the customer number and invoice date indexed.
When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items
>When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH
INV.DATE = '12/14/05'" no items are selected.
And if you disable the index (via DISABLE.INDEX) the select works
fine? And is the customer number and invoice date both in the ORDERS
file?
-Kevin
[EMAIL PROTECTED]
http://www.P
The number before the asterisk is the date stored as the number of days
since 12/31/1967 (so day 14121 = 08/29/2006).
The remaining number is the number of seconds (and thousandths of
seconds) since midnight. In this case 08:39:50am
[EMAIL PROTECTED] wrote:
I need to convert a Multivalue field
Krish,
Why don't you just transfer the data to MS Excel already converted?
Example.
DT=OCONV(FIELD(DATE_Time_Qty,'*',1),'D4/')
TM1=FIELD(DATE_Time_Qty,'*',2)
TM=OCONV(FIELD(TM1,'.',1),'MT')
You can create a dict or eval item.
Hope it helps.
Cheers,
Angelo
From: [EMAIL PROTECTED]
[mailto:[EMAIL
No system crashes. It's a brand new file that I created.
001: D
002: 1
003: D4-
004: Inv Date
005: 8L
006: S
001: V
002: SUBR("-OCONVS",@ID,"G0.1")
003:
It's always been my understanding that the single quotes don't work at
ECL/TCL. I'd try the same thing but use double quotes instead.
Gordon J. Glorfield
Sr. Applications Developer
UnitedHealthcare's Mid-Atlantic Health Plans
301-360-8839
[EMAIL PROTECTED] wrote on 08/29/2006 09:53:33 AM:
> W
Try using NO.INDEX and see if you get the results you are looking for. If
that is the case, you need to rebuild the index. Have you had any system
crashes lately?
select ORDERS NO.INDEX WITH CUST.NO = '12345' AND WITH INV.DATE =
'12/14/05'"
-Original Message-
From: [EMAIL PROTECTED]
[mailt
We have a file that has the customer number and invoice date indexed.
When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH
INV.DATE = '12/14/05'" no items are selected.
We are running Unidata 6.0.6.
Is anyone aware of any issues ?
--
I need to convert a Multivalue field to Date and Time format in MS Excel. The
Mutivalue filed has the following description and the value next to that.
Date_Time_Qty: 14121*31190.858
Any suggestion is appreciated.
Thanks.
Krish
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubsc
I've seen that happen when we migrate to a new server, and don't share
the UV folder, and the uvtemp folder. For just one user, could it be
possible he's not in the security group with permissions to those
folders?
Occasionally when we add a new user, we forget to put them in the groups
they need t
I will be out of the office starting 25/08/2006 and will not return until
04/09/2006.
I will respond to your message when I return.
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLab
41 matches
Mail list logo