>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
I think you need to validate first before calling oMeta.oSDTMgr.Update(). as
oMeta.validate()
HTH
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham