Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating Tables at Client Sites
Message
From
01/11/2005 09:09:26
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Updating Tables at Client Sites
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01063965
Message ID:
01063965
Views:
53
I must have overlooked something.

For example, I have the below database:

dbProfiler.dbc

and the below table (belongs to database dbProfiler):

ac_gen.dbf

When I view the table's structure in the dbc using the Stonefield Database Explorer (clicking on the table in the left column and then the field so that the dbc properties show in the right column), the ge_polnum field is c(25).

However, when I right-click on the table itself in Stonefield Database Explorer and left-click modify table, in the Stonefield Extended Table Designer the ac_gen.ge_polnum field is c(14). The window heading reads 'Stonefield Extended Table Designer - ac_gen (DBPROFILER.DBC)

I modified the field on my development system by opening Stonefield Database explorer, right-clicking on the table and left-clicking on modify table, and in the Stonefield Extended Table Designer, modifying the field length and clicking on the save button .

I deployed the sdtuser.*, coremeta.*, dbcxreg.*, and sdtmeta.* files to the client machine. I also deployed the database dbprofiler.* to the client's machine. I ran sdt update() and it appeared to update all of the table structures (well it stepped through all tables in all databases), but when I look at the table structure itself of ac_gen.dbf after the update method finished, the field is still c(14). What have I overlooked?

Thanks!
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Next
Reply
Map
View

Click here to load this message in the networking platform