Re: Delphi SQL problems in a Windows NT Service?
Posted by webmaster Guido on June 30, 2004 at 17:25:28:
In Reply to: Delphi SQL problems in a Windows NT Service???? posted by Todd Jaspers - NA on June 28, 2004 at 16:42:04:
: (in a Windows NT Service...)
: I am connected from the very beginning (set Active := True property in the beginning), and this is my code that I use...
: ShowMessage (SQLStatement);
: RM_DATA.RM_DM.RM_Input.SQL.Text := SQLStatement;
Are you using a TQuery component? In that case, try to close the query before changing the SQL, like this:
Query1.Close; // here, change the SQL: // ... Query1.ExecSQL;