Foreign keys with Export User Objects

[Vlad]

When exporting tables with foreign keys using Export User Objects, in a single file, the file looks like this:

create table1;
add foreign keys for table1;

create table2;
add foreign keys for table2;

...

create tableN;
add foreign keys for tableN;

It seems it sorts the tables, putting tables referenced by foreign keys first, so when the foreign keys are created the required tables exist.

This works fine, unless you have circular references like this:

table A with foreign key referencing table B;
table B with foreign key referencing table A;

In this case, sorting the tables in the script won't do any good, the script will fail when creating the foreign key on the first table, because the second table doesn't exist yet.

I think the simplest solution to fix this issue would be generate a script that creates the foreign keys after ALL the tables are created, not after each table, like this:

create table1;
create table2;
...
create tableN;

add foreign keys for table1;
add foreign keys for table2;
...
add foreign keys for tableN;

And I still can't use this forum with internet explorer. I can log in, but whenever I click anything I am logged out.

 

[Marco Kalter]

I think the simplest solution to fix this issue would be generate a script that creates the foreign keys after ALL the tables are created, not after each table

I have added this to the list of enhancement requests.

And I still can't use this forum with internet explorer. I can log in, but whenever I click anything I am logged out.

This is probably a cookie issue.

In Internet Explorer, go to Tools -> Internet Options Privacy Tab, Click "Advanced". Ensure settings are the following:

-> "Override automatic cookie handling" - CHECKED
-> First party Cookies: ACCEPT - selected
-> Third-party Cookies: BLOCK - selected
-> "Always allow session cookies" - user discretion

This allows the forum software to work as designed while still blocking potentially malicious third-party cookies.

It can also be that you are using the www.allroundautomations.nl domain. If so, try www.allroundautomations.com instead. Internet Explorer may reject cookies that originate from a frame from a different domain (the forum .com domain) than the main page (the .nl domain).