This project has moved and is read-only. 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 7:52 PM by ErikEJ


ErikEJ wrote Sep 14, 2015 at 12:31 PM

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

ErikEJ wrote Sep 14, 2015 at 12:33 PM

I think I just need to set the table name

wrote Sep 26, 2015 at 11:56 AM

wrote Sep 26, 2015 at 12:32 PM

Associated with changeset 90814.

wrote Sep 26, 2015 at 12:33 PM

wrote Oct 27, 2015 at 7:52 PM