Firebird and underscores in tablenames

[tomcmok]

hi,

It seams that TZInterbase6DatabaseMetadata.HasNoWildcards gives wrong result if the table name passed to it as a parameter contains underscore - i.e. CUSTOMER_PROJECT

any suggestion for quick workaround?

Tomasz

[mdaems]

Hi,

This function accepts a pattern, not a table name. If you want underscores in a pattern to be treated as real underscores you have to add backslashes.

Can you explain a little more what you want to do or how you noticed this (in my opinion correct) behaviour?

Mark

[cipto_kh]

@tomcmok
Can you also show the example how to produce this error? the project example with database example? Because I still confuse with what you talk about. I already try to create table with the following name "aa", "b1_aa", b1_aa_t1", and "aa_t1" and if I drop TZTable or TZQuery and get all the persistant field, the primary key is correct for the given table (select * from aa).

If I pass the table name as parameter as I know this is not valid for SQL statement so there is always wrong (as I see in IBExpert too).

Or maybe I get different perception with what you mean??