Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10595
| From | "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: ADS Datareader and 2 tables |
| Date | 2017-05-16 07:50 +0000 |
| Organization | A noiseless patient Spider |
| Message-ID | <ofeb00$1l0$1@dont-email.me> (permalink) |
| References | <da19227c-af76-4e72-be33-e8c774e2811d@googlegroups.com> <0c6659e6-921c-4769-bb2a-389fe53d5f90@googlegroups.com> <ofbkfh$d1t$1@dont-email.me> <8587d50f-9931-4f89-9881-2fcccc33a776@googlegroups.com> |
Thanks a lot.
Cheers, Dirk
==========================================
Jürgen Knauf wrote:
> Am Montag, 15. Mai 2017 09:17:15 UTC+2 schrieb Dirk (Belgium):
> > Jürgen Knauf wrote:
> >
> > > Am Freitag, 12. Mai 2017 15:16:12 UTC+2 schrieb Jürgen Knauf:
> > > > Hi,
> > > >
> > > > how can I get the second table in a datareader, which is created
> > > > with an inner join command:
> > > >
> > > >
> > > >
> > > > Example:
> > > > genCmd.CommandText = "SELECT tmGenerator.bez,t.bez FROM
> > > > tmGenerator INNER JOIN " + "[" + Globals.cQuellPfad + "\\" +
> > > > ctmDatabase + "]"+ "t ON tmGenerator.nr = t.nr where
> > > > tmGenerator.nr = t.nr"
> > > >
> > > >
> > > > while (readGenerator.Read())
> > > > {
> > > >
> > > >
> > > > MessageBox.Show(readGenerator["t.BEZ"].ToString());
> > > >
> > > > MessageBox.Show(readGenerator["tmgenertaor.BEZ"].ToString()); }
> > > >
> > > >
> > > > Juergen
> > >
> > > Problem solved!
> >
> > How dit you solve it?
> >
> > Cheers,
> > Dirk
>
> MessageBox.Show(readGenerator["t.BEZ"].ToString());
>
> The combined fields can be addressed with a "_1" Char.
> Example: MessageBox.Show(readGenerator["BEZ_1"].ToString());
>
> Juergen
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread
ADS Datareader and 2 tables Jürgen Knauf <trotterklaus@googlemail.com> - 2017-05-12 06:16 -0700
Re: ADS Datareader and 2 tables Jürgen Knauf <trotterklaus@googlemail.com> - 2017-05-13 02:50 -0700
Re: ADS Datareader and 2 tables "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2017-05-15 07:13 +0000
Re: ADS Datareader and 2 tables Jürgen Knauf <trotterklaus@googlemail.com> - 2017-05-15 00:54 -0700
Re: ADS Datareader and 2 tables "Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be> - 2017-05-16 07:50 +0000
csiph-web