Re: [U2] Uppercasing in SELECT

My best way UNIDATA: SELECT PERSON WITH SORT.NAME LIKE '...SMITH...JOHN...' '...JOHN...' SORT.NAME: TRIM(UPCASE(((LAST.NAME:FIRST.NAME):MIDDLE.NAME))) OR xResult1 = ((vLastName : vFirstName : vMiddleName)).ToUppercase().Trim(); return (string)xResult1;

Re: [U2] How many will be selected?

If he was using SELECT statement which thus using READNEXT, this puts you in a save-list mode, does @SYSTEM.RETURN.CODE work for Universe? I use it a lot in Unidata processes. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] Trans() to a subroutine I descriptor

Is there the ID of GM.SHF in GM.GMF file? If so then you could used: ED DICT GM.GMF TURNS This Type I Descriptor must be compiled before use. 14 lines long. : P7 0001: I 0002: SUBR('*CALC.TURNS',GMF.SHF.ID) 0003: 0004: TURNS 0005: 7R 0006: S 0007: Also, stated in another reply, you cannot

RE: [U2] default sort order

I see that you can edit DICT.DICT with some response on this but you can do like I do here: :AE VOC DW.DICT Top of DW.DICT in VOC, 3 lines, 616 characters. 001: PA 002: * David Wademan custom DICT lookup for 132 character mode * 003: LIST DICT I2,FILENAME ID.SUP DBL.SPC @ID FMT 32L TYP LOC FMT

RE: [U2] How do you do a NOPAGE on a SELECT?

I know in UD that I can use: UDT.OPTIONS 55 ON Not sure about UV. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, April 24, 2009 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] How do

RE: [U2] Counting records

SIMPLE CODE FOR COUNTING RECORDS (IN UNIDATA) :AE DAVID COUNT3 PROGRAM COUNT3 PERFORM COUNT STUDENTS NUM.RECS = @SYSTEM.RETURN.CODE PRINT PRINT NUMBER OF RECORDS: :NUM.RECS *--: FIBR Filed COUNT3 in file DAVID. Compiling Unibasic: oisdir/david/COUNT3 in mode 'u'. compilation finished COUNT

RE: [U2] UD: Unidata Help Function

this happen or this is something that Unidata is doing? David Wademan _ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users

[U2] UD: Unidata Help Function

In the past that we can used HELP at the colon prompt to get information about UniQuery or UniBASIC functions. Once we switch over from 6.x to 7.1.8 and now we lost the HELP function. Any ideas why this happen or this is something that Unidata is doing? David Wademan Senior DB Programmer

RE: [U2] Data Editor

As a UniData client using wIntegrate there a program and VOC for WIN.EDIT (wIntegrate editor) Ex: :WIN.EDIT DIRECTORY RECORDNAME Here it has the goodies for editing, re-ftping back to the server, compiling, cataloging. Also other goodies in there that might be useful to you (as per post below

RE: [U2] Basic SORT() Function not avail in UniVerse?

- From: DAVID WADEMAN [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, July 22, 2008 12:59 PM Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? This is a UniData subroutine, but should work SUBROUTINE B42.SORT.ARRAY(SORTED,ARRAY) * Bubble sort

RE: [U2] Converting 32bit files to 64bit

I am a UniData client so I am not sure with Universe We had to convert our Alpha system to HP-UX 64 and there was a utility in $UDTBIN call convdata. But, if you can do a FILE.STAT on a file, and there is no errors, then the file was converted. -Original Message- From: [EMAIL

RE: [U2] Uppercase

Can you download the code and use other windows software to do this, then upload the code back? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Tuesday, April 08, 2008 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] Uppercase

RE: [U2] Graphic Printing

We used UniData and we used postscript(pcl) codes in our programming where then the printer then interrupts that character as a graphic and prints as so [CHAR(x)]. We used this for our checks were our logo, and signed name is printed on blank checks and the data is also writing to the check as

RE: [U2] UniData to UniVerse Translation??

values meet the selection_criteria. Note: UniQuery supports the EVERY keyword in ECLTYPE U only. In ECLTYPE P, use the EACH keyword. Bloomfield College David Wademan Senior DB Programmer / System Analyst [EMAIL PROTECTED] 467

RE: [U2] select statement with single quotes

You can try adding an VF that says: COUNT(NAME,') To see if that works then do: SELECT VENDOR WITH XTEST GT 0 Bloomfield College David Wademan Senior DB Programmer / System Analyst [EMAIL PROTECTED] 467 Franklin Street ITS- Knox Hall 3rd Fl. Bloomfield