Table_id VARCHAR?

Open dlogan opened this issue 12 years ago • 2 comments

From this Forum post: http://cellprofiler.org/forum/viewtopic.php?f=12&t=1782&p=9274#p9274

He had table_id as CHAR and CPA seems to have expected INT. Needs verification, It should be VARCHAR, and/or documented.

May 09 '13 21:05 dlogan

By table_id, are you refering to the table_id property in the properties file, which we typically map to the TableNumber database column? If so then it has to be an integer, just like image_id and object_id.

@dlogan, can you please (1) document that these have to be integers and (2) check to see how the software responds when one of the maps to a non-integer column? We may have to put in a check so the software can complain intelligently.

May 10 '13 18:05 ljosa

Yes, I assume the forum user meant TableNumber. OK, that's fine that it has to be integer. And yes, I will do these.

May 10 '13 19:05 dlogan