General information
Category:
Coding, syntax & commands
Title:
Error handling - duplicate record
Environment versions
Network:
Windows 2000 Server
In the click event of the ‘SAVE’ button I have the following code to trap errors.
-----
ON ERROR DO "w:\Talman develpment\bkbplus\errhand" with ERROR(), MESSAGE()
select bkplcont
tableupdate(.T.,.F.)
on error
------
For some reason the program only catches the error when you exist the program. Then giving the foxpro error 'Uniqueness of index CN_CONTNUM violated'.
In the load event of the form I 'use' the table with row buffering.
---------
SET MULTILOCKS ON
USE bkplcont IN 0 SHARED ORDER CN_PORG
lSuccess = CURSORSETPROP("buffering",3,"bkplcont")
----------
What must I do so that the duplicate error will be trapped when trying to ‘tableupdate’?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only