Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Gemini 5.1 Creating SQL drop list custom fields

custom-fields

I am having issues with creating custom droplist fields in Gemini (v5.1.1.3564). The database I am using is the empty database that was provided with Gemini. I can create the custom droplist attribute against a template using the SQL driven option, but when I click on the setting (cogged wheel) icon to enter the drop list values, nothing happens on the screen. In the system log table I am seeing "Invalid object name" errors being logging each time I click on the setting icon. I believe this is occurring because the table for the attribute has not been created in the database. This error is not occuring in our current version of Gemini (v4.2.1 build 3250).

Thanks Terry
User92097
· 1 		User92097
Wednesday, October 10, 2012, 2:37:01 AM
Replies (4)
helpful
0
not helpful

You need to have that table in the V5 database, did you create it?
Mark Wing
· 9108 		Mark Wing
Wednesday, October 10, 2012, 10:27:58 AM
helpful
0
not helpful

Mark, I did not manually create the tables. Gemini v4 automatically creates the tables in the database for custom listbox fields when the "SQL Driven" and "Create Table in SQL" options are selected. Performing the same steps in Gemini v5 does not result in the table being created in the database. At the moment it seems that SQL driven custom list fields have to have the associated table manually created in the database. Alternatively I have to have use the static listbox option.

Regards, Terry
User92097
· 1 		User92097
Thursday, October 11, 2012, 12:24:47 AM
helpful
0
not helpful

There should be created when you create the custom field. They won't be if the custom field is already there.
Mark Wing
· 9108 		Mark Wing
Thursday, October 11, 2012, 8:58:01 AM
helpful
0
not helpful

Mark, when I create the custom droplist field in v5, the associated tables are not being created by Gemini. I believe it is a bug that will need to be addressed in future release. At the moment I am getting around it this by defining them as either static or by manually creating the tables in the database.
User92097
· 1 		User92097
Thursday, October 11, 2012, 9:05:14 AM