I have problem in mysql TEMPORARY table. i am creating a table and indexes for a temporary table through program. and after that i am opening the table through table component (in Delphi)and in the table component i have specified the indexname property with proper index name,at that time i get an error as ‘Table is not indexed’. if i don’t specify the index name in the property then i don’t get any error.
Can somebody help me in this regard? i don’t have problem with normal table in mysql, only i have problems with temporary table.
to fix this problem what should i do? should i need to do something in coding or something while creating index or temporary table? kindly help me in this regard