Maybe it is a bug in my head (again... ) or in SQLite itself.
Is it correct that the string variable binding works only with "=?" placeholders but it doesn't with just a "?", f.e.:
Code: Select all
If GetGadgetState( licProductFamily) = 0 ; If < All >
SetGadgetState( licProductFamily, 0) ; deselect all
Else
_sString = "IN("
For _i = 1 To CountGadgetItems( licProductFamily) -1
If GetGadgetItemState( licProductFamily, _i)
SetGadgetItemState( licProductFamily, 0, 0)
_sString + Str( GetGadgetItemData( licProductFamily, _i)) +","
EndIf
Next
_sString = RTrim( _sString, ",") +")"
EndIf
SQLite_BindString( 0, _sString)
SQLite_BindInteger( 1, GetGadgetItemData( cmbPB_Name, GetGadgetState( cmbPB_Name)))
_sSQL = "...
WHERE [main].[tblProductFamilies].[ID] ? And [main].[tblPriceBooks].[ID] = ?
..."
Code: Select all
;SQLite_BindString( 0, _sString)
SQLite_BindInteger( 0, GetGadgetItemData( cmbPB_Name, GetGadgetState( cmbPB_Name)))
_sSQL = "...
WHERE [main].[tblProductFamilies].[ID] "+ _sString +" And [main].[tblPriceBooks].[ID] = ?
..."
BRG
Yury