2025-01-31 17:45:55
Topic starter
Notifications
Clear all
0
I am currently trying to insert a record into a model and am receiving the error "Column does not exist on table". I have checked the database schema and in this example, the column "TITLE" does exist within the HPEC_BOOK table. Why am I receiving this error even though the column exists?
I have also tried building the module and it has not fixed the issue.
This topic was modified 5 hours ago by jcourter
1 Answer
0
2025-01-31 17:47:55
Topic starter
This can happen if the DAO object wasn't regenerated after the attribute was added. This means the database was updated to include the column, but the DAO object did not get created.
The solution to solve the issue is to make a change to your model, in this example HPEC.Book, then build the module. Because we have edited the model, when you next build the module, it will generate a new DAO object, which should solve the issue.
This post was modified 5 hours ago by jcourter
