Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10588

Re: ADS Datareader and 2 tables

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-15 07:13 +0000
Organization A noiseless patient Spider
Message-ID <ofbkfh$d1t$1@dont-email.me> (permalink)
References <da19227c-af76-4e72-be33-e8c774e2811d@googlegroups.com> <0c6659e6-921c-4769-bb2a-389fe53d5f90@googlegroups.com>

Show all headers | View raw


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

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


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