RE: Apostrophe in field name?

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

I just got word from the customer, I misunderstood.  The data contained an
apostrophe, not the field name.  (language barrier does that sometimes.)

Thanks for everyone's help, though!

> -----Original Message-----
> From: Simone Pacciarini [mailto:spacciarini@yahoo.com]
> Sent: Monday, May 14, 2001 12:42 PM
> To: RPG400-L@midrange.com
> Subject: RE: Apostrophe in field name?
> 
> 
> Buck,
> 
> I'm italian and I've never seen in any italian made
> software a field name containing the apostrophe.
> That's really awful.
> Anyway località means city, location.
> 
> 
> 
> --- Buck Calabro <Buck.Calabro@commsoft.net> wrote:
> > Brad wrote:
> > >One of my customers just explained to me that they
> > have the apostrophe
> > >character in a field name.
> > >
> > >For example,
> > >
> > >C              eval   LOCALITA' = 'NEW YORK'
> > >
> > >The field LOCALITA'.  I didn't know this was
> > possible.  Anyone else seen
> > >this?  Is there anything on a system that will tell
> > me when this is
> > >possible?
> > 
> > Sort of.
> > I don't know if this is Italian or Spanish and they
> > really mean Á (accented
> > A) but Both of these SQL statements create a file
> > with a "non-standard"
> > column name:
> > 
> > CREATE TABLE TICK ("LOCALITÁ" CHAR (30) NOT NULL
> > WITH 
> > DEFAULT)                                            
> >        
> > 
> > CREATE TABLE TICK ("LOCALITA'" CHAR (30) NOT NULL
> > WITH 
> > DEFAULT)                                            
> >        
> > 
> > Buck Calabro
> > Commsoft; Albany, NY
> > "Nothing is so firmly believed as
> >  that which we least know" -- Michel Montaigne
> > Visit the Midrange archives at
> > http://www.midrange.com
> > +---
> > | This is the RPG/400 Mailing List!
> > | To submit a new message, send your mail to
> > RPG400-L@midrange.com.
> > | To subscribe to this list send email to
> > RPG400-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > RPG400-L-UNSUB@midrange.com.
> > | Questions should be directed to the list
> > owner/operator: david@midrange.com
> > +---
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---