Comments by JTRizos (Top 28 by date)

Siva, thank you for the prompt response.

Yes, it is there. I should have included that code too. The code gets the Case record for update whcih includes the CaseWorker column and when the CaseWorker is not in the CaseWorker DropDownList because the person is no longer here, I get the error. The application works well except for this quark.

Here it is:


<pre lang="c#">
//** Called from UpdateFIDM
public DataSet GetOneFIDM(string strFIDMID)
{
query = "SELECT FIDMID, " +
"FIDMStatus, " +
"CaseWorker, " +
"NCPName, " +
"CSENumber, " +
"CallReceivedDate = CASE CallReceivedDate WHEN '01/01/1900' THEN null ELSE CallReceivedDate END, " +
"MultiCountyCase, " +
"LevyDate = CASE LevyDate WHEN '01/01/1900' THEN null ELSE LevyDate END, " +
"EOTWOTW, " +
"AssetType, " +
"FinancialInstitution, " +
"BankNumber, " +
"AmountInAccount, " +
"LevyAmount, " +
"ArrearsBalance, " +
"SourceofFunds, " +
"NCPClaim, " +
"LCSAResolution, " +
"ResolutionType, " +
"Collection, " +
"COESent, " +
"COEReturnDate = CASE COEReturnDate WHEN '01/01/1900' THEN null ELSE COEReturnDate END, " +
"CourtDate = CASE CourtDate WHEN '01/01/1900' THEN null ELSE CourtDate END, " +
"CourtType, " +
"ResolutionDate = CASE ResolutionDate WHEN '01/01/1900' THEN null ELSE ResolutionDate END, " +
"Suppression, " +
"SuppressionLength, " +
"TimeSpent, " +
"Notes, " +
"County, " +
"FIDM.Added, " +
"FIDM.AddedBy, " +
"FIDM.Updated, " +
"FIDM.UpdatedBy " +
"from FIDM " +
"where FIDMID = '" + strFIDMID + "' ";
DataSet ds = obj68.getData(query, connection);
return ds;
}