I hcnaged a column name: DiseaseID -> ID in SQLite
I also changed the name in SQL clause, but when I run my GRID App it generates an error based on old column name (saying DiseaseID does not exist).
Look like SC7.1 is not refre3shing the SQL changes. I think I have had a problem with this also in SC6
See images
Any ideas ?
Arthur
If you alter the table and you have changed the sql you need to save first. Then the fieldlist will update. Something might have been gone wrong here and you might want to retry. In grids things needs to be done manually.
I can confirm that it is important …
I know I need to change this manually, in grid and that’s what I did, but for some reason SC keeps the old SQL script.
I tired to clean browser cache, and even restart Pc, it did not help. I remember I have had those problems in the past, but then I thought I’m doing something wrong. This isn’t really a rocket science and doing something wrong here is very unlikely. I noticed SC has lots of problems with changes in the projects. While initial procedures in most cases work fine, when one wants to go back and do some changes there are cases when SC does not respond well. Another exaple of this is DICTIONARY.
I hope I would not have to recreate all Apps just because I switched from MySQL to SQLite. BTW. I used SQLite PDO (not sure if straight SQLite might make any difference).
Any ideas to fix this ?
Arthur
Hello Arthur,
If you have done the steps Albert said, you could try to delete the generated app under ScriptCase folder.
regards,
Bernhard Bernsmann