FindParam / FindVariable

[Gencom]

Is there a FindParam / FindVariable function available??

I'm composing a lot of my queries in runtime, depending on custom user selection criteria. So it 's very difficult to know which params/variables are available in the query to declare them. So I'd rather use a kind of FindParam function. Is this available/possible?

Thanks

 

[Marco Kalter]

In the Oracle unit there is a published function like this:

function FindVariables(const SQL: string; IncludeDuplicates: Boolean): TStringList;

This function will scan de SQL parameter for variables and will return them in a TStringList. The IncludeDuplicates parameter determines if duplicate variables will be ignored or not, in this case it should probably be False.