[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

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

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

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.

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

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