Does StrataFrame allow of customize the database table's field during runtime? For example changing the datatype, Something which is similar to the Database Development Toolkit. The purpose of these, is to allow our customer to customize the fields themeselve without re-coding and re-compilation of the codes. Therefore we developers could save up plenty of time for the customization.

Kindly advise and welcome for any kind of comments
Thank You.

Hi Jim,

If you don't mind me asking, what kind of application are you working on that will allow end users to change field types? and why?

I have seen several commercial applications like QuickBooks, MS Outlook and others that will allow the end user to add/modify custom fields, but in fact there is no real adding, those custom fields are pre-created in the database as Varchar fields (at least in the case of QuickBooks) and there are only 15 fields available, for those the end user can change only the field caption and I would only imagine that the QB developers are using some sort of Cast or "of Generic" to properly evaluate and display the fields value based on where they are used.  See the attached image for a QB sample form.

By customize field, if you are referring to their captions, I believe you could use the Multilingual capabilities of SF to allow end user change the caption of those controls or use a similar approach as QuickBooks. 

At any rate we will need you to provide more detail on your intended customization in order to provide better approach with SF.

I'm are building a business solution whereby some of our customers might want to change certain fields base on their requirements.

I've attached two print screen of our exisiting application which built on-top of VPM (Visual ProMatrix), where having a tools call data manager that able to achieve such goal.

However since this is the case as what Trent said, then I might need to seek for a better solution. Of course it will be great if SF able to so.

Jimmy, I don't know if you are aware, but I am a VPM MVP Life, and Visual ProMatrix is the framework I use for my VFP projects.

I am sorry, but still you have not describe in detail your real needs, I gave u a couple of scenarios in my previous message and you did not acknowleage any of them.

The images you attached are from an old version of the VPM Data Builder (not your application) and the VPM Data Builder is not designed for an End User use.  That is a developer tool and when used in a compiled VPM application it will have some limitations imposed by VFP runtimes.

StrataFrame has a tool named Database Developer Toolkit (DDT) which does not really compares with the VPM Data Builder, DDT compares more with Stonefield Database Toolkit in the majority of the functionality.

Like I said before, without you letting us know exactly what you want to do, you will get a somewhat inconclusive answer.