🚀 go-pugleaf

Actually,
SELECT Test1+Test2 AS Total FROM Tests WHERE ID='1'

- Arnie

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:3f587dfb@newsgroups.borland.com...
> SELECT Test1+Test2 AS Total FROM Tests AS Total WHERE ID='1'
>
> ----------------------------------------------------------------
> Regards,
> Viatcheslav V. Vassiliev
> http://www.oledbdirect.com
> The fastest way to access MS SQL Server, MS Jet (MS Access)
> and Interbase (through OLEDB) databases.
>
> "Lee" <gobroski@elltel.net> �������/�������� � �������� ���������:
> news:3f58439e$1@newsgroups.borland.com...
> > I have a table called Tests, I am trying to add Column 2 with Column 3
> > Titled Test1 and Test2.  They both have Values of 100 on them.  This is
> the
> > code I am attempting to use:
> > Data->TestQuery->SQL->Text = "SELECT Test1+Test2 FROM Tests AS Total
WHERE
> > ID='1'";
> > Data->TestQuery->ExecSQL();
> >
> > The table has 4 columns, ID (int) Test1(Int) Test2(Int) Totals(Int)
> >
> > I need getting Syntax Error (Missing Operator)
> >
> > What am I doing wrong....
> >
> > Thanks
> > Lee
> >
> >
> >
> >
> >
>
>