Subject RE: [IBO] Problem in binding cursor?
Author Jason Wharton
KeyLinks set?

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?