What would cause Query not to work second time?

From: Todd Jaspers (tjaspers_at_bellsouth.net)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 15:56:11 -0400

Hey guys...

    I have a service that runs several queries. The service will start up
fine and run the query. However, when I try to run a query twice, it freezes
up. By freezes up, I mean that the service will stay in the "started" mode,
but simply will not do anything.

My query looks like this.

      RM_DATA.RM_DM.RM_Input.SQL.Clear;

      SQLStatement := ('UPDATE REPORT_DATA '
                     + 'SET REPORT_DATA.[REPORTED] = 1 '
                     + 'WHERE REPORT_DATA.ID=' + Acc_ID[RepID]);

       RM_DATA.RM_DM.RM_Input.SQL.Text := SQLStatement;
       RM_DATA.RM_DM.RM_Input.ExecSQL;
       RM_DATA.RM_DM.RM_Input.Close;

The SQL.Active := True is done ahead of time.

What in here would cause this to not work the second time it runs?

I would call this query twice. Once RIGHT after the first (just for
testing).

Thanks!

Todd