>Is there a way or a utility available to extract table names from a expression.
>
>The problem is expression can be any like
>
>Expr:
>mytable.amount*yourtable.rate
>
>so it should return
>mytable
>yourtable
>
>Expr:
>upper(mytable.testfld)
>
>Returns
>mytable
>
>Pls advs your suggestions/ideas, its a very important think in my recent project..
it is somewhat hard to know where a table name begins in (at least for the examples
you gave you can find where each name ends with an AT() and other such commands
if there was a space before each table it would be easier
note however that what ever you do will also return object names from expressions
(e.g. for myobject.myproperty you will get myobject..)
Arnon
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement