Re: [U2] select statement with single quotes

2007-10-13 Thread Kevin King
Glen pretty well made my point.  The ` is a grave, not an apostrophe.  Bill,
I'm not sure what exactly you mean; technically the ' is the apostrophe AND
also single quote.   In fact, apostrophe is the proper name, single quote is
merely convenient vernacular.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UV and TIMESTAMP SQL type

2007-10-13 Thread Ray Wurlod
UniVerse does not have a TIMESTAMP data type.  However, because the ISO 8601 
standard requires -MM-DD HH:MM:SS format, you can treat these as CHAR(19) 
and they will select and sort correctly.  If you need milliseconds, specify 
CHAR(23).  If you need microseconds (which UniVerse itself can not generate), 
specify CHAR(26).
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Over-coming EDitor shortcomings

2007-10-13 Thread Bertrand, Ron
Do not know about Unidata but you can get to any unix directory/file with 
pointers in Universe. Then you can use either ED or WED and so on. I have to 
admit to being spoiled by accuterms WED.
 
Ron Bertrand
Group Health
LIS/ISD



From: [EMAIL PROTECTED] on behalf of [EMAIL PROTECTED]
Sent: Fri 10/12/2007 9:30 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Over-coming EDitor shortcomings



So, what good is that for those of us who live on Unix/Linux and don't
have the option of running Accuterm?

I use gvim, which has pretty good syntax highlighting,
copy/move/find-replace, etc. I prefer it to ED. I've never used AE.

I guess it's time to do some experimenting with other technologies.

OH, and just for fun, consider this: I write my HTML code with gvim or
vim, period...

Old School or just stubborn? hmmm.

Karl

quote who=MAJ Programming
 Shameless plug for Accuterm

 If you haven't used WED, their Windows EDitor, you're missing a ton of
 helpful editor stuff. All of the shortcuts and command-line tricks pale by
 comparison.

 Funny, how everybody talks about the latest XYZ alphabetic technologies
 yet
 still use an editor barely better than vi or EDLIN. And don't let your
 years
 of experience sway you to protecting that fingertip editor. I've been
 using
 the regular EDIT, AE or vi coming up on 30 years and WED blows them all
 away. (this ain't a contest)

 WED alone without their graphical developer tools (GED) or their powerful
 emulator is worth the price. Accuterm is truly one of the best bargains in
 the MV world.

 /Shameless plug for Accuterm
 - Original Message -
 From: Jerry Banker [EMAIL PROTECTED]
 To: u2-users@listserver.u2ug.org
 Sent: Friday, October 12, 2007 10:21 AM
 Subject: RE: [U2] Over-coming EDitor shortcomings


 I created a pre-store, a few years back, that does something similar
 thing in the regular editor. I think we were still on UV 7.4 at the
 time.
 ED ED FIB
 6 lines long.

 : P
 0001: EPre-stored Command saved at 16:50:53 24 JUN 1998
 0002: FORMAT
 0003: SAVE
 0004: XEQ DECATALOG @FILE @ID
 0005: XEQ BASIC @FILE @ID
 0006: XEQ CATALOG @FILE @ID
 Bottom at line 6.

 So when in the regular editor all you have to do is type in: .X FIB
 Which is a few more key strokes but less than all of the commands.
 I didn't want to do the run because most of the development at the time
 was done on a live system. But you could add: XEQ @FILE @ID or XEQ @ID
 after the last line and save it as FIBR to do as you are doing.
 Jerry

 -Original Message-
 From: Baker Hughes [mailto:[EMAIL PROTECTED]
 Sent: Friday, October 12, 2007 8:40 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] Over-coming EDitor shortcomings

 /snip
  FIX
 0001 PA
 0002 FORMAT BP I2,Enter BP item
 0003 ED BP I2,Enter BP item
 0004 HUSH ON
 0005 DELETE BP.O I2,Enter BP item
 0006 HUSH OFF
 0007 BASIC BP I2,Enter BP item

 My 2 bits on this topic.

 Karl

 snip\

 Which is why I like the AE [alternate] editor.

 Once you've executed a format command in your logon session, you simply
 type 'FOR' at any time the rest of the day, in any edit session, to
 format with the same parameters.

 FOR -I3 -M3 [Indention of 3, margin of 3]

 BTW, If you're chasing a pesky bug that's hidden in a 14 tier nested
 LOOP,IF,CASE,Whatever then use this:
 'FOR -TRACE'  it will put pipes in for you where we used to draw lines
 with our ruler to trace the logical flow.

 Then when your done and want to compile:

 'FIBR' will file it, compile it, and run it [don't get to habitual with
 the 'R' if your in a sub].

 The AE invoked compiler removes the old source when it starts, that way
 if the compile produces no object, it doesn't run the old object code.
 At least this is the behavior on UV 10 or higher.


 356:
 357:IF HOLD # '' AND NOT(ALARM) THEN
 *--: FOR -I3 -M3
 Margin=3, Indentation=3, -incase
 !!
 *--: FOR
 Margin=3, Indentation=3, -incase
 !!
 *--: FIB
 Filed DOE.WRITE.SUB.F1675 in file BHB.
 Compiling: Source = '/system1/dev.programs/BHB/DOE.WRITE.SUB.F1675',
 Object = '/system1/dev.programs/BHB.O/DOE.WRITE.SUB.F1675'
 
 ***
 000671

 Compilation Complete.

 Of course, you could stack the FORmat command and the FIBR command into
 a saved prestore that you recall when you begin your edit session, but
 that's another subject.

 FWIW,
 -Baker
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/



--
Karl Pearson
Director of I.T.
ATS Industrial Supply, Inc.
[EMAIL PROTECTED]
http://www.atsindustrial.com http://www.atsindustrial.com/ 
800-789-9300 x29
Local: 801-978-4429

RE: [U2] Over-coming EDitor shortcomings

2007-10-13 Thread Allen E. Elwood
Hey Mark, I took it to mean he's running Linux on his PC

I'm thinking of setting up a Linux boot drive on my PC for a potential gig
I've got coming up.  From what I've been reading, it's a nice product.

I love AccuTerm too, great product.  I tried to get Peter to make a TED,
which would be like WED but a TCL Manager instead.  No word on that yet.

*=aee=*

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of MAJ Programming
Sent: Saturday, October 13, 2007 08:01
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Over-coming EDitor shortcomings


Peter Schellenbach is too smart to not allow Accuterm to work on Unix/Linux
(UD/UV). I checked their website www.asent.com to see if the platforms were
represented but didn't see them. I know that it works on UV/Unix and D3/NT
and Mvbase/NT, and UV/SCO. Microdata and most natives will be too slow for
WED.

If you connect to the MV database with COM1 or telnet or SSH then you're
covered. Lotsa times software like this has an environment variable or
installation choice that decides which MV it's connected to. For WED it may
not mattter as much so it's wide open. GED and the subroutines may be more
picky although I don't know how different it may be.

It's a great, all-in-one package...Windows Editing, Graphical designer for
Data/Basic and great emulator. Plus at $20 per seat vs $200 for other
emulators, it's practically free.

My free cents.
Mark Johnson
- Original Message -
From: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Saturday, October 13, 2007 12:30 AM
Subject: Re: [U2] Over-coming EDitor shortcomings


 So, what good is that for those of us who live on Unix/Linux and don't
 have the option of running Accuterm?

snip
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/