🚀 go-pugleaf

I tried the code that Arnie posted.  I still get the Test1 has no default
value.  Also I thought that you only needed the single quotes on string
values?  The ID is a number.

Thanks for your help.

Lee

"Arnie Mauer" <arnie@earthlink.net> wrote in message
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
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>