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 Error: Dynamic SQL Error SQL error code = -104 Unexpected end of command - line 1, column 30

I have backed up and restored the database just in case it was some kind of corruption. The problem persisted after that. It is possible to display and edit data in an DevEx Express Grid. The problem only seems to exist when I try to Insert from Delphi.

Actual Delphi Code (qAR is the TIBCQuery):

  With DM.qAR do

  begin

    iCarrierNo := FieldByName('CarrierNo').AsInteger;

    sCarrier := FieldByName('Carrier').AsString;

    sInvoiceNo := FieldByName('InvoiceNo').AsString;

 

ShowMessage('1');

    Insert;

ShowMessage('2');

      {Duplicate AR field values}

      FieldByName('CarrierNo').AsInteger := iCarrierNo;

      FieldByName('Carrier').AsString := sCarrier;

      FieldByName('InvoiceNo').AsString :=  sInvoiceNo ;

and so on....

   

It gets as far as the Showmessage('1'), but does not reach Showmessage('2'). 

I hope I've given enough info for you to understand what's going on. I've tried what I know, which apparently isn't much.

Thanks in advance.