Reply to thread

Message

<blockquote data-quote="dir" data-source="post: 354317" data-attributes="member: 24485">I'm trying to update the MyEmulators3.db3 &quot;visible&quot; flag with the following, but it crashes:CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible boolean); .separator ; .import ./mame3.csv temp UPDATE GAMES SET visible = (SELECT visible FROM TEMP WHERE TEMP.TITLE = GAMES.TITLE);DROP TABLE TEMP; I've looked at the MyEmulators3.db3 schema and it says that the 'visible' field is char(5).&nbsp; I've tried this as well:CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible varchar(5)); mame3.csv contains only 1 line:asteroid;Asteroids (rev 2);1979;Atari;1When I update the database, the MyEmulator configuration plugin crashes with ************** 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()Clearly, it's expecting a boolean value in the 'visible' field.I've tried changing the source values:asteroid;Asteroids (rev 2);1979;Atari;1asteroid;Asteroids (rev 2);1979;Atari;TRUEasteroid;Asteroids (rev 2);1979;Atari;Trueasteroid;Asteroids (rev 2);1979;Atari;Falseasteroid;Asteroids (rev 2);1979;Atari;0But it always crashes.&nbsp; How do I update the Visible field in the database?Any idea what I'm doing wrong?</blockquote>

[QUOTE="dir, post: 354317, member: 24485"] I'm trying to update the MyEmulators3.db3 "visible" flag with the following, but it crashes: CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible boolean); .separator ; .import ./mame3.csv temp UPDATE GAMES SET visible = (SELECT visible FROM TEMP WHERE TEMP.TITLE = GAMES.TITLE); DROP TABLE TEMP; I've looked at the MyEmulators3.db3 schema and it says that the 'visible' field is char(5). I've tried this as well: CREATE TABLE temp (title varchar(100), description varchar(200), yearmade varchar(4), company varchar(50), visible varchar(5)); mame3.csv contains only 1 line: asteroid;Asteroids (rev 2);1979;Atari;1 When I update the database, the MyEmulator configuration plugin crashes with ************** 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() Clearly, it's expecting a boolean value in the 'visible' field. I've tried changing the source values: asteroid;Asteroids (rev 2);1979;Atari;1 asteroid;Asteroids (rev 2);1979;Atari;TRUE asteroid;Asteroids (rev 2);1979;Atari;True asteroid;Asteroids (rev 2);1979;Atari;False asteroid;Asteroids (rev 2);1979;Atari;0 But it always crashes. How do I update the Visible field in the database? Any idea what I'm doing wrong? [/QUOTE]

Verification