I'M A VISUAL FOXPRO PROGRAMMER AND I'M TRY TO WORK WITH MY VISUAL DATABASES USING VISUAL BASIC AND DAO 3.51. I´M NO TROUBLE IN GENERAL, BUT WHEN I TRY TO USE AN DATABASE INDEX WE GET AN "3219" ERROR. THE CODE IT´S SIMILAR TO THE FOLLOWING:
DIM DBC AS DATABASE
DIM TBL AS RECORDSET
SET DBC = OPENDATABASE ( "C:\YAUTEPEC\PREDIAL.DBC", _
FALSE, FALSE, "Foxpro DBC;")
SET TBL = DBC.OPENRECORDSET ("PREDIOS", DBOPENTABLE)
TBL.INDEX = "XCLAVE"
THE LAST INSTRUCTION DON'T WORK. IF I USE THIS CODE WITH A ACCESS DATABASE IT WORKS, BUT WITH DBC DATABASE IT DOESN'T.
CAN YOU HELP ME????
THANK YOU.
EDMUNDO RIOS MIRANDA
ESCOM@INFOSEL.NET.MX