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
At 10:37 a.m. 9/01/2014, ho...@agencybusys.com wrote:
I looked through previous topics, and although this seems like a common error,
I didn't find one quite like my situation.
You realise this is a problem with your Delphi client code, don't you? And
that this list is not a Delphi support
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.
1. Your insert is failing, but you haven’t provided us with the SQL you
are using for an insert. Also, check the refresh SQL property of your DB
component.
2. I notice you have an ; at the end of all your SQL. I don’t think that
is necessary when entering the SQL into the SQL