I made some changes to my solution that modfied the backend. I dropped the tables that were modified on the machine I was importing onto. Then I imported the solution in hopes that it would rebuild the tables. Instead I got an error message that it couldn’t do this because thier was no such table. I made the table with the primary key but no other columns and imported again. This time it added a few columns but didn’t complete the table. So I then imported it via the developer and it worked. I have used the web interface for many imports and not had problems in the past, so this may be a new issue.
John McCann
Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2_06-b03 (Windows 2003)
One big ‘heads up’ on letting Servoy create your tables for you is that Servoy doesn’t (re)create the indexes you might need for you.
It’s best to have a SQL DML script that creates your table structures for you.
Thanks for the heads up. Nearly all of my data tables have <50,000 rows and I am amazed at how well MS SQL server [probably most other backends also] perform without using any index. I am sure this is something I will have to think about as the data grows.
When you dropped the tables. Did you restart the server where you did youre import on?
This MUST be done.. All database modifications that are not done through servoy are only seen/reloaded with a restart.