Subject | changing KeyLinks, MasterLinks etc to use aliases |
---|---|
Author | Markus Ostenried |
Post date | 2006-11-29T20:35:17Z |
Hi all,
I'm currently investigating what it takes to adjust my source code for
FB 2.0 and IBO 4.7. I've read the IBO release notes and followed the
FB and IBO mailing lists.
So far it seems the biggest hurdle will be adjusting all my dataset
properties to use alias names instead of table names. Since my app may
have a few hundred TIB_Query and TIB_Cursor components I would very
much like some automatic conversion - or at least some assistance with
adjusting the affected properties.
I wondered if one could write a tool that does the following:
- read all TIB_Query / TIB_Cursor definitions from text dfm files
- use them to create an instance of that component
- use IB_Parse.GetRelAliasList() to determine the aliases used in the SQL string
- adjust the various *Links properties to now use the alias name
- report any ambiguities and prompt for user interaction
- stream the properties of the changed component out and write them
back to the original dfm file
I don't know if my level of experience is sufficient to write this
tool, But I think if nothing like this is planned then I must at least
try it since converting everything by hand will take awfully long.
So my questions are:
Jason, do you have plans for simplifying this conversion?
If not, then what do I have to take care of?
Note, that I don't need a perfect fully automatic solution.
Any hints are appreciated. TIA,
Markus
I'm currently investigating what it takes to adjust my source code for
FB 2.0 and IBO 4.7. I've read the IBO release notes and followed the
FB and IBO mailing lists.
So far it seems the biggest hurdle will be adjusting all my dataset
properties to use alias names instead of table names. Since my app may
have a few hundred TIB_Query and TIB_Cursor components I would very
much like some automatic conversion - or at least some assistance with
adjusting the affected properties.
I wondered if one could write a tool that does the following:
- read all TIB_Query / TIB_Cursor definitions from text dfm files
- use them to create an instance of that component
- use IB_Parse.GetRelAliasList() to determine the aliases used in the SQL string
- adjust the various *Links properties to now use the alias name
- report any ambiguities and prompt for user interaction
- stream the properties of the changed component out and write them
back to the original dfm file
I don't know if my level of experience is sufficient to write this
tool, But I think if nothing like this is planned then I must at least
try it since converting everything by hand will take awfully long.
So my questions are:
Jason, do you have plans for simplifying this conversion?
If not, then what do I have to take care of?
Note, that I don't need a perfect fully automatic solution.
Any hints are appreciated. TIA,
Markus