Subject Re: field 'value' From Mervyn Bick <invalid@invalid.invalid> Date Thu, 21 Apr 2022 11:06:20 +0200 Newsgroups dbase.getting-started On 2022/04/21 00:22, Charlie wrote: > I have a field named value.  could someone confirm whether that is a legal field name in dbase?  I have a feeling it isn't as there is some funky stuff going on. There's a list of reserved words in the help file and yes, "value" is in the list. As has been pointed out, using reserved words as field names is not a good idea and you should consider Lee's idea and rename the field.  This does, of course, mean that you will also need to revise any code that accesses the field. The reserved words are words that SQL uses.  The old XDML had no problem with using reserved words as fieldnames when USE opened a table in a workarea.  The new OODML uses localSQL to access query objects and this is where the problems arise. That said, it is usually possible to get around the problems caused by using a reserved word as a fieldname.  If you feel that changing the fieldname is going to be too much work give us details of what is causing problems. Mervyn.