SQLiteEx - Example Syntax Error?

[randym]

Started messing around with SQLiteEx to see about using for a project I have in mind.

Downloaded and installed SQLiteEx, including the example script, but I get a syntax error upon execution...

so I started breaking down the SQL statement by commenting out parts of it and adding it back in a little at a time.

;--------------------------------------------------------------------------------------------------
;Examples of work with SQLiteEx - simple SQLite interface for AutoIt
;--------------------------------------------------------------------------------------------------


#Include 'SQLiteEx.au3'

$bVerbose = TRUE

;----------------------FIRST DATABASE--------------------------------------------------------------
$sDB_Earth          = 'earth_2012'
$sTableCountries    = 'countries'

$sSQL =  "CREATE TABLE " & $sTableCountries & " (country text, internet_users integer, population integer);" & @CR
$sSQL &= "INSERT INTO " & $sTableCountries & " (country, internet_users, population) VALUES " & @CR
$sSQL &= "('Brazil',        99357737,   193946886)," & @CR
$sSQL &= "('China',         568192066,  1343239923)"    & @CR
;$sSQL &= "('India',            151598994,  1205073612),"   & @CR
;$sSQL &= "('Japan',            100684474,  127368088),"    & @CR
;$sSQL &= "('Russia',       75926004,   142517670),"    & @CR
;$sSQL &= "('United States',    254295536,  313847465),"    & @CR
;$sSQL &= "('You are here', 2405518376, 7017846922)"    & @CR

Say('Deleting previous ' & $sDB_Earth & ' database: ' & _SQLiteEx_DropDatabase($sDB_Earth))

Say('Opening database ' & $sDB_Earth & ' and executing ' & $sSQL & ' Results: ' & _SQLiteEx_Open($sDB_Earth, $sSQL))

Creating the Table and inserting the values for one record worked w/o problem, but when I attempt to include the values for a second record, I get the syntax error message.  See attached screen shot of error.

I double checked the syntax and all looks good to me.  Does anyone have any ideas?

 

 

[jchd]

You'd better use the standard SQLite UDF.

Now "chained" inserts are only recently accepted by SQLite. Please download the most recent stable release and ascertain you use it over older version(s).