I created metadata over a a "set" of files.
My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database.
Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error message. I was able to determine that this is attributed to certain field names in the file beginning with special characters such as @, or $ which evidently SQL can not handle.
So, my question is, does anyone have a work around, or, do I need to rename all my fields in the relational database prior to creating the metadata ?
Thank you for your feedback.
October 10, 2008 8:30 PM
October 13, 2008 9:23 PM