Thanks Rohit, that did the trick. Now I just need to get Crystal reports to work with it :)
Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com ----- Original Message ----- From: "Rohit Gupta" <[EMAIL PROTECTED]> To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]> Sent: Wednesday, April 14, 2004 8:55 PM Subject: Re: [DUG] IBObjects > Robert, > > 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 > > _______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
