Re: [sqlite] WITHOUT ROWID problem and large number of row updating

On Wed, 16 Apr 2014 10:24:51 -0700 Joseph Yesselman wrote: > sql = "CREATE TABLE two_way(" \ > "id VARCHAR(50) NOT NULL," \ > "names VARCHAR(2000)," \ > "rs VARCHAR(3000)," \ > "ds VARCHAR(2000)," \ > "sugs VARCHAR(2000), " \ > "PRIMARY KEY (id));";

[sqlite] WITHOUT ROWID problem and large number of row updating

Hi All, I have two problems, the first one is probably very simple but I could not find anything online telling me how to fix it. I would like to use the WITHOUT ROWID statement as my primary key is a string in the format of 6 coordinates. example: "0.0 1.0 3.0 1.6 2.4 0.0" I am using c++, but