| Subject | RE: [IB-Conversions] Access 2003 to FB 1.5 |
|---|---|
| Author | Claudio Valderrama C. |
| Post date | 2005-02-04T07:19:14Z |
delphifirebird wrote:
insensitive in IB/FB whereas Access may use [...] to accept names written in
mixed case that will be accepted as if they were in upper case.
Some queries may be accepted in Access and IB. FB is more picky: in joins,
if a field name appears in more than one table and you don't write
table.field, the query is rejected for being ambiguous: which table does the
field belong? While a nuisance at first glance, it avoids random query
results that plague IB.
C.
> I'm about to port an Access database to FB 1.5. The front end will beThen you know already that fields are either case sensitive or case
> written in Delphi 7.
>
> I'm a newbie to this group. Any "gotchas" or suggestions before I
> plunge into this endeavor?
>
> (I've used IB a fair amount in the past, have been using FB for a
> month, and have been using Delphi for 10 years).
insensitive in IB/FB whereas Access may use [...] to accept names written in
mixed case that will be accepted as if they were in upper case.
Some queries may be accepted in Access and IB. FB is more picky: in joins,
if a field name appears in more than one table and you don't write
table.field, the query is rejected for being ambiguous: which table does the
field belong? While a nuisance at first glance, it avoids random query
results that plague IB.
C.