>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?
Nothing that I know of. Maybe SDT can not open the table exclusively in order to update it. Can you call the Update method and just pass that table name to see what the return value is?
Mark McCasland
Midlothian, TX USA