How do I query simpleType fields in InfoPath 2003?

W

WeeblnBob

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

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é
 
Top