DMXzone Database Connector ASP Support Product Page

Not planned

Make field aliasing easier

Shared 03 Mar 2015 12:20:03
1
likes this idea
03 Mar 2015 12:20:03 Baruch Spinoza posted:
In a big table it is a pain doing the aliasing for each field manually. I could build a regex and then process the relevant file (basically sourcename.asp), but that too is a pain. What would be very useful is to be able to block out a pattern that's common to all fields and base the alias on that. An example:

VeryLongTableWithLotsOfFields.ID
VeryLongTableWithLotsOfFields.Field1
...

I would be able to select the table name + '.', and then have an option that does 'replace the selection for all fields with 'VT' (or whatever), giving one:

VTID
VTField1
...

It should be relatively easy to implement!

ATB

John B

Replies

Replied 04 Mar 2015 16:53:40
04 Mar 2015 16:53:40 Teodor Kuduschiev replied:
Hello John,
Thank you for sharing your idea with us, but unfortunately we are not planning to integrate such an option in the DMXzone Database Connector extension.

Reply to this topic