Hi Jerry.
>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
>*********************************
Like Chris suggested, it sounds like you're not only adding some fields but also dropping some. SDT does the ADD COLUMN work first and DROP COLUMN work second for reasons documented in the SDTMgr.HowToSyncTable method. So, while the net result may be adding 20 fields, if you actually add 30 and remove 10, this will fail because the 30 added fields take you over the 254 field limit. Is that the case here?
Doug
Previous
Next
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