quotes trouble in sql

[gcue]

hello world.  I am trying to figure out the quotations of this sql command.

_SQLite_SQLiteExe($sql_db, _
            ".mode tabs" & @CRLF & _
            ".import '" & $s_InputFile_Path & "' aTemp" & @CRLF _
            , $s_Out, _
            $s_SQLITE3EXE_Path)

    FileDelete($s_InputFile_Path)

    _SQLite_SQLiteExe($sql_db, "CREATE TABLE aAssetInfo (Owner,PrimaryUser,Asset,Model,Comment,Power_Scheme,Acrobat_Installed,Free_Space,First_Boot,Vault_Installed,Memory_Detected);", $s_Out, $s_SQLITE3EXE_Path, True)

    _SQLite_SQLiteExe($sql_db, 'INSERT INTO aAssetInfo ("Owner","PrimaryUser","Asset","Model","Comment")' & _
            'SELECT "Owner","PrimaryUser","Asset","Model","Comment" FROM aTemp;', $s_Out, $s_SQLITE3EXE_Path, True)
    _SQLite_SQLiteExe($sql_db, "DROP TABLE aTemp;", $s_Out, $s_SQLITE3EXE_Path, True)

    _SQLite_SQLiteExe($sql_db, "Vacuum;", $s_Out, $s_SQLITE3EXE_Path, True)

this line is where i am having trouble

_SQLite_SQLiteExe($sql_db, 'INSERT INTO aAssetInfo ("Owner","PrimaryUser","Asset","Model","Comment")' & _

it works as is but i am trying to specify a WHERE condition.  here is what i have tried

_SQLite_SQLiteExe($sql_db, 'INSERT INTO aAssetInfo ("Owner","PrimaryUser","Asset","Model","Comment" WHERE Floor="33")' & _

_SQLite_SQLiteExe($sql_db, "INSERT INTO aAssetInfo ('Owner','PrimaryUser','Asset','Model','Comment' WHERE Floor='33')" & _

but neither work.  can a where clause even be specified?

thanks in advance!

[jchd]

A WHERE clause can't be used in an INSERT statement.

Maybe what you're after is something like this:

INSERT INTO aAssetInfo ("Owner","PrimaryUser","Asset","Model","Comment")
  SELECT "Owner","PrimaryUser","Asset","Model","Comment" FROM aTemp where Floor = '33'

Also note that in SQLite you can spare the double quotes around schema names (tables, columns, indices, triggers, collations, ...) unless a name is an identifier permitted in that place or contains whitespace(s). This would yield a more readable code:

INSERT INTO aAssetInfo (Owner, PrimaryUser, Asset, Model, Comment)
  SELECT Owner, PrimaryUser, Asset, Model, Comment FROM aTemp where Floor = '33'

 

[gcue]

brilliant!! thank youuuu!!