Subject RE: [IBO] Problem in binding cursor?
Author Jason Wharton
It probably has to do with the join.
You might try setting KeyLinks blank and KeyLinksAutoDefine to false.
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@...]
Sent: Friday, September 10, 2004 1:57 PM
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 the
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?