I looked through previous topics, and although this seems like a common error,
I didn't find one quite like my situation. I'm using a TIBCQuery in Delphi
2007. SQL.Text := 'Select * From AR ORDER BY DueDate, TransDate, PolNum;'; The
error occurs when I issue an Insert, or Close command. Actual
I thought I had it fixed by switching to a different TIBCQuery to insert a new
record. That worked fine. However, the same problem exists when I try to alter
the SQL in order to "filter" the result set in the grid.
The exact same error (exactly the same) happens when I close the query to
alter
Thanks, Steve, but that was one of the first things I tried. Didn't work. I
solved the insert problem by using a different TIBCQuery component, however now
I can't close the query without producing the same error. Please see the code
in my prior post.
Thanks for the advise. I sincerely appreciate it. In my defense, this Delphi
application has just shy of 900,000 lines of my code. The Data Module alone has
115 TIBCQueries. As you might imagine, they all successfully execute Insert,
Post, Open, and Close commands more times than I can count. No
Thank you, Svein. I like the param idea. As you might be able to tell, this
piece of the project is still under development. Now is a perfect time for me
to switch to parameters.
I solved my problem late last night. It was not easy to isolate. I usually set
break-points and step through the