Information générale
Titre:
Checking for duplicate data entered in a grid.
Hi. I'm using a grid to enter/update attendance violations by employees. The problem is this:
I have a primary index on three fields in the violation table: dtos(date)+emp_id+viol_cd (which is entered from a combo box). I do a seek command in the interacive change method of the combo box using the name of the objects on the screen and not the actual table field names. No sysntax error or runtime errors there...
But when I execute the seek I get "Uniqueness of index violated" or something to thst effect. After some research, I discovered that I should chamge the buffering for the violation table from optimistic record buffering to optomistic table buffering, because when the record pointer moves for the seek, foxpro attempts to save the record when "optimistic record buffering" is used. The problem is that I now get "Uncommitted changes in table 'violation'".
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement