Re: [sqlite] I can insert multiple rows with the same primary key when one of the value of the PK is NULL ...

Thank you all for your answers. I have made the changes necessary. Alex -Message d'origine- De : sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] De la part de Keith Medcalf Envoyé : jeudi 18 juillet 2019 21:11 À : SQLite mailing list Objet : Re: [sqlite] I can

[sqlite] I can insert multiple rows with the same primary key when one of the value of the PK is NULL ...

Hello, I have created a table. CREATE TABLE "sales" ( "client"TEXT, "salesman" TEXT, "revenue" REAL, PRIMARY KEY("client","salesman") ); I can run the query below mutliple times without any error

[sqlite] printf() - Local decilmal separator

Hello, 1st question : Is there a way to tell printf() to display the decimal separator set in the OS ? For example, the decimal separator in my OS is set to comma (,), I would like printf() to display the comma as the decimal separator. sqlite> select printf('%.2f %%', 25.365419); 25.37 %

[sqlite] Window functions in System.Data.Sqlite

Hello, I am sorry in advance for this post but I am really looking forward having the window functions in System.Data.Sqlite. The expected release date went from December 2018 to February 2019 in the news page. Do you have any more info when will the new version of System.Data.Sqlite be