Devart Forums

Posted: **Fri 28 Jun 2013 19:07**

Hello i'm going to crazy with this query...
i'm using tableadapter query configurator , this is the query:

SELECT        ID, DATA, CARD, IN1, OUT1, IN2, OUT2, IN3, OUT3, IN4, OUT4, NOTE
FROM            Ingressi
WHERE        (CARD LIKE '%'+:Param1)

Passing "1" like parameter it gives 0 row but on database the are 100 rows with CARD=11111111
if i write

SELECT        ID, DATA, CARD, IN1, OUT1, IN2, OUT2, IN3, OUT3, IN4, OUT4, NOTE
FROM            Ingressi
WHERE        (CARD LIKE '%1')

i have the 100 rows

Posted: **Fri 28 Jun 2013 21:12**

solved editing query :

SELECT        ID, DATA, CARD, IN1, OUT1, IN2, OUT2, IN3, OUT3, IN4, OUT4, NOTE
FROM            Ingressi
WHERE        (CARD LIKE :Param1)

and passing "%" with parameter :

 Me.IngressiTableAdapter.FillByMese(Me.DataSet.Ingressi, String.Format("%/{0:D2}/{1}", ComboBox1.SelectedIndex + 1, anno))

Problem with query