Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10586
| Newsgroups | comp.lang.clipper.visual-objects |
|---|---|
| Date | 2017-05-12 06:16 -0700 |
| Message-ID | <da19227c-af76-4e72-be33-e8c774e2811d@googlegroups.com> (permalink) |
| Subject | ADS Datareader and 2 tables |
| From | Jürgen Knauf <trotterklaus@googlemail.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
Back to comp.lang.clipper.visual-objects | Previous | Next — Next 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