Re: [U2] select statement with single quotes
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] 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 > > > 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. > > > - Original Message - > From: "Jerry Banker" <[EMAIL PROTECTED]> > To: > 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 >> >> >> FIX >> 0001 PA >> 0002 FORMAT BP <> >> 0003 ED BP <> >> 0004 HUSH ON >> 0005 DELETE BP.O <> >> 0006 HUSH OFF >> 0007 BASIC BP <> >> >> My 2 bits on this topic. >> >> Karl >> >> >> >> 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 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Over-coming EDitor shortcomings
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. - Original Message - From: "Jerry Banker" <[EMAIL PROTECTED]> To: 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 > > > FIX > 0001 PA > 0002 FORMAT BP <> > 0003 ED BP <> > 0004 HUSH ON > 0005 DELETE BP.O <> > 0006 HUSH OFF > 0007 BASIC BP <> > > My 2 bits on this topic. > > Karl > > > > 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/
RE: [U2] select statement with single quotes
On Fri, 12 Oct 2007, Glen Batchelor wrote: > ... > to the regular typeset curly single quote. Extended ASCII is not represented > in Unicode, so it should not be used for data storage. Huh? What extended ASCII characters are not represented somewhere in Unicode? Or do you mean that characters often shown with hex values between 80 and 9F do not have the same values in Unicode? The latter is true. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: [EMAIL PROTECTED] company e-mail: [EMAIL PROTECTED] voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
` (on the tilde key on US keyboards) is a back-tick and not an apostrophe. Please do not confuse them! In standard ASCII the apostrophe and the single quote are used interchangeably. There is no other character shaped similar to the regular typeset curly single quote. Extended ASCII is not represented in Unicode, so it should not be used for data storage. (heh.. some people mangle the representations and map them accordingly, though) http://www.cs.sfu.ca/~ggbaker/reference/characters/ Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: [EMAIL PROTECTED] Web: http://www.all-spec.com Blog: http://blog.all-spec.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Charles Barouch > Sent: Friday, October 12, 2007 5:49 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] select statement with single quotes > > Kevin, >' vs. ` > Your font may vary your view or what I just typed... > > > Kevin King wrote: > > On 10/12/07, Charlie Rubeor <[EMAIL PROTECTED]> wrote: > > > >> My co-worker, Larry, just pointed out that, technically, you are not > >> supposed to put single quotes in a name or address. You are supposed > to > >> use the apostrophe, which works just fine. So the bug still exists, > but > >> now we can blame the problem on bad data!! > >> > >> > > > > Huh? Are not the single quote and apostrophe the same character? > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > > > > -- > - Charles Barouch >[EMAIL PROTECTED] >Consulting > --- > 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/
RE: [U2] select statement with single quotes
Kevin: Remember, some of us in the technical world live a more isolated existence than others. I used to use typewriters for many years and we used the key next to the [Enter] key as an apostrophe. Little did we know how technically wrong we were. :-) Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King >Sent: Friday, October 12, 2007 1:58 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] select statement with single quotes > >On 10/12/07, Charlie Rubeor <[EMAIL PROTECTED]> wrote: >> >> My co-worker, Larry, just pointed out that, technically, you are not >> supposed to put single quotes in a name or address. You are supposed to >> use the apostrophe, which works just fine. So the bug still exists, but >> now we can blame the problem on bad data!! >> > >Huh? Are not the single quote and apostrophe the same character? >--- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] select statement with single quotes
Kevin, ' vs. ` Your font may vary your view or what I just typed... Kevin King wrote: On 10/12/07, Charlie Rubeor <[EMAIL PROTECTED]> wrote: My co-worker, Larry, just pointed out that, technically, you are not supposed to put single quotes in a name or address. You are supposed to use the apostrophe, which works just fine. So the bug still exists, but now we can blame the problem on bad data!! Huh? Are not the single quote and apostrophe the same character? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- - Charles Barouch [EMAIL PROTECTED] Consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] select statement with single quotes
On 10/12/07, Charlie Rubeor <[EMAIL PROTECTED]> wrote: > > My co-worker, Larry, just pointed out that, technically, you are not > supposed to put single quotes in a name or address. You are supposed to > use the apostrophe, which works just fine. So the bug still exists, but > now we can blame the problem on bad data!! > Huh? Are not the single quote and apostrophe the same character? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
Charlie: One can always write a program to select the records, of course. It's just that there's not a convenient built in SELECT command that seems to work. Using an I-type tied to a subroutine will work (I am in Universe): Write the subroutine FSQ (Find Single Quote): SUBROUTINE FSQ(RESULT,X) IF INDEX(X,"'",1) THEN RESULT = 1 END ELSE RESULT = 0 END RETURN END Compile and catalog this. Now create an I-type in your CUSTFILE DICT, I will call it NQCNT: 0001: I 0002: SUBR('FSQ',@ID) 0003: 0004: 0005: 2R 0006: S 0007: Compile the I-type of course. Then, the command LIST CUSTFILE NAME NQCNT produces: CUSTFILENAMENQCNT 6 JOHN'S RESTAURANT 1 2 HOWARD JOHNSONS 0 3 LOU'S BAR 1 4 STANDARD PLACE 0 5 STARBUCKS 0 You can see that NQCNT is 1 if there is a single quote in the name, so you can select those records with the TCL command: SELECT CUSTFILE WITH NQCNT = 1. Harold Oaks Clark County, WA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Rubeor Sent: Friday, October 12, 2007 11:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes I didn't want to jump the gun and call it a bug, but it certainly looks like one to me. This was just the easiest example to document. If you have a customer with a name of "Lou's Bar and Grill" the following select statement will not select it: SELECT CUSTOMER WITH NAME = "[Lou's]" I tried all of the suggestions that have been posted, with no luck. My current work around is to replace the single quote with the single character wild card, like this: SELECT CUSTOMER WITH NAME = "[Lou^s]" Unfortunately, that also selects any customer with a name of "Louis". -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- "Bill Haskett" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/12/2007 01:40 PM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] select statement with single quotes This bug also exists in UniData! Also, when you get the... Enter to continue... ...question at the end of a page of "missing quote:...'..." errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic "end of page" comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker >Sent: Friday, October 12, 2007 8:30 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] select statement with single quotes > >Have you tried using the LIKE option? > >SELECT CUSTOMER WITH NAME LIKE "...'..." > > >-Original Message- >From: Charlie Rubeor [mailto:[EMAIL PROTECTED] >Sent: Friday, October 12, 2007 10:21 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] select statement with single quotes > >Unidata 6.1, this statement fails. > >:SELECT CUSTOMER WITH NAME = "[']" >missing quote:...'''... >. >. >. > >There are no indices on the file and it is not only related to the >CUSTOMER file. Any filename and field will result in the same error >message. For example, > >SELECT VENDOR WITH ADDRESS = "[']" > >results in the same message. Is this a known issue? More importantly, >is >there an option or setting that I can change to fix it? > >-- >Charlie Rubeor >Senior Database Administrator >Wiremold/Legrand >60 Woodlawn Street >West Hartford, CT 06110 >Tel: 860-233-6251 x3498 >Fax: 860-523-3690 >Email: [EMAIL PROTECTED] >-- >--- >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/ --- 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/
RE: [U2] select statement with single quotes
It is not a bug... from the point of view that the SELECT command is intended to build a list from which to sort... via UniBasic. On the other hand... --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charlie Rubeor Sent: Friday, October 12, 2007 2:56 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes I didn't want to jump the gun and call it a bug, but it certainly looks like one to me. This was just the easiest example to document. If you have a customer with a name of "Lou's Bar and Grill" the following select statement will not select it: SELECT CUSTOMER WITH NAME = "[Lou's]" I tried all of the suggestions that have been posted, with no luck. My current work around is to replace the single quote with the single character wild card, like this: SELECT CUSTOMER WITH NAME = "[Lou^s]" Unfortunately, that also selects any customer with a name of "Louis". -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- "Bill Haskett" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/12/2007 01:40 PM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] select statement with single quotes This bug also exists in UniData! Also, when you get the... Enter to continue... ...question at the end of a page of "missing quote:...'..." errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic "end of page" comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker >Sent: Friday, October 12, 2007 8:30 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] select statement with single quotes > >Have you tried using the LIKE option? > >SELECT CUSTOMER WITH NAME LIKE "...'..." > > >-Original Message- >From: Charlie Rubeor [mailto:[EMAIL PROTECTED] >Sent: Friday, October 12, 2007 10:21 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] select statement with single quotes > >Unidata 6.1, this statement fails. > >:SELECT CUSTOMER WITH NAME = "[']" >missing quote:...'''... >. >. >. > >There are no indices on the file and it is not only related to the >CUSTOMER file. Any filename and field will result in the same error >message. For example, > >SELECT VENDOR WITH ADDRESS = "[']" > >results in the same message. Is this a known issue? More importantly, >is >there an option or setting that I can change to fix it? > >-- >Charlie Rubeor >Senior Database Administrator >Wiremold/Legrand >60 Woodlawn Street >West Hartford, CT 06110 >Tel: 860-233-6251 x3498 >Fax: 860-523-3690 >Email: [EMAIL PROTECTED] >-- >--- >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/ --- 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/
RE: [U2] select statement with single quotes
My co-worker, Larry, just pointed out that, technically, you are not supposed to put single quotes in a name or address. You are supposed to use the apostrophe, which works just fine. So the bug still exists, but now we can blame the problem on bad data!! -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
I didn't want to jump the gun and call it a bug, but it certainly looks like one to me. This was just the easiest example to document. If you have a customer with a name of "Lou's Bar and Grill" the following select statement will not select it: SELECT CUSTOMER WITH NAME = "[Lou's]" I tried all of the suggestions that have been posted, with no luck. My current work around is to replace the single quote with the single character wild card, like this: SELECT CUSTOMER WITH NAME = "[Lou^s]" Unfortunately, that also selects any customer with a name of "Louis". -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- "Bill Haskett" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/12/2007 01:40 PM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] select statement with single quotes This bug also exists in UniData! Also, when you get the... Enter to continue... ...question at the end of a page of "missing quote:...'..." errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic "end of page" comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker >Sent: Friday, October 12, 2007 8:30 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] select statement with single quotes > >Have you tried using the LIKE option? > >SELECT CUSTOMER WITH NAME LIKE "...'..." > > >-Original Message- >From: Charlie Rubeor [mailto:[EMAIL PROTECTED] >Sent: Friday, October 12, 2007 10:21 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] select statement with single quotes > >Unidata 6.1, this statement fails. > >:SELECT CUSTOMER WITH NAME = "[']" >missing quote:...'''... >. >. >. > >There are no indices on the file and it is not only related to the >CUSTOMER file. Any filename and field will result in the same error >message. For example, > >SELECT VENDOR WITH ADDRESS = "[']" > >results in the same message. Is this a known issue? More importantly, >is >there an option or setting that I can change to fix it? > >-- >Charlie Rubeor >Senior Database Administrator >Wiremold/Legrand >60 Woodlawn Street >West Hartford, CT 06110 >Tel: 860-233-6251 x3498 >Fax: 860-523-3690 >Email: [EMAIL PROTECTED] >-- >--- >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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
Try. SELECT filename = \[']\ LEON. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, October 12, 2007 1:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes This bug also exists in UniData! Also, when you get the... Enter to continue... ...question at the end of a page of "missing quote:...'..." errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic "end of page" comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker >Sent: Friday, October 12, 2007 8:30 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] select statement with single quotes > >Have you tried using the LIKE option? > >SELECT CUSTOMER WITH NAME LIKE "...'..." > > >-Original Message- >From: Charlie Rubeor [mailto:[EMAIL PROTECTED] >Sent: Friday, October 12, 2007 10:21 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] select statement with single quotes > >Unidata 6.1, this statement fails. > >:SELECT CUSTOMER WITH NAME = "[']" >missing quote:...'''... >. >. >. > >There are no indices on the file and it is not only related to the >CUSTOMER file. Any filename and field will result in the same error >message. For example, > >SELECT VENDOR WITH ADDRESS = "[']" > >results in the same message. Is this a known issue? More importantly, >is >there an option or setting that I can change to fix it? > >-- >Charlie Rubeor >Senior Database Administrator >Wiremold/Legrand >60 Woodlawn Street >West Hartford, CT 06110 >Tel: 860-233-6251 x3498 >Fax: 860-523-3690 >Email: [EMAIL PROTECTED] >-- >--- >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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
My guess is that a lot of parsing code is written around that sting for control and to change it, the whole world would come to a screeching halt. :-) (that is a smile) Backward compatibility. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, October 12, 2007 10:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes This bug also exists in UniData! Also, when you get the... Enter to continue... ...question at the end of a page of "missing quote:...'..." errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic "end of page" comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker >Sent: Friday, October 12, 2007 8:30 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] select statement with single quotes > >Have you tried using the LIKE option? > >SELECT CUSTOMER WITH NAME LIKE "...'..." > > >-Original Message- >From: Charlie Rubeor [mailto:[EMAIL PROTECTED] >Sent: Friday, October 12, 2007 10:21 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] select statement with single quotes > >Unidata 6.1, this statement fails. > >:SELECT CUSTOMER WITH NAME = "[']" >missing quote:...'''... >. >. >. > >There are no indices on the file and it is not only related to the >CUSTOMER file. Any filename and field will result in the same error >message. For example, > >SELECT VENDOR WITH ADDRESS = "[']" > >results in the same message. Is this a known issue? More importantly, >is >there an option or setting that I can change to fix it? > >-- >Charlie Rubeor >Senior Database Administrator >Wiremold/Legrand >60 Woodlawn Street >West Hartford, CT 06110 >Tel: 860-233-6251 x3498 >Fax: 860-523-3690 >Email: [EMAIL PROTECTED] >-- >--- >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/ __ NOD32 2589 (20071012) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
This bug also exists in UniData! Also, when you get the... Enter to continue... ...question at the end of a page of "missing quote:...'..." errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic "end of page" comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker >Sent: Friday, October 12, 2007 8:30 AM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] select statement with single quotes > >Have you tried using the LIKE option? > >SELECT CUSTOMER WITH NAME LIKE "...'..." > > >-Original Message- >From: Charlie Rubeor [mailto:[EMAIL PROTECTED] >Sent: Friday, October 12, 2007 10:21 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] select statement with single quotes > >Unidata 6.1, this statement fails. > >:SELECT CUSTOMER WITH NAME = "[']" >missing quote:...'''... >. >. >. > >There are no indices on the file and it is not only related to the >CUSTOMER file. Any filename and field will result in the same error >message. For example, > >SELECT VENDOR WITH ADDRESS = "[']" > >results in the same message. Is this a known issue? More importantly, >is >there an option or setting that I can change to fix it? > >-- >Charlie Rubeor >Senior Database Administrator >Wiremold/Legrand >60 Woodlawn Street >West Hartford, CT 06110 >Tel: 860-233-6251 x3498 >Fax: 860-523-3690 >Email: [EMAIL PROTECTED] >-- >--- >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/
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, NJ 07003 tel: 973-748-9000 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Rubeor Sent: Friday, October 12, 2007 12:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] select statement with single quotes Tried it, same result. "Jerry Banker" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/12/2007 11:30 AM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] select statement with single quotes Have you tried using the LIKE option? SELECT CUSTOMER WITH NAME LIKE "...'..." -Original Message- From: Charlie Rubeor [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 10:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] select statement with single quotes Unidata 6.1, this statement fails. :SELECT CUSTOMER WITH NAME = "[']" missing quote:...'''... . . . There are no indices on the file and it is not only related to the CUSTOMER file. Any filename and field will result in the same error message. For example, SELECT VENDOR WITH ADDRESS = "[']" results in the same message. Is this a known issue? More importantly, is there an option or setting that I can change to fix it? -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I *was* Going to the New York U2U Class...
http://ebn.benefitnews.com/asset/article/163509/compliance/new-york-workers- comp-rule-impacts.html This confirms David's research (independently)... I also called the Worker's Compensation Board, and received the same answer as David. Regards, Bob Wyatt Ashwood Computer, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
Try escaping the quote, i.e.: :SELECT CUSTOMER WITH NAME = "[\']" Or: :SELECT CUSTOMER WITH NAME LIKE "...\'..." Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Rubeor Sent: Friday, October 12, 2007 8:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] select statement with single quotes Unidata 6.1, this statement fails. :SELECT CUSTOMER WITH NAME = "[']" missing quote:...'''... . . . There are no indices on the file and it is not only related to the CUSTOMER file. Any filename and field will result in the same error message. For example, SELECT VENDOR WITH ADDRESS = "[']" results in the same message. Is this a known issue? More importantly, is there an option or setting that I can change to fix it? -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- 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/
RE: [U2] select statement with single quotes
Tried it, same result. "Jerry Banker" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/12/2007 11:30 AM Please respond to u2-users@listserver.u2ug.org To cc Subject RE: [U2] select statement with single quotes Have you tried using the LIKE option? SELECT CUSTOMER WITH NAME LIKE "...'..." -Original Message- From: Charlie Rubeor [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 10:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] select statement with single quotes Unidata 6.1, this statement fails. :SELECT CUSTOMER WITH NAME = "[']" missing quote:...'''... . . . There are no indices on the file and it is not only related to the CUSTOMER file. Any filename and field will result in the same error message. For example, SELECT VENDOR WITH ADDRESS = "[']" results in the same message. Is this a known issue? More importantly, is there an option or setting that I can change to fix it? -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- 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/
RE: [U2] I *was* Going to the New York U2U Class...
All I know is what CNA told me and the Albany Workers Comp compliance office told me. If you hear differently from a source that could be an expert witness on this material in a courtroom, let me know! New York would be a better location for me, although I found my airfare to CA will only be $98 each way from Dallas -- WOW. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff > Sent: Friday, October 12, 2007 10:41 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] I *was* Going to the New York U2U Class... > > That's how I'm reading it. You would have to work for 30 > days within a year period for it to apply. So a convention > for 7 days wouldn't apply. > But 5 Conventions for 7 days each would. > > > Jeffrey Lettau > ERP Systems Manager > polkaudio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I *was* Going to the New York U2U Class...
I don't believe this is an appropriate forum for political comment. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Friday, October 12, 2007 8:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I *was* Going to the New York U2U Class... Have they got a definition of what is considered work? Anybody that attends a convention for their company is usually getting paid while there so I guess it would be considered working there. Or, would it? What do you expect from a state that would support Hillary for congress or anything? -Original Message- From: David Wolverton [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 9:49 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I *was* Going to the New York U2U Class... That's why I called -- it appears to be a TERRIBLY written rule/law -- CNA is who notified me of it, and if you read the 'Comp Blogs' it IS causing them to lose business. It wasn't well thought out it appears. As long as you're not 'working' there, you're OK, or if your carrier by default gives you some sort of NY rider. I'd have to add a full policy in my case, or any issue I had there that would be 'Comp-able' would be denied everywhere -- by CNA locally and by New York - both because I didn't have the right coverage. So - not worth the risk or buying a policy since I don't normally have work there anyway. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker > Sent: Friday, October 12, 2007 9:26 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] I *was* Going to the New York U2U Class... > > I think I would recheck that. If it is true that would stop > New York's convention business completely and I don't think > that would be what they would want. --- 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/ __ NOD32 2589 (20071012) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I *was* Going to the New York U2U Class...
That's how I'm reading it. You would have to work for 30 days within a year period for it to apply. So a convention for 7 days wouldn't apply. But 5 Conventions for 7 days each would. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Wyatt Sent: Friday, October 12, 2007 11:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I *was* Going to the New York U2U Class... This is incorrect, per my research... If the convention or conference had a duration of 30 days or more, yes... Please refer to http://www.wcb.state.ny.us/content/main/Small_Business/outOfStateEmp_com pLaw .jsp Regards, Bob Wyatt Ashwood Computer, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Friday, October 12, 2007 10:05 To: u2-users@listserver.u2ug.org Subject: [U2] I *was* Going to the New York U2U Class... But I just found out that if any Employee is 'working' in New York, you have to have a New York Workers Comp policy. This is a new ruling, and I just called Albany compliance (866-298-7830) to find out if attending a conference 'counts' as employment duties/working. And they said "yes". So - I for one will not be able to be attending since I'm not going to add New York Workers Comp to attend a conference! And I thought it should be 'known' that if you are attending as an 'employee' or sending an 'employee', you may want to find out if you need to have a New York Workers Comp policy in place. Hope I can make the California show now!! David W. --- 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/ This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] select statement with single quotes
Have you tried using the LIKE option? SELECT CUSTOMER WITH NAME LIKE "...'..." -Original Message- From: Charlie Rubeor [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 10:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] select statement with single quotes Unidata 6.1, this statement fails. :SELECT CUSTOMER WITH NAME = "[']" missing quote:...'''... . . . There are no indices on the file and it is not only related to the CUSTOMER file. Any filename and field will result in the same error message. For example, SELECT VENDOR WITH ADDRESS = "[']" results in the same message. Is this a known issue? More importantly, is there an option or setting that I can change to fix it? -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- 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] I *was* Going to the New York U2U Class...
My previous post applies to disability insurance, and may not apply to Workers Compensation... Sorry for any confusion this may have caused... Regards, Bob Wyatt Ashwood Computer, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Over-coming EDitor shortcomings
On 10/12/07, Baker Hughes <[EMAIL PROTECTED]> wrote: >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. I think the UV compiler has always removed the original source; which frankly I find to be a major irritant. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] select statement with single quotes
Unidata 6.1, this statement fails. :SELECT CUSTOMER WITH NAME = "[']" missing quote:...'''... . . . There are no indices on the file and it is not only related to the CUSTOMER file. Any filename and field will result in the same error message. For example, SELECT VENDOR WITH ADDRESS = "[']" results in the same message. Is this a known issue? More importantly, is there an option or setting that I can change to fix it? -- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I *was* Going to the New York U2U Class...
Have they got a definition of what is considered work? Anybody that attends a convention for their company is usually getting paid while there so I guess it would be considered working there. Or, would it? What do you expect from a state that would support Hillary for congress or anything? -Original Message- From: David Wolverton [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 9:49 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I *was* Going to the New York U2U Class... That's why I called -- it appears to be a TERRIBLY written rule/law -- CNA is who notified me of it, and if you read the 'Comp Blogs' it IS causing them to lose business. It wasn't well thought out it appears. As long as you're not 'working' there, you're OK, or if your carrier by default gives you some sort of NY rider. I'd have to add a full policy in my case, or any issue I had there that would be 'Comp-able' would be denied everywhere -- by CNA locally and by New York - both because I didn't have the right coverage. So - not worth the risk or buying a policy since I don't normally have work there anyway. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker > Sent: Friday, October 12, 2007 9:26 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] I *was* Going to the New York U2U Class... > > I think I would recheck that. If it is true that would stop > New York's convention business completely and I don't think > that would be what they would want. --- 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/
RE: [U2] I *was* Going to the New York U2U Class...
This is incorrect, per my research... If the convention or conference had a duration of 30 days or more, yes... Please refer to http://www.wcb.state.ny.us/content/main/Small_Business/outOfStateEmp_compLaw .jsp Regards, Bob Wyatt Ashwood Computer, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Friday, October 12, 2007 10:05 To: u2-users@listserver.u2ug.org Subject: [U2] I *was* Going to the New York U2U Class... But I just found out that if any Employee is 'working' in New York, you have to have a New York Workers Comp policy. This is a new ruling, and I just called Albany compliance (866-298-7830) to find out if attending a conference 'counts' as employment duties/working. And they said "yes". So - I for one will not be able to be attending since I'm not going to add New York Workers Comp to attend a conference! And I thought it should be 'known' that if you are attending as an 'employee' or sending an 'employee', you may want to find out if you need to have a New York Workers Comp policy in place. Hope I can make the California show now!! David W. --- 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/
RE: [U2] I *was* Going to the New York U2U Class...
Comp covers injuries while working. If you were hurt in an accident from the airport to the conference, since you were only there for work, it is likely a Worker Comp claim that would pay the medical bills. You personal insurance would likely deny the claim since it 'happened in the course of work duties' unless you have personal riders to fix that. Call your insurance agent for 'real' information - I just know what I hear... And you can't trust 50% of that!! My whole reason for the post - you need to make sure ducks are in a row with whoever watches your ducks! (And only if you care -- if you're happy-go-lucky none of this matters anyway!! ) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Brutzman, Bill > Sent: Friday, October 12, 2007 9:35 AM > To: 'u2-users@listserver.u2ug.org' > Subject: RE: [U2] I *was* Going to the New York U2U Class... > > What is "Workers Comp"? > > Is it like insurance for like falling off of a ladder at a company? > > Or is it, the company has to pay you to go? > > Or, you need to pay for a permit? > > Please advise. > > --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [U2C] New poll for Texas area
Still trolling for Multi-Value people in TEXas or adjacent states I trust our other colleagues will view our efforts beneficently and rejoice at the activity among local user groups. Warm regards, -Baker TEXMUG Moderator --- Enter your vote today! A new poll has been created for the texas_mug group: What Multi-Value platforms have you become proficient on? Check all those that you have supported or developed on. Please do not limit your response to current involvements. We'd like to know your whole historical picture. (Some of the earlier MV implementations are still in use so you're not showing your age necessarily). Responses to this poll are anonymous, like the last one. In the next poll we'll ask for total years in Multi-Value. o OpenQM / QM from Ladybridge o Cache' from InterSystems o Arev / Revelation o OpenInsight / JOI o Pick R83 o GA R91 or Power95 o AP/PRO or Advanced Pick o D3 (any ver.) o Adds Mentor / Mentor Pro o jBase o GA Zebra or other GA not listed o mvBase o mvEnterprise / mvPro o MaVerick o Sequoia / SeqPro o Ultimate / UltPlus o UniVision (Via Systems) o Honeywell running any Pick db o Siemens Nixdorf o Fujitsu running any Pick db o Prime Information or PI/Open o Reality - any native on McD hardware o Realityx (on any Winx or *nix) o UniVerse (any ver.) o UniData (any ver.) To vote, please visit the following web page: http://groups.yahoo.com/group/texas_mug/surveys?id=2280264 Note: Please do not reply to this message. Poll votes are not collected via email. To vote, you must go to the Yahoo! Groups web site listed above. Thanks! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I *was* Going to the New York U2U Class...
That's why I called -- it appears to be a TERRIBLY written rule/law -- CNA is who notified me of it, and if you read the 'Comp Blogs' it IS causing them to lose business. It wasn't well thought out it appears. As long as you're not 'working' there, you're OK, or if your carrier by default gives you some sort of NY rider. I'd have to add a full policy in my case, or any issue I had there that would be 'Comp-able' would be denied everywhere -- by CNA locally and by New York - both because I didn't have the right coverage. So - not worth the risk or buying a policy since I don't normally have work there anyway. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker > Sent: Friday, October 12, 2007 9:26 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] I *was* Going to the New York U2U Class... > > I think I would recheck that. If it is true that would stop > New York's convention business completely and I don't think > that would be what they would want. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I *was* Going to the New York U2U Class...
What is "Workers Comp"? Is it like insurance for like falling off of a ladder at a company? Or is it, the company has to pay you to go? Or, you need to pay for a permit? Please advise. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Wolverton Sent: Friday, October 12, 2007 10:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] I *was* Going to the New York U2U Class... But I just found out that if any Employee is 'working' in New York, you have to have a New York Workers Comp policy. This is a new ruling, and I just called Albany compliance (866-298-7830) to find out if attending a conference 'counts' as employment duties/working. And they said "yes". So - I for one will not be able to be attending since I'm not going to add New York Workers Comp to attend a conference! And I thought it should be 'known' that if you are attending as an 'employee' or sending an 'employee', you may want to find out if you need to have a New York Workers Comp policy in place. Hope I can make the California show now!! David W. --- 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/
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 FIX 0001 PA 0002 FORMAT BP <> 0003 ED BP <> 0004 HUSH ON 0005 DELETE BP.O <> 0006 HUSH OFF 0007 BASIC BP <> My 2 bits on this topic. Karl 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/
RE: [U2] I *was* Going to the New York U2U Class...
I think I would recheck that. If it is true that would stop New York's convention business completely and I don't think that would be what they would want. -Original Message- From: David Wolverton [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 9:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] I *was* Going to the New York U2U Class... But I just found out that if any Employee is 'working' in New York, you have to have a New York Workers Comp policy. This is a new ruling, and I just called Albany compliance (866-298-7830) to find out if attending a conference 'counts' as employment duties/working. And they said "yes". So - I for one will not be able to be attending since I'm not going to add New York Workers Comp to attend a conference! And I thought it should be 'known' that if you are attending as an 'employee' or sending an 'employee', you may want to find out if you need to have a New York Workers Comp policy in place. Hope I can make the California show now!! David W. --- 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] I *was* Going to the New York U2U Class...
But I just found out that if any Employee is 'working' in New York, you have to have a New York Workers Comp policy. This is a new ruling, and I just called Albany compliance (866-298-7830) to find out if attending a conference 'counts' as employment duties/working. And they said "yes". So - I for one will not be able to be attending since I'm not going to add New York Workers Comp to attend a conference! And I thought it should be 'known' that if you are attending as an 'employee' or sending an 'employee', you may want to find out if you need to have a New York Workers Comp policy in place. Hope I can make the California show now!! David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Over-coming EDitor shortcomings
FIX 0001 PA 0002 FORMAT BP <> 0003 ED BP <> 0004 HUSH ON 0005 DELETE BP.O <> 0006 HUSH OFF 0007 BASIC BP <> My 2 bits on this topic. Karl 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/
RE: [U2] [UV] Using VI instead of ED for EDIT-LIST [not-secure]
:q! Thats a command not a smiley :) Allen E. Elwood wrote: > Ya, believe it or not, there are people like *me* for instance that if > they found themselves in VI would have to say a few choice words and > then look up how to get out...:) Actually, that's often the look on my face after executing that command! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/