Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Implementing Stonefield @ Client's Site
Message
 
 
To
21/11/2001 09:21:34
Paul Robinshaw
Silkworm Technologies Limited
Macclesfield, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00584445
Message ID:
00584482
Views:
27
>Hi All,
>
>Just bought my first copy of Stonefield!
>
>Giving some thought as to how & what should be implemented on a client's site.
>
>Things that are really important to me immediately are:
>
>1. Updating the table structures
>
>2. Having something that'll fix tables that get broken
>
>3. Reindexing
>
>Can anyone think of anythingelse that's essential?

Those are exactly the 3 functions I include in all my apps. I have a Utilities menu pad on my app's menu. Under this I have 3 menu bars, 1 for each function. The Reindexing form includes a check box to optionally Pack tables.

One thing I had to incorporate into my app is some initial database/table validation of only those tables that are needed to initialize the launching of the app. For example, I have my users login in order to set up their access rights to various areas of the app. If the employee, privileges and some other tables structures have been modified, VFP will not open those tables because their structure is out of synch with the DBC. So I have SDT check those tables first. If any change is detected, I initiate a database validation with the SDT UPDATE() function.

>Do people generally call these functions in code from the menu or are they writing forms to implement Stomefields functions. Is it useful to use the Database Explorer on the clients site?

You only have to call the SDT methods of what you want done. SDT will handle any UI if it is needed. You can do a search on my member ID and the Stonefield category to find other posts I have made on this terrific tool. You have chosen wisely. < bg >
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform