SQL Database Integration

Re: use field-data inside select-command ???

mephisto — Wed, 23 Nov 2005 08:15:21 GMT

hello frank,

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

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

thx
mephisto

Re: use field-data inside select-command ???

franck — Tue, 22 Nov 2005 17:51:25 GMT

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

use field-data inside select-command ???

mephisto — Tue, 22 Nov 2005 15:47:18 GMT

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