Here's the error I get when trying to create a relationship. I had originally posted this error on Codeplex ( http://umbracorelationtypes.codeplex.com/workitem/436 ) over a month ago and it seems to still persist in Umbraco 4.7 final. Any idea if SQL CE 4 will be supported?

Thanks

Server Error in '/' Application.

Error running Scalar: 
SQL Statement:
INSERT INTO umbracoRelationType (dual, parentObjectType, childObjectType, name, alias) VALUES (0, 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'Related Page', 'relatedPage'); SELECT MAX (id) FROM umbracoRelationType

Exception:
System.Data.SqlServerCe.SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 211,Token in error = SELECT ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteScalar()
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCeApplicationBlock.cs:line 42

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: SqlCE4Umbraco.SqlCeProviderException: Error running Scalar: 
SQL Statement:
INSERT INTO umbracoRelationType (dual, parentObjectType, childObjectType, name, alias) VALUES (0, 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'Related Page', 'relatedPage'); SELECT MAX (id) FROM umbracoRelationType

Exception:
System.Data.SqlServerCe.SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 211,Token in error = SELECT ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteScalar()
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCeApplicationBlock.cs:line 42

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 


[SqlCeProviderException: Error running Scalar: 
SQL Statement:
INSERT INTO umbracoRelationType (dual, parentObjectType, childObjectType, name, alias) VALUES (0, 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'Related Page', 'relatedPage'); SELECT MAX (id) FROM umbracoRelationType

Exception:
System.Data.SqlServerCe.SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 211,Token in error = SELECT ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteScalar()
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCeApplicationBlock.cs:line 42]
SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCeApplicationBlock.cs:50
SqlCE4Umbraco.SqlCEHelper.ExecuteScalar(String commandText, SqlCeParameter[] parameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCEHelper.cs:59
umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) +160

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar]
umbraco.DataLayer.SqlHelper`1.ExecuteScalar(String commandText, IParameter[] parameters) +221
Umbraco.RelationTypes.NewRelationType.AddButton_Click(Object sender, EventArgs e) +343
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1