Ok I will stick my neck out again. I get flamed everytime I do. The ISO sql standard is crap. The result is that if you are using dialect3 then it pays to have all identifiers mixed case. Otherwise the standard allows them, and everyone does stuff things up. The result is that part of interbase, firebird, ibo, ibx etc treat the all uppercase identifier as dialect 1 and part of it as dialect 3.
So you can get a situation where the dropdown lists say the table names with quotes but it does not work because it is in uppercase. If however you remove the quotes, it suddenly work there (but not in other places).
Get rid off all uppercase identifiers - table names, view names, field names, index names etc.
Robert martin wrote:
Hi All
We have Firebird with a table that is stupidly called TRANSACTION (for historical reasons). It was created using the " " syntax however although our IBOTable component lists the table when we try and open it we get an error. Any ideas?
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496 web www.chreos.com <http://www.chreos.com>
_______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
