Markus wrote:

> 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.

This would be an excellent utility to have, for other things as well as
this. I would be surprised if there wasn't some kind of a framework already
in place to assist with this sort of thing. A rule-based DFM modification
tool. Is there anything in the GExperts library that comes close to this?
Is there anything out there in the open source realm to address this?

Thanks,
Jason Wharton