conn.Open();
            cmd = conn.CreateCommand();
            cmd.CommandText = "select AT_FILE from ATTACH where AT_ORDNR = '069007'";
            reader = cmd.ExecuteReader();
            reader.Read();

            myVar.snelkoppeling = reader[0].ToString();

The question is in record AT_FILE (069007) are 7 shortcuts in 1 record this is not a array how do I get the other 6 in the reader[]

asked 10 Feb '15, 08:03

Teuntje's gravatar image

Teuntje
1113
accept rate: 0%


You can use

while ( reader.Read() )

The help file has an example:

AdsCommand.ExecuteReader

link

answered 10 Feb '15, 08:09

Edgar%20Sherman's gravatar image

Edgar Sherman
5.4k13185
accept rate: 25%

Thanks this works

(10 Feb '15, 08:32) Teuntje
Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×79
×76

Asked: 10 Feb '15, 08:03

Seen: 1,484 times

Last updated: 10 Feb '15, 08:32

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.