I’m changing the uniDAC dad driver to change the names of the table fields in pascalcase. I’m connet to oracle DB and all filed names are in upper case. I changed the method Oracle_DoGetTableFields of the unit uDAOracleInterfaces. I changed this:
While not Query.Eof do begin fld := Fields.Add; fld.Name:=Query.Fields.AsString; ldt:=OracleTypeToDADataType.....
While not Query.Eof do begin fld := Fields.Add; fld.Name:=PascalCaseString(Query.Fields.AsString); //Query.Fields.AsString; fld.TableField := Query.Fields.AsString; fld.SQLOrigin := Query.Fields.AsString;
The function PascalCaseString return a new string in pascal case format and remove the undescore char.
The problem is in the DASchemaModeler. Despite having set the TableField and SQLOrigin properties these are not read correctly. It seems that DASchemaModeler always takes the field name as reference for these settings.
Is it a problem of the DASchemeModeler? I tried to check in the code but the change I made seems the only possible one.
I’m creating a new application on a database that I don’t handle and I heavily use the strongly-typed access unit.
It would be an interesting feature to be able to integrate the management of the name of the field directly into DASchemaModeler but at the moment since there is no solution I have to automatically find the way to manage the name case without having to do it manually for all the datasets … which are really many.