kbmMW’s ORM in this scenario – dynamic tables / fields

[Vitali]

Hi, I’m pretty new here and looking for solution for adapt my needs to any ORM (possibly).

Probably, needed tool not ORM, but let me explain.

I have very old program, it was made before ORM systems became so popular as now.

Instead was made own / fake ORM solution – on top of schema was build own layer – “table” / “fields” tables, there was described database structure and a bit more (linked control, etc). Actially it was like extention for the schema. It gave ability to users to add tables / fields of predestined types and choose appropriate control to be added to edit form dynamically. Then according to this structure was built queries ( and reports, etc).

Let say, if was added field of type MyMoney and control setted as TEDit, later I create edit form dynamically and editor in that case is TEdit. But also this field can be excluded (in settings) from form (and from UPDATE, SELECT also).

Can I achieve this in modern way, with kbmMW?  I don’t need objects (and full power of ORM), but just dynamic SQL and info (fields, properties) for dynamic forms. Thanks!

P.S. So far as I know, that TMS Aurelius support user’s dynamic (fields different from etalon) fields, but not tables.

 

 

 

 

[kimbomadsen]

Hi,

Yes kbmMW supports that. If you will need the ORM or not depends.

kbmMW natively supports dynamic SQL and you can retrieve info about tables etc using its metadata system.

The ORM however allows you to “surface” a true database table as an ORM table, which means you have full access to manipulate it via the ORM and via your own objects.

Combine this with kbmMW SmartBind and you can build very dynamic user interfaces.

/Kim

[Author]

Posts