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


Groups > comp.lang.clipper.visual-objects > #10586 > unrolled thread

ADS Datareader and 2 tables

Started byJürgen Knauf <trotterklaus@googlemail.com>
First post2017-05-12 06:16 -0700
Last post2017-05-16 07:50 +0000
Articles 5 — 2 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#10586 — ADS Datareader and 2 tables

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2017-05-12 06:16 -0700
SubjectADS Datareader and 2 tables
Message-ID<da19227c-af76-4e72-be33-e8c774e2811d@googlegroups.com>
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

[toc] | [next] | [standalone]


#10587

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2017-05-13 02:50 -0700
Message-ID<0c6659e6-921c-4769-bb2a-389fe53d5f90@googlegroups.com>
In reply to#10586
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!

[toc] | [prev] | [next] | [standalone]


#10588

From"Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be>
Date2017-05-15 07:13 +0000
Message-ID<ofbkfh$d1t$1@dont-email.me>
In reply to#10587
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

[toc] | [prev] | [next] | [standalone]


#10589

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2017-05-15 00:54 -0700
Message-ID<8587d50f-9931-4f89-9881-2fcccc33a776@googlegroups.com>
In reply to#10588
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

[toc] | [prev] | [next] | [standalone]


#10595

From"Dirk (Belgium)" <dirk.dot.herijgers@pbprojects.dot.be>
Date2017-05-16 07:50 +0000
Message-ID<ofeb00$1l0$1@dont-email.me>
In reply to#10589
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

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web