cherokee
29th November 2005, 18:36
Hello everyone,

I created a new table tccom901 with a key of string of 3 tccom901.csgr and a description field string of 35. Then I crate a new field tccom010.csgr in table tccom010 that refers to table tccom901 unless empty.

When I reconfigured both tables tccom010 and tccom901 in our test server everything was quite fast and worked perfectly.

After that, I create a dump with the table definition of tccom901 and its mantain session to import it in our production server. After that, the BaaN administrator imported it in our production server with no hassles at all. Then in the production server the BaaN administrator created the field tccom010.csgr in table tccom010 directly in the production server but when he reconfigured the table tccom010, the reconfiguration process started to check all text references and it took hours this, this check for text did not happen when I did it in the test server. My question is, when will happen the text reference check at the table reconfiguration process and when won't happen.

Thanks in advance,

Carlos

dave_23
29th November 2005, 19:15
In your test server you most likely made the change and ran "convert to runtime DD" in the prod server you cannot use "convert" since export / import does not set the correct flags. Instead you have to run "create runtime DD"

Create Runtime DD will automatically start the refint process if it
reconfigures a table.

Convert will not, however you should still run refint on the table
whenever you drop and recreate it (especally if it has text).

Hope that clears it up.

Dave

cherokee
29th November 2005, 20:37
Yes, I spoke to the BaaN administrator and he said that he did a Create Run Time DD... that explains it.

Thanks,

Carlos