RE: [U2] select statement with single quotes
It doesn't matter if you follow the guidelines of the US Postal Service. They prefer that all punctuation be removed and that you use all capitalized letters. If you follow those guidelines in storing your data then no conversion is necessary and everybody is happy. -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: Saturday, October 13, 2007 1:01 AM To: u2-users@listserver.u2ug.org Subject: 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] select statement with single quotes
The "`" character has an interesting twist in my travels. Somehow, somewhere in the past, using an apostrophe to bound text in an English statement caused unpredictable results. The Quote (double quote if you're counting) character didn't have those problems. Thus, I ceased using the single quote (apostrophe character) for anything except as a text value, not as a quotation bounding character. The "`" grave character is relegated as text only and in those systems that I see character stripping subroutines, it's removed along with the control characters. The premise was that the purpose of many text fields (as opposed to validated fields) is its LIKE-style lookup later. If the maint program removed them, then the lookups could strip their sought text and make their match. If the correct spelling of RESUME (re-su-may) has the grave character on the last E but it gets stripped, then it's RESUME (re-soom). Words like O'rielly retain their apostrophe though. While there is an increase in foreign character modifiers, aka umlauts, tildes, graves, in today's global communications, they present inconsistent results when searched for later. If the user doesn't include the grave in RESUME, it's a different word and meaning. On the other hand, the accepted spelling of many words with modifiers is without as well. Not many people know of using the keystroke combination to add cuteness to their words. It's like typing an attribute mark. My 2 cents Mark Johnson - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Sunday, October 14, 2007 12:36 PM Subject: Re: [U2] select statement with single quotes > A grave is also a tic isn't it? > > Karl > > > > 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/ > > > > > -- > 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] select statement with single quotes
A grave is also a tic isn't it? Karl > 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/ > -- 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] 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] 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] 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] 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/