Subject | Re: [firebird-support] exists(EXECUTE STATEMENT ... |
---|---|
Author | Martijn Tonies |
Post date | 2004-08-16T14:29:55Z |
> >> Tat's not easy!To conform to the SQL standard and as a workaround
> >>
> >> 1. It's possible. Why? In Dialect 1 I didn't have a choice! In dialect
> >> 3 I do have.
>
> MT> Yeah... that's a good reason ;-)
>
> Well, why did they implement it in dialect 3? :-)
for reserved words.
> >> 4. I can avoid the separator "_" as I use "FirstName" not FIRST_NAME.On
> >> longer identifiers as "PersonsFirstName" or PERSONS_FIRST_NAMEclipboard!
> >> there is no difference in length any more.
>
> MT> Anyway, you can still write
>
> MT> SELECT FirstName, Adress, LastName
> MT> etc...
>
> MT> if you have created the column as FIRSTNAME. :-)
>
> Yes, but I don't write it. I export the field list from tools via
:-)
> MT> IMO, the double quotes are a pain... And they were a painYes, it does... :-D
> MT> to implement properly in tools as well :-)
>
> Well, I don't want to implement a tool and I think my dbworkbench
> works perfectly with mixed case :-)
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com