Re: [U2] UV and triggers

I will still stand by my statement. I have seen code written as the top level program, where a STOP or RETURN would both terminate the program cleanly. But later, a "big brother" program gets written that will then need to CALL the original program. If the original subroutine was written with

Re: [U2] Converting from mvBase to Universe

Hi Curt, Two additional thoughts on converting software from mvBase to Universe: 1.Port numbers are assigned randomly (I think) by Universe at the time of logon. I am not aware of any means to lock any particular user into any particular port number. Maybe someone else knows a trick tha

Re: [U2] Converting from mvBase to Universe

We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of syste

Re: [U2] Fw: COMMON misMatch

Thanks to Don and Jacques. I cranked CLEARCOMMON into LOGIN and will reCompile the HOP program. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of don_baus...@hcsc.net Sent: Thursday, July 16, 2009 10:17 AM To

Re: [U2] Converting from mvBase to Universe

If your code uses the U50BB user exit to get the port number, there is a quick fix, but it will make upgrades a little more complicated. 50BB is a basic program in the APP.PROGS file in the UV account. You can modify it to send port information based on user login or other criteria. I send infor

Re: [U2] Converting from mvBase to Universe

Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Mo

Re: [U2] Converting from mvBase to Universe

I'm not sure what you're asking, Jerry, but this may help. The SP-ASSIGN commands differ in syntax between the generic Pick print spooler and the Reality spooler, as follows: Ex. (Pick® syntax): SP-ASSIGN (options) (copies) F(queuenumber), R(printfilenumber) Ex. (Reality® syntax): SP-ASSIGN

Re: [U2] Converting from mvBase to Universe

Hi Dianne, Writing an SP-ASSIGN command to create a SETPTR command is certainly possible, lot of people have done it, but that only send print jobs to printers, not to print queues. It doesn't provide the functionality of a generic Pick print spooler and support for all the spooler architec

Re: [U2] Converting from mvBase to Universe

That one is probably SP.ASSIGN - when you use the dash in your command, uv looks first for an entry in the VOC with the dash and if it can't find one, it looks for it with the dot instead. That one does come with uv. -Dianne jpb-u2ug wrote: Is the SP-ASSIGN command that different in UV or is

Re: [U2] UV and triggers

John, there is another MV-world out there - not just U2, and in that world a subroutine is a subroutine and ends with a RETURN and a program is a program and ends with a STOP and/or END statement. This is not only true for jbase this applies to D3 and other MV-databases as well. If you run a pro

[U2] D-Descriptors + SQL

I am able to do the ODBC wizard from Excel but a lot of the dictionary items are not showing up. Do I need to specify something in field 8 of the dictionary and then recompile or something? Help would be appreciated. --Bill ___ U2-Users mailing list U

Re: [U2] D-Descriptors + SQL

Create a 'PA' record in the dictionary of your file with a space separated list of fieldnames you want to access Brutzman, Bill wrote: I am able to do the ODBC wizard from Excel but a lot of the dictionary items are not showing up. Do I need to specify something in field 8 of the dictionary an

Re: [U2] D-Descriptors + SQL

Oh... and call it @SELECT Brutzman, Bill wrote: I am able to do the ODBC wizard from Excel but a lot of the dictionary items are not showing up. Do I need to specify something in field 8 of the dictionary and then recompile or something? Help would be appreciated. --Bill _

Re: [U2] Converting from mvBase to Universe

I'm sorry if I wasn't clear. After looking at what I wrote I can see why but I think you answered my question. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: Monday, July 20, 2009 12:

Re: [U2] D-Descriptors + SQL

Jeff: Thanks for writing. I cranked it in without luck. I reRan... HS.SCRUB IM AUTOFIX DICT DATA The fields that I am trying to get are single-valued. We are on UniVerse 10.1. Although I am using Excel 2000, my boss is getting similar results with Excel 2007 >ED DICT IM @SELECT 1 lines long.

Re: [U2] D-Descriptors + SQL

Victory... Thanks Jeff. Thanks again to Garry Smith (who responded off-list). --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Monday, July 20, 2009 2:25 PM To: U2 Users List Subject: Re:

Re: [U2] UV and triggers

Thanks, Mecki. You expressed the thoughts I was trying to get across very eloquently. We can thank Jim Idle for making Jbase as "fussy" as it is. I believe his opinion was that if it didn't fit the model (and especially if it didn't make sense), it should not be allowed, no matter how loose Uni