I created a Global Var (comp_id = null;) its an PK integer cd_id and a servoy sequence on a table. I then tried to create a relation with that Global on the same column name in another table where its a FK integer cd_id.
When I try to save the relation I get:
Key type of globals.comp_id does not match with type from cd_id
These columns are the same as far as I can see. Any suggestions on how I might track down this issue?
Hi Kahuna,
Seems the global is not of the type integer. What happens when you set the default value to 0 instead of null ?
ROCLASI:
Hi Kahuna,Seems the global is not of the type integer. What happens when you set the default value to 0 instead of null ?
That did the trick Robert - thanks.
I had’nt realised that a variable would be set to any specific type before it was declared in running code. I see now that since the comp_id had a Not Null property then of course I would need to set it to something!
Its a learning Curve
Note that you can also set the type of a global via the properties view.
Select the global via ->Globals (in the solution explorer tree) and select the variable in the bottom list.
Now you can change the variableType of the global via the properties view.
Rob
rgansevles:
Note that you can also set the type of a global via the properties view.
Select the global via ->Globals (in the solution explorer tree) and select the variable in the bottom list.
Now you can change the variableType of the global via the properties view.Rob
Nice one - thanks Rob.