headers
Susan Joslyn | 1 Dec 2008 17:15

[U2] Universe triggers (still more)

Hi everyone,

I have the triggers working - yay! Thanks Manu! - but now I'm to the next
step, and of course stumbling again!  My program sets a flag when it wants
to disallow the write that called the trigger.  The manual seems to suggest
that I could use SetDiagnostic to fail this . but I'm not even getting my
program to compile and can't find further information on the syntax of that
command.  Anyone know how to tell the trigger to refuse the write?

Susan
-------
u2-users mailing list
u2-users <at> listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Permalink | Reply | 4 comments |
headers
Jeff Butera | 1 Dec 2008 17:46

Re: [U2] Universe triggers (still more)

<quote who='Susan Joslyn' date='Monday 01 December 2008'>
> Hi everyone,
>
>
>
> I have the triggers working - yay! Thanks Manu! - but now I'm to the next
> step, and of course stumbling again!  My program sets a flag when it wants
> to disallow the write that called the trigger.  The manual seems to suggest
> that I could use SetDiagnostic to fail this . but I'm not even getting my
> program to compile and can't find further information on the syntax of that
> command.  Anyone know how to tell the trigger to refuse the write?

I can't comment for Universe, but in Unidata you set EXECSTAT to one of three 
values

0 = don't write the record
1 = write record, but don't allow trigger to have altered the contents
2 = write record and allow trigger to possibly have altered contents

--

-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
jbutera <at> hampshire.edu
413-559-5556

"Where I'm from, we believe all sorts of
    things that aren't true. We call it 'history'."
                       The Wizard, Wicked
-------
(Continue reading)

Permalink | Reply | 1 comment |
headers
Bill Haskett | 1 Dec 2008 20:14
Favicon

Re: [U2] Universe triggers (still more)

   Susan:
   To expand further on Jeff's comment, the EXECSTAT variable is part of the
   CALL arguements list.  For instance, in UniData an update trigger might look
   like:
   001 SUBROUTINE U2.MASTER.TRIGGER.U ( ExecStat, DictFlag, atFILENAME, atID,
   atRECORD )
   The following table describes each parameter of the syntax.
   ** Parameter   Description
   ** ----------  --------------------------------------------------------
   ** trigname    The name of the globally cataloged subroutine.
   ** execstat    The execution status returned by the trigger subroutine:
   **             0 - No updates are allowed.
   **             1 - Updates are allowed.
   **             2 - Updates are allowed, using the return recordval.
   ** dictflag    "DICT" - Indicates that the trigger is operating on the
   **                      dictionary file.
   **             ""     - Indicates that the trigger is operating on the
   **                      data file.
   **             Note: the quotation marks are required.
   ** filename    The name of the file on which the trigger is operating.
   ** item ID     The item ID of the record to be updated.
   ** recordval   The input record value submitted to the UPDATE trigger.
   **             "recordval" is both an input and output parameter. The
   **             trigger can change this value (for example, by performing
   **             a conversion). Then, if the trigger sets execstat to 2,
   **             this value is passed back in recordval and updates the
   **             data record. Only strings and numbers are valid.
   **
   **             If the value returned in recordval is invalid, the record
   **             is not updated, even if the trigger subroutine sets execstat
(Continue reading)

Permalink | Reply | 0 comments |
headers
Bill Haskett | 1 Dec 2008 20:20
Favicon

[Fwd: Re: [U2] Universe triggers (still more)]

Susan:

To expand further on Jeff's comment, the EXECSTAT variable is part of 
the CALL arguements
list. For instance, in UniData an update trigger might look like:

001 SUBROUTINE U2.MASTER.TRIGGER.U ( ExecStat, DictFlag, atFILENAME, atID, atRECORD )

The following table describes each parameter of the syntax.

   ** Parameter   Description
   ** ----------  --------------------------------------------------------
   ** trigname    The name of the globally cataloged subroutine.
   ** execstat    The execution status returned by the trigger subroutine:
   **             0 - No updates are allowed.
   **             1 - Updates are allowed.
   **             2 - Updates are allowed, using the return recordval.
   ** dictflag    "DICT" - Indicates that the trigger is operating on the
   **                      dictionary file.
   **             ""     - Indicates that the trigger is operating on the
   **                      data file.
   **             Note: the quotation marks are required.
   ** filename    The name of the file on which the trigger is operating.
   ** item ID     The item ID of the record to be updated.
   ** recordval   The input record value submitted to the UPDATE trigger.
   **             "recordval" is both an input and output parameter. The
   **             trigger can change this value (for example, by performing
   **             a conversion). Then, if the trigger sets execstat to 2,
   **             this value is passed back in recordval and updates the
   **             data record. Only strings and numbers are valid.
(Continue reading)

Permalink | Reply | 0 comments |
headers
Adam Taylor | 1 Dec 2008 22:50
Favicon

[U2] Printing Graphics from UniVerse

Hey folks,

I've got a multi-part question.  Does anyone have a good method of
printing graphics from UV programs other than the 2-bit black and white?
We'd like to expand into color logos on some of our document and wanted
to know if anyone had come up with a method of including those on
reports/invoices/etc.  As well, does anyone have a good method of
"printing" graphics and reports to file instead of to hardcopy?
Obviously we can print straight text to the &HOLD& file, but we'd also
like to include graphics in some documents we print to file.

Thanks.

Adam Taylor

Sr. Programmer Analyst

INX Inc.

6401 Southwest Freeway

Houston,  Texas  77074

Phone: 713/795-2352

Adam.Taylor <at> inxi.com
-------
u2-users mailing list
u2-users <at> listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
(Continue reading)

