Form Regeneration after every database alteration

Scriptcase 9 Bugs
#1

Dear All,

I have noticed that every time I have a course to alter any table on my database, form application related to it will have to be deleted and reconstituted from scrath for the application to work with the database without error. In-fact I discover I have to log out completely and relog in before the newly added field in the altered database can be recognised and reflected on the application.

Is there any facility in scriptcase I am yet to fully understand that will solve this problem.Some time this leads to several man hour loss for me.

Thank you.

#2

Well if you alter your table, then scriptcase must know about these fields. For forms you can go to appliction -> synchronize. It will update the fields table with the new fields, types and length. In Grids you define your own sql, so you need to change the sql manually. In both cases, you need to do some work on the field edit section to put the field on the form/grid if you need to. If you have a new table then you will find a refresh upon create application. That will cause the new table list in the drop down menu.
Hope this answers your question.

#3

pardon i have scriptcase 9 installed but i cant see “appliction -> synchronize” option in my menu

#4

Hi everyone,
Hope this clears up how SC works in general:

  • When you have created the grid and form apps, SC looks at the table in the DB, as it exists at that moment, and adds all the fields, etc.
  • You then work with the grid - changing arrangement of columns, etc . You also do the same with the form.
  • What happens when you have to go back into the database table and add, delete, or change a column or more? How does the SC grid and form apps know there has been a change?
  • Well, if you added a new column and did not want to display it for some reason on the grid or form, you don’t have to do anything. Both type apps will still work.
  • However, if you want to use the new column in both of the apps, here is what you do:
  1. grid app - there is synchronize option for a grid. You have to go into the SQL (left menu), SQL Settings, SQL Select Statement. Change the fields manually in the select, to reflect the new field. When you save, you will find that a new field appears in your list. You will have to drag it into the proper order, using Edit Fields.
  2. The form app - there is a synchronize option under the left menu - Application, Synchronize Table. If you click that, a list of all your fields appears and it uses color coding to show how the field changes will happen. Again, once you have done it, you will need to adjust how you are using those fields, etc.
  • note in the above steps, you are responsible for cleaning up any field variables you might use in your custom event code.
    Hope that helps,
    Jamie