How do I query simpleType fields in InfoPath 2003?

[WeeblnBob]

I'm trying to query a SQL data source using a simpleType field. Does anyone
know if this is possible?

 

[Franck Dauché]

Hi,

Are you looking for something like that:
string qry = "MyValue"; //<----- or from a textbox in IP
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é