General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Jim,
I change the code a bit to see what was going on. It seems that not all the records in the table will make it crash.
IF FOUND()
cntr1 = cntr1 + 1
REPLACE myview1.title WITH mytable.title
all_is_ok = TABLEUPDATE(.T., .F., 'myview1')
IF !all_is_ok
TABLEREVERT(.T., 'myview1')
cntr3 = cntr3 + 1
ELSE
cntr4 = cntr4 + 1
ENDIF
ELSE
cntr2 = cntr2 + 1
ENDIF
WAIT WINDOW "FOUND " + ALLTRIM(STR(cntr1)) + CHR(13) + "NOT F " + ALLTRIM(STR(cntr2)) + CHR(13) +;
"BAD " + ALLTRIM(STR(cntr3)) + CHR(13) + "OK " + ALLTRIM(STR(cntr4)) NOWAIT
By doing this I found that most records are fine. I will have to look deeper into the Database Constraints or something???
Thanks for your help
Mike
Previous
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