[U2] Fw: SMS Solution, U2 Users Digest V1 #754

- Original Message - From: Bjxrn Johannesen - Travelsoft To: Bruce Lunt Sent: Friday, July 29, 2005 4:24 PM Subject: SMS Solution Dear Bruce I have contacts to a Norwgian provider of an SMS Server you can install locally and integrate with whatever. We have not tried it with UD, but it

[U2] UVSH from another machine

DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee

RE: [U2] UVSH from another machine

Andy If I understand this right, you are trying to end up running a uvsh executable on one machine on a UniVerse account on another machine. Bad idea: no least because of the locking issues. You might be better off to write a small VB Script to instantiate a UniObjects connection to the remote

Re: [U2] [UV] get program name

Thanks! I guess I just need to upgrade my uv (9.6.1.4) to take advantage. That's enough incentive for me! -Dianne Stevenson, Charles wrote: Is there a way in basic to get the name of the program you're in? I want to pass the name of the program to a subroutine for error reporting and I

RE: [U2] [UV] get program name

I don't know about UV, but I use SYSTEM(40) on UD to return the absolute path of the object file currently being executed; then pick out the name from this. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Friday, July 29, 2005

[U2] Trigger creation

Two sided question. 1. Can you create triggers on non-SQL tables 2. If the answer to #1 is Yes, how do you create triggers on non-SQL tables. Thanks for the help Tom Dodds [EMAIL PROTECTED] 630-235-2975 --- u2-users mailing list u2-users@listserver.u2ug.org To

RE: [U2] Trigger creation

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds 1. Can you create triggers on non-SQL tables 2. If the answer to #1 is Yes, how do you create triggers on non-SQL tables. What platform and version? -Kevin [EMAIL

RE: [U2] Open Excel and Import a file or execute a command from a localPC

Tony and Bill... and ya'll... Thanks for the help! It's working... it was the path. :-) - Start your day with Yahoo! - make it your home page --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit

RE: [U2] Trigger creation

Sorry UV 10..1.7 on AIX 5.2.2 Tom Dodds [EMAIL PROTECTED] 630-235-2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, August 01, 2005 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trigger creation -Original

RE: [U2] Trigger creation

I'll let the UV experts speak more to that, but I do believe UV10 was the first that allowed triggers on non-SQL tables. You might check the docs for syntax. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sorry UV 10..1.7 on AIX 5.2.2 ---

Re: [U2] Trigger creation

Tom, The following was provided recently by Geoffrey Mitchell: Date: Thu, 07 Apr 2005 17:34:50 -0500 From: Geoffrey Mitchell [EMAIL PROTECTED] Subject: Re: [U2] UV Triggers The correct syntax should be: CREATE TRIGGER trigger_name [BEFORE | AFTER] UPDATE ON file_name FOR EACH ROW CALLING

RE: [U2] Trigger creation

Tom Yes you can. For the complete syntax, type HELP SQL CREATE TRIGGER at TCL. This gives the argument list for the trigger subroutine. I seem to recall that if you are going to access the file from various accounts, the trigger subroutine needs to be globally cataloged. Brian

RE: [U2] Trigger creation

Thanks for the reply Kevin Tom Dodds [EMAIL PROTECTED] 630-235-2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, August 01, 2005 11:31 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trigger creation I'll let the UV

Re: [U2] PCL Codes taking character positions [UV] {Unclassified} SALES

David, Mike, There seem to be two separate problems here: 1.Printing text with printer control sequences embedded in the text. 2.Printing a job from the HOLD file and retaining it in the HOLD file after it has been printed. The following is a SALES Pitch Universe on NT has no print

Re: [U2] PCL Codes taking character positions [UV]

Thanks, Adrian Louis. I should have remembered about making the line longer to allow for control characters - I do this for CSV files at times. Mike, I do SETPTR mode 3 CAPTURING HOLD.ID, and later on SPOOL HOLD FIELD(HOLD.ID,' ', 2). Can't remember why the FIELD is necessary, but it all works

[U2] Real Trigger vs. Kludgy Trigger via an Index

Before UV supported real file triggers, we used a kludgy way of doing it by creating an index on an i-descriptor dictionary, which then called a BASIC program to do our 'trigger stuff'. Does anyone have any input on what would now be faster? The real trigger or the 'index' trigger? I'm

[U2] [OT?] SATA vs SCSI drives

Somewhat off topic I know, but does anyone have any definitive information re these 2 technologies? Traditionally I've always used SCSI drives, as many years ago we discovered that although the specs if EIDE looked good on paper, in practice they were sub-optimal. Whilst I could do my own tests

Re: [U2] [OT?] SATA vs SCSI drives

Ross, Ross Ferris wrote: Somewhat off topic I know, but does anyone have any definitive information re these 2 technologies? Traditionally I've always used SCSI drives, as many years ago we discovered that although the specs if EIDE looked good on paper, in practice they were sub-optimal. I