read-only table is created

  • I use "select * into temp from aTable" to create a temp table, open it in Analyze and find it is read-only. Why and how to fix this table to be not a read-only table.

    Thank you in advance.

  • Ther has been a known issue with using SELECT INTO into temp tables with regular SQL and may apply here. Try Create Table for the temp table then use INSERT INTO and see what happens.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply