When you put a name inside of double quotes then it becomes case sensitive.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Thursday, June 13, 2013 3:10 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] IBO 4.8.7 to IBO 5.2.0 6

Hi Set

Thanks for that. Totally understand the issue with reserved words. The
code and FB version are the same, the only thing changed is the IBO
version. We could do Aliases as you mention but that would be a major
change and some of our stuff is using TIBOTable components !

We have coded our reserved words as "Rows" and I wonder if that's the
issue, perhaps IBO now expects them to be all Caps?

Thanks
Rob

On 13/06/2013 6:41 p.m., Svein Erling Tysvær wrote:
>> Hi
>> We have been porting our main application from D2007 (IBO 4.8.7) to
>> XE2 and IBO 5.2. I finally have all the components installed and
>> running and have just run our app for the first time.
>>
>> The first issue I have encountered is the following lines failing with
>> a 'Field not found' message...
>>
>> ItemNameSize := FieldByName('NameS').AsInteger;
>>
>> Rows := FieldByName('Rows').AsInteger;
>>
>>
>> I take it that this is because the related fields are both reserved
>> words (they stem from a Dbase table that was ported to Firebird). The
>> data shows ok in a grid but it seems the field by name fails. This
>> seems to be a change in behaviour from the previous IBO version. Is
>> there any thing we can do to work around this?
> Changing your select to something like
>
> SELECT "ROWS" as ROBROWS
>
> could be a simple way to circumvent the problem.
>
> I guess the error is due to reserved words having to be double quoted to
be a field name, but double quoting also makes the field case sensitive, so
"Rows" is no longer the same as "ROWS". Don't know whether your error is due
to IBO or Firebird, though. If the Firebird version hasn't changed between
your D2007 and XE2 program, I guess IBO is likely to be at fault, although
for all I know there could be a ReadMe file included in 5.2.0 that provides
upgrade instructions to be adhered to or some new error in your program
code.
>
> Set
>
>
> ------------------------------------
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3345 / Virus Database: 3199/6408 - Release Date: 06/13/13
>
>



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links