• Welcome, Guest. Please login.
 
October 14, 2019, 03:31:40 am

News:

Welcome to the SQLitening support forums!


Upsert

Started by Fredrick Ughimi, June 10, 2018, 02:45:35 pm

Previous topic - Next topic

Fredrick Ughimi

Fredrick Ughimi:
Hello,

I was just playing around with SQLite UPSERT and I got the same error from my codes and as well as those here:

http://www.sqlitening.planetsquires.com/index.php?topic=9709.0

1 = near ON: syntax error
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

I guess I am the only one having this error? I use SQLite 3.7.13.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

cj

SQLite3.DLL (32.bit binary) needs to be updated to version 3.24.0 using 3240000.zip
https://sqlite.org/download.html

Your version 3.7.13 is from 06/11/2012.  It is exactly 6-years old today!
https://sqlite.org/chronology.html

Show SQLite version:
#INCLUDE "sqlitening.inc"
FUNCTION PBMAIN () AS LONG
  slOpen "sample.db3","C" 'must have an open database
  ? GetSqliteVersion,,"Sqlite version"   '3.24.0 as of 06/04/2018
END FUNCTION
'
FUNCTION GetSQliteVersion AS STRING
  IF slsel("select sqlite_version()",0,"E0") = 0 THEN
   slGetRow
   FUNCTION = slf(1)
   slCloseSet
  END IF
END FUNCTION


Fredrick Ughimi

Hello CJ,


Wow! I thought going by digits my version was even higher. :)

Thanks.


slSEL "SELECT sqlite_version(*) as Version"
       If IsTrue slGetRow Then
           sVersion = slFN("Version")
       End If
       slCloseSet   
       ? "Database Version: " & sVersion

Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

cj

June 11, 2018, 02:13:16 pm #4 Last Edit: June 11, 2018, 10:07:53 pm by cj
I did too, until I realized 3.7.13 is 3.07.13 and a lesser version than 3.24.0.

Your version 3.7.13 is from 06/11/2012.  It is exactly 6-years old today!
Version history: https://sqlite.org/chronology.html