Subject Re: [IBO] Problem in binding cursor?
Author sgharp
Hi Jason,

I set KeyLinks blank and KeyLinksAutoDefine to False per your
suggestion and I still get the same error.


--- In, "Jason Wharton" <jwharton@i...>
> It probably has to do with the join.
> You might try setting KeyLinks blank and KeyLinksAutoDefine to
> When using a query like this it may be best not to try and have
the nice
> functionalities that IBO provides for buffered datasets.
> Jason Wharton
> -----Original Message-----
> From: sgharp [mailto:steve@h...]
> Sent: Friday, September 10, 2004 1:57 PM
> To:
> Subject: [IBO] Problem in binding cursor?
> Hi All,
> I'm using a TIBOQuery's DeleteSQL property to delete a record and
> getting the error "Problem in BindingCursor". The systax of the
> DeleteSQL is
> execute procedure spUpdateMajorSetup
> (:MajorID, :MajorName, :GroupID, 'Y');
> where it's calling a stored procedure. The stored procedure works
> fine in IBExpert.
> The SQL statement for the query is
> select ma.MajorID, ma.MajorName, ma.GroupID, gr.GroupName
> from xMajor ma
> join xGroup gr on gr.GroupID = ma.GroupID
> where ma.MajorID = :MajorID
> My KeyLinks is set to xMajor.MajorID which is the primary key of
> xMajor table.
> The strange thing is that I'm using essentially the same type of
> process with another query object and a different (but similar)
> stored procedure in another part of the program and it works fine.
> What am I missing?
> Thanks,
> Steve