Number of rows seams to be o.k. but everytimes the same content.
An Example may explain the problem better...
correct resultset of sqlserver view looks like:
ProbeNr; Parameter; ErgText; ErgDatetime
2203021-HB; I ProbeNr; 2203021-HB I; NULL
2203021-HB; I Zeitpunkt der Probenahme; NULL; 2011-11-11 00:00:00.000
2203021-HB; I Art der Probenahme; Test; NULL
2203021-HB I; technische Bezeichnung der Entnahmestelle; HBK; NULL
2203021-HB I; Name des Probenehmers; MrX; NULL
2203021-HB I; Anmerkungen zur Probenahme; testhalber; NULL
2203021-HB I; KundenNr; 001; NULL
2203021-HB I; AuftragsNr; 001b; NULL
2203021-HB I; Name des Labors Institut Fresenius; NULL
2203021-HB I; Probe Bezeichnung 1; xxxx; NULL
resultset of the same view linked to MS Access gives allways the same (first) record back...
v_chemheader
ProbeNr |
Parameter |
ErgText |
ErgDatetime |
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
2203021-HB I |
ProbeNr |
2203021-HB I |
|
<tfoot></tfoot>
Any Ideas?
Thanks for answering!
Bolger