<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Oh I did not. Ok that's great, it's a shame that it's not documented!<br>Thanks!<br><br><div>> Date: Sun, 16 Feb 2014 18:28:06 +0100<br>> From: rob@hoelz.ro<br>> To: devel@lists.sailfishos.org<br>> CC: sthocs@hotmail.com<br>> Subject: Re: [SailfishDevel] Getting odd error when attempting to use LocalStorage.changeVersion<br>> <br>> On Sun, 16 Feb 2014 17:13:11 +0000<br>> Sylvain B. <sthocs@hotmail.com> wrote:<br>> <br>> > Thanks for the report on qt-project, I just faced this exact same<br>> > issue this afternoon (my app is not released yet but I already wanted<br>> > to see if a DB update will be possible). It's a shame not to be able<br>> > to open the DB without specifying the version :/<br>> > <br>> > Waiting for improvements on QML LocalStorage API, I've found out via<br>> > StackOverflow the "table_info" SQLite Pragma statement:<br>> > http://www.sqlite.org/pragma.html#pragma_table_info With that, you<br>> > can either look at the number of columns of your table, or iterate<br>> > through the rows returned to see if your new column name already<br>> > exists or not.<br>> > <br>> <br>> Did you see the solution I posted on qt-project?<br></div> </div></body>
</html>