www.galahtech.com does Visual Basic AND Multi-Value databases and lots more!
> -Original Message-
> From: kmbodine [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 10, 2004 9:09 AM
> To: [EMAIL PROTECTED]
> Subject: [U2] OT - Visual Basic 6.0
>
> Can anyone tell me where is find a Visual Ba
Read the section in the BASIC manual on transaction isolation. You can, if you
desire, prevent various kinds of data anomaly by the intelligent use of transaction
isolation levels. For example, to guarantee that no "being updated" records are
selected, take a shared file lock (FS) prior to exe
Phil Walker wrote:
> Another way of getting at the command line is GET(ARG) which
> returns the
> command line element at a time respecting quotes as well.
Last time I looked, UniData didn't support GET(ARG.).
Cheers,
Ken
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listi
My first post to the new list was this, but I don't see it in the digest so
I'm re-sending it.
I was doing a little consulting work at a new client when I finally got
around to writing a utility I have been thinking about for some time.
As a background, I usually copy the various ...LIST verbs
Another way of getting at the command line is GET(ARG) which returns the
command line element at a time respecting quotes as well.
Phil Walker
+64 21 336294
[EMAIL PROTECTED]
Gnosys Consulting Limited
11 Woodward Road, Mount Albert, Auckland 1003, New Zealand
DISCLAIMER: This electronic message t
Thanks guys - I think @SENTENCE was what I wanted ---
DW
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Walker, Dave (Ivy
Hill)
Sent: Thursday, May 13, 2004 1:02 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [U2] UniData equivalent of GETBASIC
Look at @SENTE
Barry Brevik wrote:
> Thanks for the replies. I would have preferred to use dynamic arrays
> because... well, because they are dynamic.
I think what David was pointing out with his quote from the manual set is
that the DIM statement is your friend. IIRC the INMAT() function will tell
you how big
Moral of the tale TRIM any numeric data fields BEFORE they are written and a
TRIMB doesn't hurt on strings either !
Ross Ferris
Stamina Software
Visage an Evolution in Software Development
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On B
If the item exists on file (in the group) at the time the select processor is running,
it will be "selected" - new items "being" created (eg: READU on non-existent item)
don't live on the group, so will not appear.
An item in the process of being changed, provided the EXISTING record meets your
Anthony,
Some semi-random thoughts to consider :
1) Do you really NEED to store the signature inside Universe, or can you get by with a
pointer to file in Windows/Unix space ? If it MUST be IN universe then you will need
to convert image into, say, hex, and when putting "out there" for re-displ
IBM has worked hard not only to have a good program for U2 customers who
attend the U2 track in the IBM DB2 conference in September, but also has
been able to get us a 1/2 day FREE pre-conference meeting on the schedule.
The afternoon (and evening with optional community activities) of Sunday,
Sep
In case any one is wondering what happened to the originator of this thread
- I can only handle the digest version of this list these days and I was
amazed when I got to read Volumes #29, #30 and #31 to see what response I
had created.
Thanks for all the input.
UV certainly seems to stand out fro
Try @SENTENCE - it pulls in the last command executed from TCL
HTH,
Steve
>In UniVerse, they have GETBASIC which pulls in command line information
from
>executing a Basic program
>
>What is the equivalent process in UniData, for example, if I have
>
>RUNTHISPROG opta optb
>
>Where RUNTHISP
I'm guessing your data bytes wrapped around the max value of a signed int
(2GB).
At 03:27 PM 5/13/2004, you wrote:
When I did ANALYZE.FILE the number of data bytes is less than zero, the
screen of results is
File name = PV
File type =
Hi David
in unidata 6.0 try this
RUNTHISPROG = SYSTEM(40)
regards, Marco
From: "David Wolverton" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: [U2] UniData equivalent of GETBASIC
Date: Thu, 13 May 2004 12:51:55 -0500
In UniVerse, they have GETBASIC which pulls
Yes - it can be done. I pull dozens of DB2 tables every day (as well as
Access/MsSql/MySQL) using BCI (basic sql client interface). There's a pretty
good sample program in the documentation.
Setting up the ODBC was fairly simple on my W2k system. I believe your AIX
may be a bit more complicated (i.
When I did ANALYZE.FILE the number of data bytes is less than zero, the
screen of results is
File name = PV
File type = 10
Number of groups in file (modulo) = 1176041
Separation = 4
Number of r
'T'was a rather hurried response as I had to go to a meeting. You can access
your command line using @SENTENCE.
In the case you stated below, @SENTENCE would equal "RUNTHISPROG opta optb".
--
Dave Walker
,... ???)) -:|:-
-:|:-,..? ..???))
((,,..? ...? -:|:
The only things I can suggest are to select on indexed fields. Try to
put your static selections into the view rather then in the crystal
report selection. The example would be if you only want active
customers then you would have the view select them rather then do this
in the crystal report sel
Much of the data I must work with has its origin in a DB2 system used by
other users on the campus. I am quite happy with the batch transfer of
these main files. However these files are rife with codes, as you would
expect. The transfer of the definition tables for the codes has been
haphazard
>What is really scary is:
>
>PRINT NUM(" 1")
>PRINT NUM("1 ")
More scary is that NUM('') also returns 1. An empty string is not a number.
I find this annoying.
An empty string is also not a 'string', and ALPHA('') returns 0 which is
what I would expect.
---
u2-users mailing list
[EMAIL PROTEC
Look at @SENTENCE
--
Dave Walker
8..7 4(()) -:&:-
-:&:-8.74 .74(())
((88.74 ..74 -:&:-
((88.74 * Peace
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of David
> Wolverton
> Sent: Thurs
In UniVerse, they have GETBASIC which pulls in command line information from
executing a Basic program
What is the equivalent process in UniData, for example, if I have
RUNTHISPROG opta optb
Where RUNTHISPROG is a cataloged program, what would I do to 'see' opta and
optb?
DW
---
u2-use
Haven't done it with Universe, but I've done it with other languages. It's
getting harder to find "wedge" devices for serial terminals, but there's
still a few out there. You'd probably have better luck finding hardware for
a PC than for a serial terminal.
Basically the way most of the sig captu
What is really scary is:
PRINT NUM(" 1")
PRINT NUM("1 ")
Both yield 1 (true).
This has resulted in MANY downstream data issues where input validation worked (using
the NUM function) yet further down the road, printing out order qtys using masking or
doing a locate statement of "1" in " 1" doe
Thanks for the replies. I would have preferred to use dynamic arrays
because... well, because they are dynamic.
But I can live with a matrix.
Barry Brevik
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
I have had no problems with the 'test' button - with it returning and answer
within 2-3 seconds. However, I too have run into issues with performance.
I'd sure like to see some documentation that would help address performance
when selecting large amounts of data.
Bryan Haglund
Haglund Consulting
Eric,
The first thing you need to do is to add your specific OLE connection using
the UCI Config Editor. The minimum requirements are:
DBMSTYPEUNIVERSE
NETWORKTCP/IP
SERVICEservice name (uvserver)
HOST ip address used.
Note that for the host, there are certain config
I setup the uci.config file with this
Set the name of the definition to be the same as the account name.
DBMSTYPEUNIDATA
NETWORK TCP/IP
SERVICE udserver
HOSTenter your server name in all caps
ACCOUNT enter your account name in all caps
MAXFETCHBUFF8192
MAXFETCHCOLS400
> Compiling Unibasic: BP\TEST.STRING in mode 'u'.
> compilation finished
> 0 0
> :
Hi,
I've now found out there's a UDT.OPTIONS which controls this; we're setting
it at login.
10 U_TRIMNBR ON
Ben
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-u
it would have to have been created but being updated would not be an issue
since a select only returns a list of IDs and not the data associated with
the ID.
-Original Message-
From: Sunny Matharoo [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 8:47 AM
To: '[EMAIL PROTECTED]'
Subje
All,
Has anyone had any luck connecting Crystal Reports to a U2 database
using OleDB? I'm trying it here and keep getting the message 'cannot
connect to non U2 databases' (I have UniVerse and SQL Server installed
but I'm using the UniOleDB Provider) - ODBC connectivity works fine but
I want to use
Hi,
Is it possible to select an item in a select list, that may in the process
of being written too or in the process of being created?
Also would it cause locking issues for programs that try to access them.
Thanks,
Sunny Matharoo
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug
Yes, I successfully implemented a solution for a previous employer using VB and
Unidata. Contact me direct should you want to discuss further.
> Has anyone implemented a signature capture solution using Universe ? We are
> in the initial stages of looking into capturing signatures. Right now, a
UniData 6.1 beta 2:
:AE BP TEST.STRING
Top of "TEST.STRING" in "BP", 6 lines, 53 characters.
*--: P
001: A = '1'
002: B = '1 '
003: X = ''
004: Y = ' '
005: PRINT (A=B),(X=Y)
006: END
Bottom.
*--: FIBR
Filed "TEST.STRING" in file "BP" unchanged.
Compiling Unibasic: BP\TEST.STRING in mode 'u'.
comp
So it is consistent with my own theory (as an outside observer) about
the fundamental philosophy behind UniVerse: namely, that UV tries very
hard to be forgiving and generally tries to resolve ambiguities and
proceed with what it thinks the programmer meant, rather than being
hard-nosed and either
I had around 38 or 40 overnight, it seems pretty much the same to me.
One wonders if it is getting through to everyone
Bob
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Ron White
Sent: 13 May 2004 14:32
To: [EMAIL PROTECTED]
Subject: Re: [U2] What has hap
Yes. I have noticed the drop. Yesterday I didn't receive
an message from the list for almost five hours. I don't
think that has ever happened before during normal
working hours. Well, maybe with the exception of major
holidays.
Ron White
- Original Message -
From: "Ross Ferris" <[EMA
Has anyone implemented a signature capture solution using Universe ? We are
in the initial stages of looking into capturing signatures. Right now, all
of our cashiering terminals are plan dumb terms doing vt100 emulation. I
would suppose that we would have to change hardware. I wonder how the
s
Use IF TRIM(X) = TRIM(Y) THEN ...
-Original Message-
From: Stewart Leicester [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 11:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] SPACE character ignored
>How can I force them to be tested for TXT equivalence?
>
>Do I have to say:
>
>
on universe, maybe try using COMPARE ?
a = " 1"
b = "1 "
c = compare(a,b)
crt c
output = -1 ( false )
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jan Shaw and
Keith Johnson
Sent: Thursday, May 13, 2004 3:26 AM
To: U2-Users
Subject: RE: [U2] SPACE chara
Try it using = not EQ
Les
-Original Message-
From: Ben Gladman [mailto:[EMAIL PROTECTED]
Sent: 13 May 2004 10:40
To: [EMAIL PROTECTED]
Subject: Re: [U2] SPACE character ignored
"Leroy Dreyfuss" wrote:
> UniData shows both conditions to be false, as does D3.
not on my version of unid
"Leroy Dreyfuss" wrote:
> UniData shows both conditions to be false, as does D3.
not on my version of unidata (6.0):
SUBROUTINE BJGTEST
*
T1 = ('1' EQ '1 ')
CRT 'Test 1: ':T1
*
T2 = (' 1' EQ '1 ')
CRT 'Test 2: ':T2
*
T3 = ('1 ' EQ '1 ')
CRT 'Test 3: ':T3
*
C=('1':SPACE(16))
Lindsay Gregory wrote
.I have to say
IF LEN(X) = LEN(TRIM(X)) AND LEN(Y) = LEN(TRIM(Y)) AND X = Y THEN true
There has got to be an easier way !!
I had exactly this problem and my solution was
IF '*':TEMP NE '*':LINE THEN
Regards, Keith Johnson
Owner/Host
www.emeraldglenlodge.co.nz
0
I will be out of the office starting 05/13/2004 and will not return until
05/24/2004.
I will have limited access to email. If this is urgent please contact
Elizabeth Schmitt at (303)312-3119 or [EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
45 matches
Mail list logo