Wayne, if you are using FileMaker, get the xDBC guide from the FMI site. It *has* the list of reserved words. As others stated, it may depend on the database and even on the ODBC driver. If in doubt, I append something to the word:
table ==>> table_name_field (or something like that...) Sometimes you can get away with using a reserved word by quoting the string. But I don't bank on that! Beverly "still in Corbin" Voth On 13 Mar 2011, at 7:42 PM, Robert Shubert wrote: > Wayne, > > Doing a couple of Google searches came up with this: > > http://www.filemaker.com/help/html/create_db.8.7.html#1043324 > > And this: > > http://developer.postgresql.org/pgdocs/postgres/sql-keywords-appendix.html > > The second link is from Postgre, but the important column is the > last one, SQL-92, as these words are almost certainly reserved in > all implementations of ODBC and JDBC, regardless of the DBMS > manufacturer. > > Robert > > -----Original Message----- > From: Wayne Irvine [mailto:[email protected]] > Sent: Sunday, March 13, 2011 7:34 PM > To: [email protected] > Subject: Witango-Talk: Reserved words > > We need to compile a list of reserved words that can't be used for > table or field names. > > I just made a db with a table called 'Table' (the default in FMP) > and two fields 'Date' and 'Time'. It wasn't until I changed all > these namesthat I got it working. > > Wayne Irvine > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. > ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
