Sqlite and Guid

Marcel Wagenaar

I want to pass a Guid as SQL Parameter.
This is my working SQL code: select * from mfwva_Nieuwsbrieven where id = x'8EAE79DE5401B64194979C824AA1DF30'
Field id is of type Byte[]

So the parameterised version is: select * from mfwva_Nieuwsbrieven where id = @nbID

And now the parameter definition: what datatype should i select? String? I've tried them all -> nothing works.

They only working option is to insert the SQLCode directly into the table:
//TableDataSource tableNB = rptReport.GetDataSource("Nieuwsbrief") as TableDataSource;
//tableNB.SelectCommand = "select * from mfwva_Nieuwsbrieven where Id = " + reportPar;
before showing the report.

Anyone?