SQLite: Delete multiple records

[c.haslam]

This works, for a single record:

Delete from tbl where fnam = 'BAdv2r' and ext = '.wpd' and path = ''

but for multiple-record delete, this doesn't:

***657-------------------------
$sSqlCmds => <String> (122 chars)   'Delete from tbl where (fnam = 'BAdv2r' and ext = '.pdf' and path = '') or (fnam = 'BAdv2r' and ext = '.wpd' and path = '')'

I get

!   SQLite.au3 Error
--> Function: _SQLite_Exec
--> Query:    BAdv2r|.wpd|10,840|2017-12-05 18:13||10840|
--> Error:    near "BAdv2r": syntax error

Suggestions?

[TheXman]

Show the actual lines of code, not the debug statement.  The statement below looks correct.

Delete from tbl where (fnam = 'BAdv2r' and ext = '.pdf' and path = '') or (fnam = 'BAdv2r' and ext = '.wpd' and path = '')

 

Are you creating the string like  this:

$sSqlCmds = 'Delete from tbl where (fnam = 'BAdv2r' and ext = '.pdf' and path = '') or (fnam = 'BAdv2r' and ext = '.wpd' and path = '')'

or like this:

$sSqlCmds = "Delete from tbl where (fnam = 'BAdv2r' and ext = '.pdf' and path = '') or (fnam = 'BAdv2r' and ext = '.wpd' and path = '')"

The example wrapped in double quotes would work correctly.  The example wrapped in single quotes would fail because the single quotes in the string would need to be doubled up like this:

$sSqlCmds = 'Delete from tbl where (fnam = ''BAdv2r'' and ext = ''.pdf'' and path = '''') or (fnam = ''BAdv2r'' and ext = ''.wpd'' and path = '''')'

 

of course it could be another issue all together but it's impossible to tell without the relevant code.

Edited January 6, 2019 by TheXman

[jchd]

Factorize common terms (and beware your single/double quotes, as @TheXman said):

$sSqlCmds = "Delete from tbl where fnam = 'BAdv2r' and ext IN ('.pdf', '.wpd') and path = ''"

 

[c.haslam]

Thank you both. Knowing that the SQL code is correct, I then looked again for stupid bugs, and found one: I had

_SQLite_Exec(-1,$s)
        If @error Then
            MsgBox(0,@ScriptLineNumber,_SQLite_ErrMsg())
_guidebug(@ScriptLineNumber,'$sSqlCmds',$sSqlCmds)
        EndIf

Changing $s to $sSqlCmds fixed the problem.

_GuiDebebug here is doing the equivalent of Msgbox, but it does not wrap the text as MsgBox does. It is part of my cDebug debugging aid)

Edited January 6, 2019 by c.haslam