Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Posts: 15
Registered: ‎08-15-2013

Creating new Table in Database Manager; get error Invalid field name!

Trying to create a new table and need a field named Type.
When I try to create the field I get an error Invalid Field Name.

How do I create a Table in Database Manager with a Field named Type?

Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Creating new Table in Database Manager; get error Invalid field name!

TYPE is not the only "reserved" name - There are several hundred  -and I know I've run into at least 50 or so ;-)

 

IMHO - You just need to name it something else and then use "Type" as the "alias". 

 

FYI - The only reason you see an OOTB Field names "TYPE" is it was initially created when Saleslogix was not on SQL Server - it was on Interbase  -and was allowed.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html