Repository not properly refreshing?

Classic Servoy
1

Hi, im using servoy 5.0 and sybase11

And well let me explain my situation, when i created my database i defined a table with a composite PK that i later modified turning it to a single field PK.
Now the problem is that in servoy the fields that used to be part of the PK are still marked as PK. I tried erasing them from the base and when i did servoy recognized that and erased them, so i created them again and voila servoy still marks them as PK!!
This is giving me problems when using selectRecord(), cause i pass the PK, the single field but it just returns false… cause servoy is still considering the other fields as PK(Or thats what i suppose).

Any suggestions of how could i make servoy realize theyre no longer PKs?

Thanks

2

nromeou,

Please create a case in our support system describing the scenario.

http://crm.servoy.com/servoy-webclient/ … oy_support

As a workaround you can drop the table from within Servoy Developer and create the table again (either using developer or your sql tools, the latter requires a developer restart).

Make a backup of the data first.

Rob

3

I want to create the case but it asks me the topic id, wheres that number?

4

Created case 276431 in support system

5

In the URL of your browser you see “t=” and a number.
For this thread it’s “t=13736”
So you can refer to this topic with the number 13736.

And by the way, the topic ID in the support system is optional.

6

Thanks robert, and yeah noticed that later and created it without the id but thanks for answering