🚀 go-pugleaf

Hi Viatcheslav ,
your right, it must something with the Fieldnames.
Here my used Fieldnames:

Fieldname => NachName, Typ => Text , Comment => Surname of Individual.  Use
Maiden name for women.
Fieldname => VorName, Typ => Text , Comment => Name of the Individual

it doesn't works. In the DBGrid I see only the first Field.

I tray an other pair of the above table.
Fieldname => BirthDate, Typ => Text , Comment => Date of Birth.
Fieldname => BirtPlac, Typ => Text , Comment => Place of Birth

In the StringList Editor of the ADOQuery Component the Statement:

SELECT BirthDate + ", " + BirthPlac AS  Birth FROM tblIndividual
works very well -- I see two Fields in the DBGrid :
----------------------------------------------------------------------------
--
If there some Information on  special keywords for Fieldnames ???

Thank you for your help.

Rainer


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> schrieb im Newsbeitrag
news:3ea24fdc@newsgroups.borland.com...
> What error do you have? Note that Name is special keyword and use:
>
> Select [Name], ([City] + ', ' + [Country]) as [Location] from [tblIndy]
>
> If City or Country is not string column, use
>
> Select [Name], (CStr([City]) + ', ' + CStr([Country])) as [Location] from
> [tblIndy]
>
> If this does not help, install latest MDAC and Jet SP.
>
> ----------------------------------------------------------------
> 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:3ea23628@newsgroups.borland.com...
> > 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
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>