🚀 go-pugleaf

George Nakos wrote:
>                      GenQuery->First();
>                      GenQuery->Close();
>
> Here an exception is indeed thrown ("either BOF or EOF is True, 
> or the
> current record has been deleted") and the handler takes care of 
> it,
> as I thought.
>

This probably indicates you need the ADO patch from Borland.  BCB 
5 had two patches, one for the product in general and one for 
ADO.

>
> BTW I'm using BC++5 and MS Access as the database.
>

                     sprintf(send,"SELECT DISTINCT DriverNumber \
 FROM tbl_Drivers Tbl_drivers \
WHERE  DriverNumber = %d",pin);
                     GenQuery->Close();
                     GenQuery->Active=false;        // You don't 
need this.  Close() has already done this
                     GenQuery->SQL->Clear();
                     GenQuery->SQL->Text=send;
                     GenQuery->Open();

                    if ( GenQuery->Eof )
                        // ID doesn't exist

- Arnie