Scott Ballinger wrote:
> The trigger is normally called twice: the first time you get the
> original @RECORD, the second time the new @RECORD. If an item
> is new or
> being deleted, then the trigger is called only once. I use
> named common
> to track of where I am and to save old @RECORD, so tha
Hi Dan,
Attached is a document I wrote (for our monthly newsletter) to use
triggers. The example is to trap record corruption, there is coding for
both UniData & UniVerse. We found the culprit within 10 minutes of
implementing the trigger!
There is a cost to using triggers though I measur
Hi Steven,
What version of UniData are you running on the test box?
My current experience is that on UniData 6.0 ObjectCall does work,
however on UniData 6.1 hp/ux it ObjectCall is fatally broken! (if anyone
has a workaround to get ObjectCall working on hp.ux/udt 6.1 I'd be
interested.)
In answ
Steven Frost wrote:
> Sent: Friday, 11 March 2005 2:10 PM
> Subject: [U2] [UD] Objectcall again -- Australia 48-2
>
> I am still having a bit of an issue with the Objectcall API
> Objectcall ping works fine to both the live database and the
> test database ( different unix servers)
> When the unia
Here is a direct link to the last one of the four articles that Tony is
referring to. This will open as a pdf inside your browser, takes about 20
seconds on a T1 connection to open it.
http://www.intl-spectrum.com/publications/JulAug04.pdf
Will
-Original Message-
From: Tony Gravagn
>>Is anyone on this list an Epicor user ?
Here's another one.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Here Here
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Friday, March 11, 2005 8:52 PM
To: u2-users@listserver.u2ug.org
Subject: [U2]: Epicor
Is anyone on this list an Epicor user ? I have a client who is examining
Epicor as a pos
Is anyone on this list an Epicor user ? I have a client who is examining
Epicor as a possible solution to part of what they need and would like some
input.
Thanks
Will Johnson
Fast Forward
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2
I think this must be something to do with why proper triggers impose
such a load on a universe system. It has to check for deletes using some
internal mechanism.
Mind you the replication in Universe imposes very little load and that
track deletes as well
-Original Message-
From: [EMAI
Must be a Unidata thing. It only gets called once on Universe.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger
Sent: 11 March 2005 22:29
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Triggers docs?
The trigger is normally called twice
Please see my four articles on Web Services and .NET, originally printed in
Spectrum Magazine from 2003-2004. Magazines are here:
http://www.intl-spectrum.com/SPECTRUMMAG.HTML
HTML versions here:
http://../articles/
I also have an article there called "SOAP for people who don't do
prot
I should think a little longer before pressing send... It's not that
easy to catch a delete using this kind of trigger. You can test for a
new record by trying to read it, if it's not there then this is a new
update. But since the trigger is called only once for a delete, it gets
pretty ugly to tra
I used the pseudo-trigger method in UV 9.6. Although you cannot tell a
DELETE during the trigger firing I did determine the DELETE status during
log file processing by doing a read of the file. If no record was found I
new it was a deleted record.
Jay
-Original Message-
From: [EMAIL PROTE
The trigger is normally called twice: the first time you get the
original @RECORD, the second time the new @RECORD. If an item is new or
being deleted, then the trigger is called only once. I use named common
to track of where I am and to save old @RECORD, so that I can test: if
this is not a new i
I use something like somestuff:' CODE = "A12]" ': otherstuff
or as an alternate
somestuff:' CODE >= "A12" AND < "A13" ':otherstuff
Works with the index, i.e. fast.
Will Johnson
-Original Message-
From: Dan Knutson <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org
Sent: Fri, 11 Mar
What is a Modertor ? And again, many people on this list will have no idea HOW
to move it to community. If you simply put community in the reply to field you
can be of great assistance to all and sundry.
Will
-Original Message-
From: Moderator <[EMAIL PROTECTED]>
To: u2-users@listser
This one has come up again and again over the last few weeks. You'll
find lots of posting about it on www.indexinfocus.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy
Sent: 11 March 2005 21:00
To: u2-users@listserver.u2ug.org
Subject: [U2
How do you track a record being deleted from the file though?
The real trigger mechanism fires with INSERT, UPDATE or DELETE.
If memory serves this type of pseudo-trigger can't differentiate between
a delete and an insert/update.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
My problem seems to be that Unidata see's the A and thinks I am doing a
alphanumeric search on everything after the A. It takes the A as a
command to do an alphanumeric search. I was told you could put quotes
around the criteria to get it to work right but so far I have not been
able to do that.
Has anyone developed a web service for Universe ?
I'm trying to gather as much info as I can about the technology used. I
realize UV 10.1 has many of the tools that I'll need for the backend,
but what is normally used on the frontend, what communications protocal
is normally used ?
I've read alo
Try quoting it as "'A12'..." instead.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton
Sent: 11 March 2005 20:08
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Indexing issue
From: "Dan Knutson" <[EMAIL PROTECTED]>
Sent: Friday, March 11,
Not necessarily so... An index on the primary key will not only allow
you to sort or sselect the file by that key instantly, but also allow
quick selects on partial keys (e.g. select myfile with key = 12345]).
Admittedly esoteric, but on occasion handy.
Scott Ballinger
Pareto Corporation
Edmonds W
Here is link that might be helpful: (works for both UV & UD)
http://www.mindspring.com/~tpackert/unidata_tricks.htm
I have used the index-trigger method to track and record all changes to
a file. It seems to work well; the performance hit has been negligible.
If anyone is interested I will post t
From: "Dan Knutson" <[EMAIL PROTECTED]>
Sent: Friday, March 11, 2005 2:23 PM
Subject: [U2] Indexing issue
> I have a file that has thousands of keys that start with an A. There is
> an index on the key. When I try and do a search for any items that start
> with say A12 and I type in A12... the se
> The manual is a bit skimpy on triggers. Any supplemetal docs around?
>
> We're trying to track updates to a file; individual items have gone missing
> lately. No SQL involvement at all.
Sorry, can't comment on Universe.
For unidata, here's some brief docs I wrote after digging. I found info i
I have a file that has thousands of keys that start with an A. There is
an index on the key. When I try and do a search for any items that start
with say A12 and I type in A12... the search does not return what I
expect and takes a long time because Unidata thinks it is doing a
Alphanumeric search.
Dan,
I haven't found any additional documentation but I have come across a
serious gotcha. Once you add a trigger to a file it is a SQL file. There is
no going back short of creating a new table. This makes it difficult to move
data between INDIAN's (sp?). I have been unable, even using FORMAT.CON
I used this post by Bryan Thorell as a starting point when I set them up for
the first time. BTW, Thanks Bryan!
http://www.indexinfocus.com/dl/u2list/200210/40372.html
> -Original Message-
> From: Dan Fitzgerald [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 11, 2005 10:15 AM
> To: u2-u
The manual is a bit skimpy on triggers. Any supplemetal docs around?
We're trying to track updates to a file; individual items have gone missing
lately. No SQL involvement at all.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Many thanks to all repliers, this was enormously helpful & greatly
appreciated, I've found the relevant portions in the PICK manual now.
Phil Walker wrote:
STACKWRITE [OFF|ON]
Place this in the LOGIN paragraph or even the UV.LOGIN paragraph in the UV
account for a system wide setting.
Cheers,
Phi
Grab a copy of the pdf's and use them. That's more readable than the
help files. I'm lucky in that we have a few high speed printers here
that can do double sided pages. Once printed that way, I have the
pdf's bound into crude books.
On Fri, 11 Mar 2005 09:26:25 -0600, Marilyn Hilb
<[EMAIL PRO
In universe I usually edit the help file to read it. Tis so much easier to page
down/up line by line , print etc. SYS.HELP and BASIC.HELP are the two files I
know of that contain the help documents. (alto I am sb+ as well but I would
think the help is at the universe level, not sb+.)
Thanks,
32 matches
Mail list logo