Changes on MS SQ-DB

Classic Servoy
1

Hi,
I’ve made changes on the MS SQL-DB ( I changed existing Views and added new Views).
I’ve made changes in the solution.

I did the changes in the MS SQL-DB at my customer.
I imported my solution.

But my solution don’t know these changes.

What have I to do ???

Thanks for help Harro

2

Hi Harro,

  1. Right-click the database connection
  2. From the popup menu choose “Reload tables/table structure from DB”
  3. If necessary also select the option “Synchronize with DB server information”
  4. If records have been added outside of Servoy also select “Update Servoy Sequences”

Kind regards,

3

Good morning Omar,
thank you for quick reply.

I try to import into the Servoy-Application-Serer at the customer.
Via: “http://mycustomer.de:8080/servoy-admin/”

What do you mean: "1. Right-click the database connection " ?

Thank you
Harro

4

Hi Harro,

If you have made structural changes to your database, then you have to rebuild your solution otherwise it will not know about the changes. The options I mentioned are available only in Servoy Developer. Unless somebody else knows a trick for solving this without rebuilding? But I can’t imagine that’s possible…

Kind regards,

5

Just restart the application server so it sees the DB changes Harro.

6

Hi thanks,
one step forward. :)

But:
Error: “Es muss mindestens eine Schlüsselspalte exisitieren ‘log_pro_view’” <== this means: “there must be a Key-Column in the view”

The view is a join from 2 tables, I want to update 2 columns of one of the table, the key is in the view.
I don’t know how to define a key in a View. Therefore I defined a “row ident” in the view in the developer.
it works in the developer.

But this information is not imported in the solution at the customer.

Some ideas ??? Would be nice :)

Thanks
Harro

7

Harro,

The only way to set this is to import the solution in appserver.
This will inform appserver which column to use to uniquely identify records from the view.

Rob

8

Harro,

Does this sound familiar?

https://www.servoy.com/forum/viewtopic.php?f=4&t=18555&p=99992#p99992