query with like

[micoud]

why this query generateb by dataset wizard of vs2010 won't work ?
no row at all ... also passing NumeroCig string in total

Code: Select all

SELECT ID, NumeroCig, ImportoIniziale, ImportoSpeso, Data
FROM            CIG
WHERE        (NumeroCig LIKE '%' + :Param1 + '%')

dll version 5.1.80.0

thanks

[Pinturiccio]

You have sent us an invalid query. You can fix it in either of the following ways:
1. String concatenation operator in SQlite is '||' not '+':

Code: Select all

    SELECT ID, NumeroCig, ImportoIniziale, ImportoSpeso, Data
    FROM            CIG
    WHERE        (NumeroCig LIKE '%' || :Param1 || '%')

2. Include the whole condition to the parameter:

Code: Select all

    SELECT ID, NumeroCig, ImportoIniziale, ImportoSpeso, Data
    FROM            CIG
    WHERE        (NumeroCig LIKE :Param1)

Parameter value: "%value%".

[micoud]

thanks