Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Too many Columns error
Message
De
15/07/2008 09:15:47
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Titre:
Too many Columns error
Divers
Thread ID:
01331355
Message ID:
01331355
Vues:
269
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform