Re: [U2] Redback Limit

2011-03-30 Thread Ross Ferris
You said you were making XML no stray ">" or "<" in the data you are generating that could throw things off? Ross Ferris Stamina Software Visage > Better by Design! >-Original Message- >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- >boun...@listserver.u2ug.org] On Be

Re: [U2] Trigger questions

2011-03-30 Thread Boydell, Stuart
If you want to force the trigger to issue a rollback I think you need to execute the SetDiagnostics function. Something like... subroutine TRIGGER.HANDLER(triggerName,schema,tableName, event,eventTime, newRecordID,newRecord,oldRecordID,oldReco

Re: [U2] Redback Limit

2011-03-30 Thread Israel, John R.
There were 13 columns with 970 rows (including a header). These columns included: E-mail address User Name Domain User Type Last Login Date Last Login Time AR Inq (1/0) Sales Inq (1/0) RMA Inq (1/0) Products Inq (1/0) Storefront (1/0) USA Companies (svm) Canadian Companies (svm) The last 2 colum

Re: [U2] Trigger questions

2011-03-30 Thread BNeylon
Yeah, 10 Bruce M Neylon Health Care Management Group From: Charlie Noah To: U2 Users List Date: 03/30/2011 03:13 PM Subject:Re: [U2] Trigger questions Sent by:u2-users-boun...@listserver.u2ug.org Make that 2!!! Charlie Noah On 03-30-2011 1:59 PM, Steve Romanow

Re: [U2] Trigger questions

2011-03-30 Thread Charlie Noah
Make that 2!!! Charlie Noah On 03-30-2011 1:59 PM, Steve Romanow wrote: me, me, there is at least one! :) On Wed, Mar 30, 2011 at 2:32 PM, wrote: In a message dated 3/30/2011 11:03:07 AM Pacific Daylight Time, d...@chancofamily.com writes: There are 10 kinds of people in the world, tho

Re: [U2] Trigger questions

2011-03-30 Thread Steve Romanow
me, me, there is at least one! :) On Wed, Mar 30, 2011 at 2:32 PM, wrote: > In a message dated 3/30/2011 11:03:07 AM Pacific Daylight Time, > d...@chancofamily.com writes: > > >> There are 10 kinds of people in the world, those that know binary and >> those that do not.  Along the same lines t

Re: [U2] Trigger questions

2011-03-30 Thread FFT2001
In a message dated 3/30/2011 11:03:07 AM Pacific Daylight Time, d...@chancofamily.com writes: > There are 10 kinds of people in the world, those that know binary and > those that do not. Along the same lines there are those who know java and > those who want to learn java .. > You mean

Re: [U2] Redback Limit

2011-03-30 Thread Holt, Jake
How many fields do you have? From what I remember reading, there was a field limit on RBOs, it was like a thousand fields though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, Mar

Re: [U2] Trigger questions

2011-03-30 Thread David A. Green
Doug, In UniData you can test for STATUS() after the ON ERROR of a WRITE command. If the STATUS() is 2 then the WRITE failed in the Trigger. You can also set @USER.RETURN.CODE or use a COMMON variable to pass the error code/message. David A. Green (480) 813-1725 DAG Consulting -Original Me

Re: [U2] Trigger questions

2011-03-30 Thread Doug Chanco
Sorry it's universe on aix but can also be tested/run on windows and Linux Dougc There are 10 kinds of people in the world, those that know binary and those that do not. Along the same lines there are those who know java and those who want to learn java .. On Mar 30, 2011, at 12:10, Ke

[U2] dynamically disassociate associated fields?

2011-03-30 Thread Shane Ricciardi
Hello. I have a rather large MV association that contains around 40 or so I- type dicts that all call subroutines. Since this is essentially a "subtable" to uv/SQL, selecting any field from the subtable causes all the fields to be processed, although only the requested field is returned. As you c

Re: [U2] Trigger questions

2011-03-30 Thread Lettau, Jeff
Does anyone have EDA working to SQL yet? Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, March 30, 2011 12:21 PM To: U2 Users List Subje

Re: [U2] Trigger questions

2011-03-30 Thread Marc Harbeson
"deal with it" means ON ERROR clause -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Wednesday, March 30, 2011 12:42 PM To: 'U2 Users List' Subject: Re: [U2] Trigger questions By definition -

Re: [U2] Trigger questions

2011-03-30 Thread Colin Alfke
By definition - if you're creating a write trigger the first parameter is the status. >From "Developing UniBasic Applications" SUBROUTINE trigname(execstat, dictflag, filename, record.ID.expr, recordval) execstat The execution status returned by the trigger subroutine: 0 - No updates are allowed.

Re: [U2] Trigger questions

2011-03-30 Thread Charlie Noah
Eating Disorders Anonymous??? ;-) Sorry, couldn't resist. Charlie Noah On 03-30-2011 11:20 AM, Steve Romanow wrote: This is what EDA is for isnt it? On Wed, Mar 30, 2011 at 12:10 PM, Kevin King wrote: Unidata or Universe? ___ U2-Users mailing list

Re: [U2] Trigger questions

2011-03-30 Thread Steve Romanow
This is what EDA is for isnt it? On Wed, Mar 30, 2011 at 12:10 PM, Kevin King wrote: > Unidata or Universe? > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___

Re: [U2] Trigger questions

2011-03-30 Thread Kevin King
Unidata or Universe? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Trigger questions

2011-03-30 Thread Doug Chanco
I am sure I can do this but I am trying to figure out the best way I need to write a WRITE trigger that does the following Call a java web service to update an SQL table (no problem) But if the update fails do NOT update the pick record and if possible notify the user My question is w

Re: [U2] Redback Limit

2011-03-30 Thread Israel, John R.
It was not timing out. I have other pages that take longer. It really seemed to be a size limit. I develop with FF with a Web Developer plug-in that helps a lot. I validate with IE, Chrome, Opera and Safari, but FF is my preferred browser. John Israel Senior Programmer/Analyst Dayton Super

Re: [U2] Redback Limit

2011-03-30 Thread Glen Batchelor
Try using cURL or wget, with an unlimited timeout, and get the real headers from the server. Assuming you're using IE, it rarely tells a true story when it comes to server connection issues or HTTP errors. Glen Batchelor IT Director/CIO/CTO All-Spec Indus

Re: [U2] Redback Limit

2011-03-30 Thread Israel, John R.
I was exporting all the user info we track with Avanté's ePortal from ePortal back to a web page which rips the data apart and automatically opens it in Excel. Over 900 records with all kinds of info (name, company, access, etc.) I was never able to find any corruption in the data. I did find