Reply to thread

Message

<blockquote data-quote="dir" data-source="post: 354450" data-attributes="member: 24485">Well, I've spent several more hours trying every conceivable combination of CREATE TABLE statements to make this work, and failed.CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible boolean NOT NULL DEFAULT 1); CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible boolean); CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible boolean NOT NULL DEFAULT 0); CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible varchar(5)); all fail when I try to do an update using any of these:asteroid;Asteroids (rev 2);1979;Atari;TRUEasteroid;Asteroids (rev 2);1979;Atari;0asteroid;Asteroids (rev 2);1979;Atari;FALSEasteroid;Asteroids (rev 2);1979;Atari;1asteroid;Asteroids (rev 2);1979;Atari;tasteroid;Asteroids (rev 2);1979;Atari;#fAll of these simply cause the MyEmulators configurator plugin to crash with the error below.&nbsp; I'm starting to think that either:- the Visible field isn't actually a boolean in the database,- the configurator program has a bug,- the configurator program's doing something clever to read a character field as a boolean or something- you can't update a boolean field with the values above because none of them are actually binary TRUE/FALSE valuesI'd love to know a way to update the database's Visible field so that I can do a bulk-update.&nbsp; There's no way that it's practical to change 7500+ tick boxes manually!Dir************** Exception Text **************System.FormatException: String was not recognized as a valid Boolean.&nbsp;&nbsp; at System.Boolean.Parse(String value)&nbsp;&nbsp; at myEmulators.DB.getGame(String path, Emulator parentEmulator)&nbsp;&nbsp; at myEmulators.DB.getGames(String path, Emulator emulator, SearchOption recursive, Boolean showHidden)&nbsp;&nbsp; at myEmulators.DB.getSomeGames(String sqlTail)&nbsp;&nbsp; at myEmulators.DB.getPCGames()&nbsp;&nbsp; at myEmulators.Conf_PCGames..ctor()&nbsp;&nbsp; at myEmulators.Configuration.Configuration_Load(Object sender, EventArgs e)&nbsp;&nbsp; at System.Windows.Forms.Form.OnLoad(EventArgs e)&nbsp;&nbsp; at System.Windows.Forms.Form.OnCreateControl()&nbsp;&nbsp; at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)&nbsp;&nbsp; at System.Windows.Forms.Control.CreateControl()&nbsp;&nbsp; at System.Windows.Forms.Control.WmShowWindow(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.Control.WndProc(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.ScrollableControl.WndProc(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.ContainerControl.WndProc(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.Form.WmShowWindow(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.Form.WndProc(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp; m)&nbsp;&nbsp; at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</blockquote>

[QUOTE="dir, post: 354450, member: 24485"] Well, I've spent several more hours trying every conceivable combination of CREATE TABLE statements to make this work, and failed. CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible boolean NOT NULL DEFAULT 1); CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible boolean); CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible boolean NOT NULL DEFAULT 0); CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible varchar(5)); all fail when I try to do an update using any of these: asteroid;Asteroids (rev 2);1979;Atari;TRUE asteroid;Asteroids (rev 2);1979;Atari;0 asteroid;Asteroids (rev 2);1979;Atari;FALSE asteroid;Asteroids (rev 2);1979;Atari;1 asteroid;Asteroids (rev 2);1979;Atari;t asteroid;Asteroids (rev 2);1979;Atari;#f All of these simply cause the MyEmulators configurator plugin to crash with the error below. I'm starting to think that either: - the Visible field isn't actually a boolean in the database, - the configurator program has a bug, - the configurator program's doing something clever to read a character field as a boolean or something - you can't update a boolean field with the values above because none of them are actually binary TRUE/FALSE values I'd love to know a way to update the database's Visible field so that I can do a bulk-update. There's no way that it's practical to change 7500+ tick boxes manually! Dir ************** Exception Text ************** System.FormatException: String was not recognized as a valid Boolean. at System.Boolean.Parse(String value) at myEmulators.DB.getGame(String path, Emulator parentEmulator) at myEmulators.DB.getGames(String path, Emulator emulator, SearchOption recursive, Boolean showHidden) at myEmulators.DB.getSomeGames(String sqlTail) at myEmulators.DB.getPCGames() at myEmulators.Conf_PCGames..ctor() at myEmulators.Configuration.Configuration_Load(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) [/QUOTE]

Verification