Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating Tables at Client Sites
Message
 
 
To
01/11/2005 09:09:26
General information
Forum:
Visual FoxPro
Category:
Stonefield
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01063965
Message ID:
01063981
Views:
11
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform