Subject Difference 'tween Open & First (IB_Cursor)
Author Ryan Nilsson-Harding
Hi there,

I have been writing an import routine which imports data from around
50 tables (BDE) into my new Firebird DB.

For this, I'm using TIB_Cursors to query certain tables, and step
through the data, etc.

All of a sudden I was getting really unusual PK and FK violations,
when I knew there should have been none. After pulling my hair out
for a while, I realised that a lot of the Cursors were being opened
with .Open instead of .First.

Once I changed all these to .First, all went smoothly again.

Could someone please explain why First is THE way to open a cursor,
and why using Open can occasionally give unexpected results?