Board index » cppbuilder » Locate with VCL Components and Firebird

2004-10-31 12:31:35 AM
cppbuilder79
What is the story with VCL Components and locate for Firebird ?
I posted a message yesterday about having problems with using locate on
a Firebird database. I was told to try IB Objects, which I have done.
End result - nil, zero, I am still getting the same message "Multiple
rows returned for singleton select", only now I also get it when I try
to set the table to the first record with table->First() or Bof.
So what's the problem?
Am I missing something here or what?
I have done this with Oracle, PostgreSQL and Sybase without all
this hassle.
Can somebody help me sort this out or point me in the right direction,
because at this moment in time, I am seriously thinking of ditching
C++ Builder and Firebird and using Visual C++ and SQL Server!
Thanks
Trevor
 

Trevor < XXXX@XXXXX.COM >wrote:
diverged. The IB components may not work. I would suggest that
you look at FB's page for components.
is more likely with another property in the TIBDataBase or
TIBTable.
Second, you should not be using Locate on a Table. You should
use a select with a TIBDataSet and the use Locate on that. In
fact, when it comes to IBX, I have never accessed the TIBTable
directly. I have always used a TIBDataSet. Much richer, much
more simple and much more flexible. You can do everything with
a TIBDataSet - period.
and I prefere IBX. BTW: Be aware that this is the wrong place
to be asking this question. The correct group would be one of
the database groups.
~ JD