If you put the table inside your relationship graph the table is treated like any other table inside your solution. As long as you have permission to change that in that table you can change data in a table, meaning set the flag you ask to whatever information you need it to be
But I'm running two different Runtime solutions.
How can I insert the relation of a table of a solution that can be anywhere once i do the data transfer from the old solution to the new one?
The only moment I could access the "older" solution is just when I transfer the data from the old one to the new one. But I do not have any clue how to do that.
Runtime is something else. Then I would have to build a API that calls the other file. Like a fmp: url that goes to that specific file with a Parameter
Now I'm using this script line in the new solution to import data:
Import Record [No dialog; "$Path"; Add]
the $Path variable is defined on the beginning of the script and links to the Runtime solution to import data from.
What kind of instruction I should use ?
I had that Idea too, but the transfer between the two solutions happens all in the same computer/folder.
And there is no web server... so I abandoned the idea.
There is no need for web server to do fmp url locally
I found out that also if the function is a bit limited, it can link the solution only if it's open or is in the \Documents folder, but I managed to make it work.
Just one more question:
The script I tried works fine.
There is only one issue. In fact the script to modify tables record I have it only in the newer Solution, so when I launch the URL I cannot run the script from the older database. because there is no script there.....
How could I open the Solution with the URL and launch the script from the new solution?
I hope I explained myself.
Hard to run a script that does not exist. You need to have some kind of script that you can connect to
But since I would upgrade my clients solutions with the new one that has tha script. I was wondering if I can launch a script in the new solution that can modify the old one that does not have this script......
I need to do so because once the upgrade is completed.
I need to "flag" the old Solution. In order to avoid errors if somebody will launch twice the upgrade script.