🚀 go-pugleaf

OK, it all works.  I am a dope, and was typing test1 and test2, when teh
fields were named tests1 and tests2.  I guess they were right when they said
attention to details are important.

Thanks for your help...

Lee

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:3f58b59b@newsgroups.borland.com...
> Oops, you are absolutely right.
>
> ----------------------------------------------------------------
> 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.
>
> "Arnie Mauer" <arnie@earthlink.net> �������/�������� � �������� ���������:
> news:3f58a732$1@newsgroups.borland.com...
> > 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
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>