Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: FDQuery Post() Error (False Alarm)


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: May 19, 2017 7:49 PM Last Post By: Earl Staley Threads: [ Previous | Next ]
Earl Staley

Posts: 99
Registered: 4/9/07
FDQuery Post() Error (False Alarm)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 19, 2017 6:46 PM
I am getting this error:

Project BCC_Member1.exe raised exception class EFDException with message '[FireDAC][Phys][SQLite]-310. Cannot execute command returning result sets. Hint: use Open method for SELECT-like commands'.

when this line executes:
DataModule1->FDQueryMember->Post();

The DataModule1->FDQueryMember->State is 3/*dsInsert*/ so I should be able to post the record.

So why do I get the error?

I am using C++ 10.1 Berlin.

Earl Staley

Edited by: Earl Staley on May 19, 2017 7:45 PM
Earl Staley

Posts: 99
Registered: 4/9/07
Re: FDQuery Post() Error (False Alarm)  
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 19, 2017 7:49 PM   in response to: Earl Staley in response to: Earl Staley
It turns out that I had a BeforePost method that was using an ->ExecSql instead of a ->Open() method to increment an index.

Sorry for the confusion.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02