Premiere Ticket other Questions...

Thank You very much Jason. Accept my humble gratitude to you. You always give me a

clear direction regarding my Capstone Project. :) I don't have any regret to join this

community. All the engineers in WA are very genius and very supportive to their fellow

customers. Keep it Up.

  The section, school year and semester columns can be indexes in the table, but they will not be the primary key.  

1.) So If I set the the section, school year and semester columns to indexes. What is the

purpose of that indexes.

  classID - Primary Key, auto increment
classSection - text
classYear - text
classSemester  

2.) If I set the datatype of the classSection,classYear,and classSemester to Datatype:TEXT and when I set it those column to index this error occur

ERROR: Error 1170: BLOB/TEXT column 'secSectionCode' used in key specification without a key length

3.) What can you suggest of datatype if I will set those column into Indexes.



-------------------------------------------------------
Thanks in Advanced Again ...