Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Relational Databases
Expertise: Beginner
May 13, 1997

Unknown EDBEngineError

Question:
I am getting an usual message from exception class EDBEngineError. The message is simply: "At beginning of table." What does that mean? I am building a TQuery SQL property in code like the following:
with MyQry do
  begin
    Close;
    RequestLive := True;
    SQL.Clear;
    SQL.Add('SELECT * FROM "mytable.db"');
    SQL.Add('WHERE (Status = 1)');
    Open;
  end;
When I get to the "Open," I get the error, but only while running under the Delphi debugger. When I compile a stand-alone .exe, I no longer get the error. Another point of interest: It seems to occur only when the table is empty.

Any ideas?

Answer:
You're getting the error because TQuery expects to point to a dataset that has data in it. It's a dumb error message, but it's basically saying that "this is a new table with no data, so I'd be wasting my time if I queried this "

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date