Page 1 of 1
Firebird and underscores in tablenames
Posted: 09.03.2007, 14:50
by 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
Posted: 10.03.2007, 17:09
by 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
Posted: 28.05.2007, 10:27
by 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??