Using VFP9 SP2 and Stonefield Database Toolkit 6.2B.
I have made updates to 1 table in my VFP database by adding 20 fields to the structure. The new structure now contains 252 fields.
When I try to update my production copy of this VFP database and run the oMeta.oSDTMgr.Update('ALL'), I get the following error when SDT tries to update this modified table.
*********************************
Error #1872
Message: Too Many Columns
Line# 468
Method: DBCXMGR.OSDTMGR.UPDATEONETABLE
*********************************
Here are the lines of code my update EXE runs:
oMeta = NEWOBJECT('DBCXMgr', 'DBCXMGR.VCX')
OPEN DATABASE mydbc
SET DATABASE TO mydbc
oMeta.SetDatabase(DBC())
IF oMeta.oSDTMgr.NeedUpdate()
oMeta.oSDTMgr.Update('ALL')
ENDIF
My table structure does not get updated from the SDT commands and when I try to USE mytable, I get the error "Database is Invalid. Please Validate". My old table was fine before I attempted the update.
What can I do to update my table structure with SDT?
Thanks,
Jerry