This project has moved. For the latest updates, please go here.


Error outputting XML when using a JOIN statement


I'm using a JOIN statement when executing a SELECT to incorporate fields from two different tables.

This query works fine normally. However, when I use the "-x" option it throws an error.

Error: System.InvalidOperationException: Cannot serialize the DataTable. DataTable name is not set.
at System.Data.DataTable.WriteXml(XmlWriter writer, XmlWriteMode mode, Boolean writeHierarchy)
at SqlCeCmd.SqlCeCommandHelper.RunDataTable(SqlCeCommand cmd, SqlCeConnection conn)
at SqlCeCmd.SqlCeCommandHelper.RunCommand(Options options)
at SqlCeCmd.Program.Main(String[] args)

I'm presuming this is because the code for outputting XML is only expecting to deal with fields from a single table? Can this be fixed?

Closed Oct 27, 2015 at 6:52 PM by ErikEJ


ErikEJ wrote Sep 14, 2015 at 11:31 AM

Does it work with a plain SELECT from a single table?

ErikEJ wrote Sep 14, 2015 at 11:33 AM

I think I just need to set the table name

wrote Sep 26, 2015 at 10:56 AM

wrote Sep 26, 2015 at 11:32 AM

Associated with changeset 90814.

wrote Sep 26, 2015 at 11:33 AM

wrote Oct 27, 2015 at 6:52 PM