Permalink | Reply | 2 comments |
headers
Adam Taylor | 1 Dec 2008 22:49
Favicon

RE: [U2] biztalk adapter

Bob,

We use BizTalk with our UniVerse system, and have found some issues with
using webservices such that certain random connections seemed to get
dropped depending on how many messages you were trying to process at
once.  We have a vendor we work with who will sometimes send us hundreds
of messages in the span of a few minutes, and we'd see a consistent
ratio of dropped connections between the BT server and the webservice.

For us, the answer to that problem was writing a small custom .dll in
.NET that made use of UniObjects.NET to call a UV subroutine to pass the
data.  We then call this .dll from an expressions shape in our
orchestration.  This has seen increased performance and has completely
cleared the connection issues we had with webservices.

Hope this helps.

Adam Taylor
Sr. Programmer Analyst
INX Inc.
Adam.Taylor <at> inxi.com

-----Original Message-----
From: owner-u2-users <at> listserver.u2ug.org
[mailto:owner-u2-users <at> listserver.u2ug.org] On Behalf Of Bob Witney
Sent: Tuesday, November 25, 2008 6:27 AM
To: u2-users <at> listserver.u2ug.org
Subject: RE: [U2] biztalk adapter [ad]

Tony
(Continue reading)

Permalink | Reply | 3 comments |
headers
Ken Hall | 1 Dec 2008 23:43

Re: [U2] Printing Graphics from UniVerse

Adam -
Check out Print Wizard from Rasmussen Software http://www.anzio.com/
It is a great way to add graphics to your printed output and to print 
to file as either text or pdf.

Ken

  At 01:50 PM 12/1/2008, you wrote:
>Hey folks,
>
>
>
>I've got a multi-part question.  Does anyone have a good method of
>printing graphics from UV programs other than the 2-bit black and white?
>We'd like to expand into color logos on some of our document and wanted
>to know if anyone had come up with a method of including those on
>reports/invoices/etc.  As well, does anyone have a good method of
>"printing" graphics and reports to file instead of to hardcopy?
>Obviously we can print straight text to the &HOLD& file, but we'd also
>like to include graphics in some documents we print to file.
>
>
>
>Thanks.
>
>
>
>Adam Taylor
>
>Sr. Programmer Analyst
(Continue reading)

Permalink | Reply | 12 comments |
headers
Brian Leach | 1 Dec 2008 23:46
Picon

RE: [U2] Printing Graphics from UniVerse

Hi Adam

Take a look at mvpdf - it offers a range of ways to create documents, has a drawing API and despite the name also
supports drect printing.

Eval available on www.brianleach.co.uk

Regards

Brian

-----Original Message-----
From: Adam Taylor <Adam.Taylor <at> inxi.com>
Sent: 01 December 2008 21:50
To: u2-users <at> listserver.u2ug.org
Subject: [U2] Printing Graphics from UniVerse

Hey folks,

I've got a multi-part question.  Does anyone have a good method of
printing graphics from UV programs other than the 2-bit black and white?
We'd like to expand into color logos on some of our document and wanted
to know if anyone had come up with a method of including those on
reports/invoices/etc.  As well, does anyone have a good method of
"printing" graphics and reports to file instead of to hardcopy?
Obviously we can print straight text to the &HOLD& file, but we'd also
like to include graphics in some documents we print to file.

Thanks.
(Continue reading)

Permalink | Reply | 1 comment |
headers
Boydell, Stuart | 2 Dec 2008 00:03
Picon

RE: [U2] Universe triggers (still more)

Setdiagnostics is a function which works by adding an error condition
message into the SQL error stack. A trigger program comes from the SQL
side of UV and runs within a transaction boundary, when the
setdiagnostics() function is used it will cause the trigger to go into
rollback mode on return from the trigger program.

See the UniVerse BCI Guide Chap 7 for syntax...
----------------------------
subroutine TRG.CUST.DELETE(...)
open "AR.TRANS" to fvar then
	readu rec from fvar,oldnum then
		junk = setdiagnostics("Open receivables exist for
customer ":oldnum:". Clear transactions before deleting this customer.")
	end else
                  gosub DeleteCustomer:
            end
end
return

>-----Original Message-----
>The manual seems to suggest
>that I could use SetDiagnostic to fail this . but I'm not even getting
my
>program to compile and can't find further information on the syntax of
that
>command.  Anyone know how to tell the trigger to refuse the write?

 
**********************************************************************
This email message and any files transmitted with it are confidential and intended solely for the use of
(Continue reading)

Permalink | Reply | 0 comments |
headers
Tony G | 2 Dec 2008 02:10
Picon
Favicon

RE: [U2] Printing Graphics from UniVerse

Agreed.  I can provide some a couple BASIC code examples that
show how to get PrintWizard to position text, draw boxes, add
color, position and size images, draw lines anywhere on the page,
and position barcodes.  One of the examples shows a multi-page
timesheet with data positioned in an overlay, along with a FAX
coversheet.  PrintWizard takes this direct from the spooler and
faxes it to number provided in the code.  The same output can be
sent to PDF and emailed if desired.  "Cool" is an understatement.

HTH
Tony Gravagno
Nebula Research and Development
TG <at>  remove.pleaseNebula-RnD.com
Nebula R&D sells mv.NET and other Pick/MultiValue products
worldwide, and provides related development and training services

> From: Ken Hall
> Check out Print Wizard from Rasmussen Software 
> http://www.anzio.com/ It is a great way to add 
> graphics to your printed output and to print to file 
> as either text or pdf.

Adam wrote:
> Does anyone have a good method of printing graphics...
-------
u2-users mailing list
u2-users <at> listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
(Continue reading)

Permalink | Reply | 11 comments |

Gmane