RE: [firebird-support] RE: SQL error code = -104 Unexpected end of command, from Delphi App

2014-01-09 Thread homer
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

[firebird-support] SQL error code = -104 Unexpected end of command, from Delphi App

2014-01-08 Thread homer
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

[firebird-support] RE: SQL error code = -104 Unexpected end of command, from Delphi App

2014-01-08 Thread homer
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

[firebird-support] RE: SQL error code = -104 Unexpected end of command, from Delphi App

2014-01-08 Thread homer
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.

Re: [firebird-support] SQL error code = -104 Unexpected end of command, from Delphi App

2014-01-08 Thread homer
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.