Error: No Current Record

Thread View: borland.public.cppbuilder.database.ado

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Jan Wed, 16 Mar 2005 17:36

#935

Author: Jan
Date: Wed, 16 Mar 2005 17:36

8 lines
1077 bytes

I am trying to execute an SQL Statemet but getting the following error:
No Current Record.
I am using BCB6, ADO, MS Access Database

What is the reason of this error and how can I solve it?

Thanks

Re: Error: No Current Record

#936

Author: Viatcheslav V. Vassiliev
Date: Thu, 17 Mar 2005 17:21

20 lines
1594 bytes

Do you have index or primary key on all tables affected by your query?

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Jan" <Jan98@yahoo.com> �������/�������� � �������� ���������: 
news:42386e83$1@newsgroups.borland.com...
>
> I am trying to execute an SQL Statemet but getting the following error:
> No Current Record.
> I am using BCB6, ADO, MS Access Database
>
> What is the reason of this error and how can I solve it?
>
> Thanks

Re: Error: No Current Record

#939

Author: Nigel
Date: Wed, 23 Mar 2005 09:40

17 lines
1403 bytes

Hi,
Try setting you ExecuteOptions eoExecuteNoRecords to true (A command or 
stored procedure that does not return. If any rows are retrieved, they are 
discarded and not returned.)

Nigel

"Jan" <Jan98@yahoo.com> wrote in message 
news:42386e83$1@newsgroups.borland.com...
>
> I am trying to execute an SQL Statemet but getting the following error:
> No Current Record.
> I am using BCB6, ADO, MS Access Database
>
> What is the reason of this error and how can I solve it?
>
> Thanks

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads