Delphi: Delphi And Microsoft Sql Server 2005 Bad Calculations From Function Values

When i send this query on SQL Server 2005 with the Microsoft SQL Server Management Studio SELECT dbo.MOV('Hi',10,2) + dbo.MOV('Hi2',8,2) The query returns 400 The result of anythi

Solution 1:

Try to clear Query.SQL before Query.SQL.Add.

Query.SQL.Clear
Query.SQL.Add('SELECT dbo.MOV(''Hi'',10,2) + dbo.MOV(''Hi2'',8,2)');

If you already have a query stored in SQL you will only see the result from the first one.