Common Issues and Solutions

Where do I actually make changes (like editing object names)?

Most editing is perfomed in the Inspector, if the inspector isn't visible you need to use Window→Show Inspector to make it visible.

I tried importing SQL, but I get lots of errors, why?

This is most likely a limitation in the parser. There are lots of variants of SQL and there are things the parser doesn't support.
If you send a sample of the SQL that fails to us at support@malcolmhardie.com, we'll do our best to make the parser recognize it

My name includes accented characters and the registration code you sent doesn't work!

First of all, sorry about this. Some names cause problems when passed between the payment processor and our own system.
If you email us at support@malcolmhardie.com we'll immediately issue a new serial number for you. We're working to fix this problem.

When will you support [some other cool new thing]?

We try not to make announcements about future plans, but if you send a request in to us at support@malcolmhardie.com we'll add it the feature request list.
Quite a lot of the features in SQLEditor are the result of features that were requested, plus the more requests that we get for particular things, the more likely they are to appear.

Why do field level foreign keys get created by dragging from the foreign key to the primary key? Why isn't it the other way around?

Unfortunately this is just the way that SQLEditor was written and it made sense to the developer (awh) at the time. It's probably (but not entirely) too late to change this now. Although it may appear as an option at some stage