Yes, I did, and it won't compile. I get the following error (BCB4):

'Fields' is not a member of 'TIB_Row'.

Here is my code:

ScratchCursorX->Close();
ScratchCursorX->SQL->Clear();
ScratchCursorX->SQL->Add(thequery);
ScratchCursorX->Open();
if (ScratchCursorX->Eof)
return 0;
else
return ScratchCursorX->Fields->Fields[0].AsInteger;

It's the last line that causes the compile to generate the above error.

-Joe

At 10:07 PM 4/29/2003 -0700, you wrote:

>Apparently you didn't try that exact code.
>Go ahead and try, it should be the same.
>
>Jason Wharton
>CPS - Computer Programming Solutions
>Mesa Arizona
>http://www.ibobjects.com
>
>-- We may not have it all together --
>-- But together we have it all --
>
>----- Original Message -----
>From: "Joe Martinez" <joe@...>
>To: "IB Objects" <IBObjects@yahoogroups.com>
>Sent: Tuesday, April 29, 2003 9:49 PM
>Subject: [IBO] Getting column reference from TIB_Cursor?
>
>
> > What property or method do you use to retrieve a TIB_Column from a
> > TIB_Cursor, by index, rather than by name?
> >
> > For instance, Let's say, I want to get a pointer to the TIB_Column that
> > represents the first column in the data set. With TIBO_Query, I'd use:
> >
> > MyQuery->Fields->Fields[0]
> >
> > What is the equivalent in TIB_Cursor?
> >
> > -Joe
>
>
>
>
>___________________________________________________________________________
>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 !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/