Article ID: 190624
Article Last Modified on 12/11/1999
*-- Code begins here.
CLEAR
ON ERROR *
IF ADIR(myTestFiles, "sys2018*.dbc") > 0
nErase=MESSAGEBOX("Erase SYS(2018) Files?",4)
ENDIF
IF nErase = 6
CLOSE DATA
ERASE sys2018.*
CREATE DATA sys2018
OPEN DATA sys2018
nError = MESSAGEBOX("Workaround?",4)
IF nError = 6
CREATE TABLE sys2018 (NAME c(10) CHECK NAME="Moe" ;
ERROR "NAME")
ELSE
CREATE TABLE sys2018 (NAME c(10) CHECK NAME="Moe")
ENDIF
ENDIF
INSERT INTO sys2018 VALUES ("NotMoe")
&&This causes a validation error.
?"SYS(2018) = " + SYS(2018)
?
?
=AERROR(aTest)
DISPLAY MEMO LIKE aTest
CLOSE DATA ALL
ON ERROR
*-- Code ends here.
ERASE SYS2018.*
Additional query words: kbADO150 kbADO200 kbCtrl kbDatabase kbDataBinding kbvfp600 kbActiveX
Keywords: kbprb kbcode KB190624