Hmm there's nothing wrong with the column names, and a SELECT statement was actually only an example, here's the real SQL (an INSERT statement):

INSERT INTO "TBLFLIGHTSCHEDULE"
("ID", "FlightName", "Origin", "DepartTimeScheduled", "Destination", "ArriveTimeScheduled", "AircraftRegistration", "Status", "EconomyPriceIfEnabled", "BusinessPriceIfEnabled", "FirstPriceIfEnabled", "AirportTaxes", "BookingOpen", "CheckingInOpen", "BoardingOpen", "IsRouteOnly")
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)


:"ID"(INTEGER,IN)=29
:"FlightName"(VARCHAR[7],IN)='another'
:"Origin"(CHAR[3],IN)='ERE'
:"DepartTimeScheduled"(TIMESTAMP,IN)=2009/08/28
:"Destination"(CHAR[3],IN)='AFW'
:"ArriveTimeScheduled"(TIMESTAMP,IN)=2009/08/28 12:00:00 PM
:"AircraftRegistration"(VARCHAR[6],IN)='JJJLGP'
:"Status"(VARCHAR[4],IN)='Open'
:"EconomyPriceIfEnabled"(FLOAT,IN)=45000
:"BusinessPriceIfEnabled"(FLOAT,IN)=0
:"FirstPriceIfEnabled"(FLOAT,IN)=0
:"AirportTaxes"(FLOAT,IN)=333
:"BookingOpen"(CHAR[1],IN)='T'
:"CheckingInOpen"(CHAR[1],IN)='F'
:"BoardingOpen"(CHAR[1],IN)='F'
:"IsRouteOnly"(CHAR[1],IN)='F'

--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
>
> Buying a component set that doesn't work properly doesn't sound like the smartest thing to do. But maybe creating a view that is in uppercase, e.g.
>
> CREATE VIEW TBLSTAFF SELECT * FROM "TblStaff"
>
> would be a way for you to not notice this particular error (and if you have the same problem with columns, it is probably just to specify the column names in the CREATE VIEW statement).
>
> HTH,
> Set
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of blizzardb2001
> Sent: 28. august 2009 12:11
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] If Server receives <SELECT * FROM TBLSTAFF> make it <SELECT * FROM "TblStaff">
>
> I have a major problem.
>
> I've just moved all my data components to Devart's Interbase Data Access Components - I've even paid $100.00 and ordered a license.
> Unfortunately they have a bug that will only be fixed later...
>
> Under some circumstances it will put the table name in UPPERCASE.
>
> Is there any way to map the UPPERCASE field names to the Proper field names on the server side?
>
> So literally I could execute a query like this:
> SELECT * FROM TBLSTAFF
> and it would fetch me SELECT * FROM "TblStaff" ?
>
> Thanks!
>