🚀 go-pugleaf

This doesn't works.
I use Jet 4.0
with a ADOQuery and a DBGrid.

rainer

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> schrieb im Newsbeitrag
news:3ea14f97@newsgroups.borland.com...
> This depends on your DBMS. In MS SQL Server use (pubs db):
>
> Select (au_lname + ', ' + au_fname) as [name] from authors
>
> ----------------------------------------------------------------
> 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.
>
> "Rainer Welzel" <rainer@fgg-welzel.de> �������/�������� � ��������
> ���������: news:3ea14b69@newsgroups.borland.com...
> > Hi ,
> > I failed to combine 2 fields  with the following statement:
> >
> > ADOQueryIND->SQL->Add("SELECT Name, City & ', ' & Country AS Location
FROM
> > tblIndi");
> >
> > also
> >
> > ADOQueryIND->SQL->Add("SELECT Name, City || ', ' || Country AS Location
> FROM
> > tblIndi");
> >
> > this statement failed.
> >
> > Have anybody the right syntax ??
> >
> > thx rainer
> >
> >
> >
>
>