Thanks, David. I'll check those references and post a summary
findings back to the list.
I really appreciate the help!
Regards,
Clif
On May 6, 2008, at 8:31 PM, Hona, David S wrote:
Clif,
I vaguely recall that the UniXML functionality isn't officially
supported until UV 10.2.x (on the
Hi Clif
I think I was confusing UniXML with U2 Web Services Developer, which is
mentioned in 'newfeatures.pdf' for UV 10.2. This states for U2WSD, that
UV 10.1.18 (or greater) is required. But I stumbled upon the fact UniXML
works on this release (10.1.18), but not lower ones. I can't find any
Anyone used these peoples web service???
Bob
Confidentiality Notice: This e-mail and any attachments are intended solely
for the addressee and may contain confidential or privileged information.
If you are not the named addressee, or the person responsible for delivering
the message to
Yes - we do I'll email off line
George
On 07/05/2008 14:27, Bob Witney [EMAIL PROTECTED] wrote:
Anyone used these peoples web service???
Bob
Confidentiality Notice: This e-mail and any attachments are intended solely
for the addressee and may contain confidential or
I am trying to make sure that if one Customer.Service rep is updating a
Sales Order, then the other Cust.Svc rep is
blocked from accessing the same record.
The following code will indicates that the record is locked but when the 2nd
user goes in (in an independent session), the second user gets
I feel I am missing something. Why is a READU LOCKED not used?
Bruce M Neylon
Health Care Management Group
Brutzman, Bill [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/07/2008 11:00 AM
Please respond to
u2-users@listserver.u2ug.org
To
'u2-users@listserver.u2ug.org'
why not do a READU using the LOCKED clause? Something like
READU ORDER.ITEM FROM F.ORDER LOCKED
PRINT 'record is locked ..'
INPUT JUNK
END ELSE
* I got the record AND locked it, so do my thing .
END
you could even loop around a couple of times to see if the lock releases
and
Do I need a READU if I am already using a RECORDLOCKU command?
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, May 07, 2008 11:34 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Record Locking Problems
I
I think he's using the recordlocked and recordlocku syntax to illustrate
his problem. From the documentation that I've read on those two commands
(which I'd never seen before today), this should work.
Karen Bessel
Software Developer
Tyler Technologies, Inc.
6500 International Parkway, Suite
From the universe documentation
Description
Use RECORDLOCK statements to acquire a record lock on a record without
reading the record.
Description
Use the RECORDLOCKED function to return the status of a record lock.
I too may be missing something but why get a lock on a record without
I don't know the RECORDLOCKU construct, though I looked it up.
I know the READU with the LOCKED clause and I know it works. And I know
when and under what circumstances the lock is released.
It's just a matter of style, I guess it does the exact same thing (maybe.
:-) ) Seems like a waste
Recordlocku does not read the record...
Karen Bessel
Software Developer
Tyler Technologies, Inc.
6500 International Parkway, Suite 2000
Plano, TX 75093
Phone: 972.713.3770 ext:6227
Fax: 972.713.3777
Email: [EMAIL PROTECTED]
Web: http://www.tylertech.com
-Original Message-
From:
And yet his results pretty much show they don't.
I'd fall back and punt and just use the READU
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Bessel, Karen
Sent: Wednesday, May 07, 2008 09:24
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Record
By using READU, you can also do fun things when your code takes the
locked clause, such as offering an inquiry-only mode (i.e. updates are
disabled), which is terribly user-friendly. And/or you can display who's
locking the record so the lockee can contact the locker, also
terribly user-friendly.
Bill,
The RECORDLOCKED returns a number of values, the value of 1 states that
this user has a record lock, not another user.
Try using an else on the case structure.
Cheers,
David Murray
*
Learn and do
* Excel and share
http://u2blog.org
-Original Message-
Hey all,
We are using ICONV(VAR,'DB') and it works perfectly except one case when
the date is the last day of February any year.
For instance for VAR=31-MAR-2007 INTERNAL.VAR=ICONV(VAR,'DB')
INTERNAL.VAR=14335
For VAR=28-FEB-2007 INTERNAL.VAR=ICONV(VAR,'DB') INTERNAL.VAR=''
In case
I have seen odd things happen if you specify the exact date conversion
for ICONV. I have never had a problem getting the correct results for
an ICONV on a date by just using D. It is the most understanding and
graceful.
John Israel
Sr. Programmer/Analyst
Dayton Superior Corporation
721 Richard
Your code doesn't test for the type of lock. It could be just a shared
record lock which would allow another user to get in.
Jerry Banker
Senior Programmer Analyst
IBM Certified Solutions Expert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman,
Irina,
I do not think that a ICONV conversion code of 'DB' is actually valid.
'DMB', DWB' etc for short codes for month and day respectively are OK.
Cheers,
David Murray
*
Learn and do
* Excel and share
http://u2blog.org
-Original Message-
From: [EMAIL
David,
It is possibly valid because it passed the compilation.
If it will not pass the compilation we would know it is not valid and
just do not consider this conversion. The point is that is probably
legitimate conversion because it still works for other date conversion
except the last day of
The compiler does not check the string. See below:
ED BP TTT
New record.
: I
0001= LLL =
Irina,
Err, no.
It is possible to include text within a ICONV or OCONV for formatting. So,
the compiler is assuming that it valid format text.
It is not in the manual, so I would state that it is not valid.
Cheers,
David Murray
*
Learn and do
* Excel and share
Irina:
I don't think the B in 'DB' has any effect on internal conversion in
Universe. I don't know about UniData - which are you using?
We have Universe 10.2. I ran this little program to compare the result
after an ICONV using the 'D' and 'DB' conversions:
0001: FOR I = 1000 TO 14731
0002:
It's confirmed. As soon I globally cataloged that routine,
DataGridView is working. We haven't gotten a list box to work, but
that will be another subject line for archive purposes.
Thank you!
Regards,
Clif
On May 6, 2008, at 3:12 PM, Clifton Oliver wrote:
Sure enough, that subroutine
The software I am supporting has a user screen which builds and saves
enquiry statements (English/Access/Recall). I recently created another
screen to allow users to use the defined statement/report to output XML
to the HOLD file and to transfer the results to their PC. All well
and good, but
Bill
I think your problem is related to re-opening the file in the subroutine.
Everytime you open a file you clear all the previous locks. Ie the user
opens file, locks record and then opens file again there is no record locks.
Use a fileinfo statement to check file is open and if it is skip
On UV triggers, I've used them often on UD and now have a great application
for them on UV. I searched the VOC and found no commands with the word
'trigger' in them. I was expecting the CREATE.TRIGGER of Unidata.What's
the syntax for setting them up in UV?
Mike Randall, MCP
From: BobW
Anyone used these peoples web service???
For anyone who didn't understand the inquiry, Commidea (one word)
info can be found here: http://www.commidea.com/
As most people in this market know, TotalLink is the major player
in the MV payment processing arena. See
Try looking in the SQL.HELP file.
02 SEARCH SQL.HELP
STRING:TRIGGER
STRING:
4 record(s) selected to SELECT list #0.
LIST ONLY SQL.HELP
LIST ONLY SQL.HELP 05:52:53pm 07 May 2008 PAGE1
SYS.HELP
CREATE SCHEMA
CREATE TRIGGER
ALTER TABLE
DROP TRIGGER
4 records listed.
Tom Dodds
Excuse me. I mistyped. That is three 90 minute sessions, not one hour.
Regards,
Clif
Begin forwarded message:
From: Clifton Oliver [EMAIL PROTECTED]
Date: May 7, 2008 5:58:05 PM PDT
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniVerse Triggers
It's a UniVerse SQL command (yes,
It's a UniVerse SQL command (yes, even if the file is not an SQL table).
CREATE TRIGGER triggername { BEFORE | AFTER } event [ OR event ] ON
tablename FOR EACH ROW CALLING ' program ' ;
Details are in chapter 5 of the UniVerse SQL Reference.
[AD]
Also, I will be conducting a webinar
Interesting, I actually saw the trigger reference under SQL and made the
incorrect assumption that it was referring to actual SQL commands rather
than calling BASIC subroutines. Thanks for correction.
Mike Randall, MCP
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
32 matches
Mail list logo