
$FreeBSD: branches/RELENG_9_2_0/misc/cdcollect/files/patch-src_DBsql.cs 300896 2012-07-14 13:54:48Z beat $

--- src/DBsql.cs.orig
+++ src/DBsql.cs
@@ -958,10 +958,10 @@
 	private int sql_command_id (string comm)
 	{	
 		IDbCommand command = sqlite_connection.CreateCommand ();
-		command.CommandText = comm;
-		command.ExecuteScalar ();
+		command.CommandText = comm + "; SELECT last_insert_rowid() AS [ID]";
+		string s = command.ExecuteScalar ().ToString ();
 		command.Dispose ();
-		return (((SqliteConnection)sqlite_connection).LastInsertRowId);
+		return Int32.Parse (s);
 	}
 	
 	private void sql_command (string comm)
