search

ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Schema designer still behaving strangely after ODBC changes #721

Closed jajwilson closed 8 years ago

jajwilson commented 8 years ago

Since issue #720 was fixed I can view the schema designer, but it's not working as it should be... 1) If I try to exit the designer I get a 'I you sure you want to exit? Any unsaved changes will be lost' message, even though I haven't edited anything. Click 'OK' does not have any effect - I'm still stuck in the designer. 2) The Mondial db structure is either not displaying correctly or has not been interpreted correctly during the upload process. The three tables are all there, as are the fields, but the relationship between the province table and the country table has been lost. province.ID should connect to country.Code.

Scott, pass this over to Dave if it's still related to the ODBC changes rather than your own new upload code.

jajwilson commented 8 years ago

Oh. And clicking 'revert changes' just seems to remove the entire structure and bring up a 'no schema to show!' message. I can exit the designer once I've reverted the schema to nothing, but that's not much use.

scottbw commented 8 years ago

I get really weird results.

The first time I tried, I got "no schema to show". Then I got the schema, but no tables showed up in the query builder - the REST result was an empty table list. Something has really gone wrong in the REST code. It shouldn't be anything related to the upload code as that only affected Access database uploads and this affects SQL dumps and CSV imports.

jajwilson commented 8 years ago

Ok. I'll add Dave to see if he's got any idea what might be causing this.

thestoat commented 8 years ago

Can you try now. I did find some funnies but have fixed those. Let me know ...

jajwilson commented 8 years ago

Yep, seems to work again.