HariNam Singh
3/18/2002 8:19:00 PM
Hi,
How are named parameters used? Below is my try, which brough the following
SQL error:
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare
the variable '@clientnumber'.
private const string SQL_INSERT = @"INSERT INTO ei_client_options
(clientnumber, taskmapping, deliverymethod, smtphost, emailto, emailreply,
emailcc, emailsubject, encrypted, aeskey, aesiv, transporthost,
transportport, created, createdby, updated, updatedby)
VALUES (@clientnumber, @taskmapping, @deliverymethod, @smtphost, @emailto,
@emailreply, @emailcc, @emailsubject, @encrypted, @aeskey, @aesiv,
@transporthost, @transportport, getdate(), @createdby, getdate(),
@updatedby)";
public void Insert(string currentUser) {
OdbcCommand command = Config.CreateOdbcCommand(SQL_INSERT);
command.Parameters.Add(new OdbcParameter("@clientnumber", ClientNumber));
command.Parameters.Add(new OdbcParameter("@taskmapping", TaskMapping));
command.Parameters.Add(new OdbcParameter("@deliverymethod",
DeliveryMethod));
command.Parameters.Add(new OdbcParameter("@smtphost", SmtpHost));
command.Parameters.Add(new OdbcParameter("@emailto", EmailTo));
command.Parameters.Add(new OdbcParameter("@emailreply", EmailReply));
command.Parameters.Add(new OdbcParameter("@emailcc", EmailCC));
command.Parameters.Add(new OdbcParameter("@emailsubject", EmailSubject));
command.Parameters.Add(new OdbcParameter("@encrypted", Encrypted));
command.Parameters.Add(new OdbcParameter("@aeskey", AesKey));
command.Parameters.Add(new OdbcParameter("@aesiv", AesIV));
command.Parameters.Add(new OdbcParameter("@transporthost", TransportHost));
command.Parameters.Add(new OdbcParameter("@transportport", TransportPort));
command.Parameters.Add(new OdbcParameter("@createdby", currentUser));
command.Parameters.Add(new OdbcParameter("@updatedby", currentUser));
Debug.WriteLine(command.CommandText);
command.ExecuteNonQuery();
command.Dispose();
}
thanks for improving my coding!