When I submit the following query directly in Enterprise Manager:

SELECT * FROM TimeWorked where (SignDate = '7/9/2003') AND (EmployeeID = 1)

...it returns results.

The same query submitted to a Sql Adapter object in ASP.NET returns:

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

There are no constraints on the table of ANY kind and all of the fields contain values (and there is only one record to begin with). Any clues why this would work in SQL EM and not in ASP.NET? TIA

HOw do u call it?! sent ur code if its possible?!

Always:),
Hovik Melkomian.

Here's the code (referencing a SqlAdapter defined on the form using .NET Server objects):

sqlAdpTimeWorked.SelectCommand.CommandText = "SELECT UniqueID FROM TimeWorked where (SignDate = '" & Format$(Now, "Short Date") & "') AND (EmployeeID = " & Request.QueryString("UniqueID") & ")"

sqlAdpTimeWorked.Fill(DsTimeWorked)

This results in the SQL statement mentioned earlier.

If this provides additional clues for why it won't work when submitted from code, please elaborate, because I'd like to know what this code might be telling you that my previous question did not. TIA...