Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Too many Columns error
Message
From
15/07/2008 09:15:47
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Too many Columns error
Miscellaneous
Thread ID:
01331355
Message ID:
01331355
Views:
274
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
Next
Reply
Map
View

Click here to load this message in the networking platform