InfoPath Dev

hello,

i want to filter a secondary-datasource with the select-command by different data-fields. is it possible?

e.g.
i have a field called my:fields/my:datestart and i want to filter a table from sql by select ...... where my:fields/my:datestart<='databasefield_date'

i don´t want to do this by rules! so my question ..... is it possible?

thx for answers

mephisto

Hi,

Yes you can. You can adapt the SQL statement of following code snippet to your case:
string qry = "MyValue";
ADOAdapterObject oNameTable = (ADOAdapterObject) thisXDocument.DataAdapters["tblTest"];
oNameTable.Command = string.Format("Select * from tblTest where Test = '" + qry + "'");
oNameTable.Query();

Hope that it helps.

Regards,

Franck Dauché
InfoPathDev

hello frank,

thx for your help!
this is so simple and helpful ;-)

now i can implement my idea ......

thx
mephisto