I am making an interface from VB
.NET to Micro's Access. I am using an SQL statement to pull a name from a table depending on the number entered in the interface:
select first_name from val_stu where patron_id = " & (Val(txtNumber.Text))
I get the error on the line with the code:
The error is:
"An unhandled exception of type 'System.Data.Constraint Exception' occuered in tsystem.data.dll
Additional information: Failed to enable constraints. One or more rows contain values violating non-null, unique or foreign-key constraints"
Does anyone know what this means and how I can solve the problem.