Duplicating a database deletes internal references
I have duplicated a Database in order to start populating it with data from scratch.
One of the tables ('Selezioni') exists only to allow the creation of Cascading Dynamic Choice Fields.
When I duplicate the database, all the references to that table get lost as if Ninox couldn't find the table. Of course I haven't changed any table's name.
In the dynamic value field I get
let xTipo := number(YA);
let xArea := number(T8);
let xLiv := number(V8);
ERR("Tabella non trovata: BB")[A = 4 and H = xTipo and B = xArea and C = xLiv]
where there should be
let xTipo := number(Contratto);
let xArea := number(Area);
let xLiv := number(Livello);
(select Selezioni)[ContrattoCategorie = 4 and ContrattoTipo = xTipo and ContrattoArea = xArea and ContrattoLivello = xLiv]
This brings me to my second question: if I want to duplicate a database, how can I know which references will stay and which ones will be lost?
4 replies
-
Interesting, I duplicated a DB with dynamic fields and they duplicated fine. They didn’t lose their connection or anything.
Can you create a temp db and try it again?
-
You can always not duplicate the records. Then just import the data for the dynamic choice field separately.
Content aside
- Status Answered
- 2 yrs agoLast active
- 4Replies
- 65Views
-
2
Following