Hi,

Doing a quick look on Google:
Found a source that used the @ symbol for replacement:database.AddInParameter(clearCommand, "@BaseName", DbType.String, baseName); And in another site:public void AddInParameter (
   DbCommand command,
   string name,
   DbType dbType,
   Object value
)
Looking at your code, you wrote:

Ok, so lets change a couple of things.

your local variable to my_id...

So your script would look like
DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);db.AddInParameter(dbCommand, "@id", DbType.Int32, my_id);

I'm not sure if you have to change your query statement to use a ':' or an '@' but my guess is that you use a ':' id in the string and the parser looks for the substitution '@id' and replaces it with the contents in my_id.But hey! What do I know? I've never played with dot net just a host of other languages.... But I did stay at a Holiday Inn one time long ago... ;-)

HTH

-G

_________________________________________________________________
The i’m Talkathon starts 6/24/08.  For now, give amongst yourselves.
http://www.imtalkathon.com?source=TXT_EML_WLH_LearnMore_GiveAmongst

No, but I think I can tell the difference between an Informix-SQL
question and a C# API question.

If the output of Gumby's impressive crystal ball didn't work, I'd ask in
news:microsoft.public.dotnet.languages.csharp

oh and here's one more example:
http://www.davidhayden.com/blog/dave/archive/2007/01/27/TransactionScopeDataAcce
ssApplicationBlock.aspx

And from this code snippet, you only need to use the @ symbol to indicate variable replacement in the sql string. And its optional in the object's name as seen here"
string insertCustomerSql = "INSERT INTO Customers   (Name, EmailAddress) VALUES (@Name,@EmailAddress)   SELECT @CustomerId = SCOPE_IDENTITY()";
string insertOrderSql = "INSERT INTO Orders (CustomerId,   Number, OrderDate) VALUES (@CustomerId, @Number,   @OrderDate)";

using (TransactionScope scope =    new TransactionScope(TransactionScopeOption.RequiresNew))
{
   DbCommand insertCustomerCommand =         database.GetSqlStringCommand(insertCustomerSql);
   database.AddInParameter(insertCustomerCommand,                      "Name", DbType.String, "Bill Doe");
   database.AddInParameter(insertCustomerCommand,          "EmailAddress", DbType.String, "bill@doe.com");
   database.AddOutParameter(insertCustomerCommand,          "CustomerId", DbType.Int32, 4);

   database.ExecuteNonQuery(insertCustomerCommand);

   int customerId = (int)database.GetParameterValue                    (insertCustomerCommand, "CustomerId");

   DbCommand insertOrderCommand =             database.GetSqlStringCommand(insertOrderSql);
   database.AddInParameter(insertOrderCommand,             "CustomerId", DbType.Int32, customerId);
   database.AddInParameter(insertOrderCommand,             "Number", DbType.String, "12345");
   database.AddInParameter(insertOrderCommand, "OrderDate",              DbType.DateTime, System.DateTime.Now);
   database.ExecuteNonQuery(insertOrderCommand);
But hey!
What do I know?
(Python, Java, C/C++, Objective C, and others that I seem to remember but would proably want to take a refresher course...)
Naw, I don't know a thing. ;-)

HTH

-G> From: pmerloti@gmail.com> Subject: .net, parameters and ms enterprise library> Date: Wed, 18 Jun 2008 17:39:14 -0700> To: informix-list@iiug.org> > Hi,> > I've been stuck all day long with something I thought it would be easy> to do.> > I'm using MS Enterprise Library and C# (.net 3.5) to retrieve some> data from informix (via OleDB). If I create a statement like> > Database db = Program.GetDatabase(myDbName);> try> {> int id = 386> string sqlCommand = "select * from users where id = "> + id;> DbCommand dbCommand => db.GetSqlStringCommand(sqlCommand);> DataSet ds = db.ExecuteDataSet(dbCommand);> Console.WriteLine(String.Format("Username = {0}",> ds.Tables[0].Rows[0]["name"]));> }> catch (Exception ex)> {> Console.WriteLine(ex.Message);> }> > It works fine, thus proving that I have connection to the informix.> Now, I don't want to use the concatenation for obvious reasons, so I> tried to use parameters... I tried with @ and :, I'll post here my> version with :, but it doesn't work:> > > > Database db = Program.GetDatabase(_cmecfDatabaseName);> try> {> string sqlCommand = "select * from users where id> = :id";> DbCommand dbCommand => db.GetSqlStringCommand(sqlCommand);> db.AddInParameter(dbCommand, ":id", DbType.Int32,> 386);> DataSet ds = db.ExecuteDataSet(dbCommand);> Console.WriteLine(String.Format("Username = {0}",> ds.Tables[0].Rows[0]["name"]));> }> catch (Exception ex)> {> Console.WriteLine(ex.Message);> }> > > It catches me the following exception:> E42000: (-201) A syntax error has occurred.> > > Anybody had the same problem?> > Cheers> _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list
_________________________________________________________________
Introducing Live Search cashback .  It's search that pays you back!
http://search.live.com/cashback/?&pkw=form=MIJAAF/publ=HMTGL/crea=introsrchcashback