To set up the unidirectional dataset

  1. From the General category of the Tool Palette, place a TSQLDataSet component at the top of the form.
  2. In the Object Inspector, select the SQLConnection property drop-down list. Set it to SQLConnection1.
  3. Set the CommandText property to an SQL command, for example, Select * from SALES.

For the SQL command, you can either type a Select statement in the Object Inspector or click the ellipsis to the right of CommandText to display the CommandText Editor where you can build your own query statement.

Tip: If you need additional help while using the CommandText Editor, click the Help button.

4. In the Object Inspector, set the Active property to True to open the dataset.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook

Post a comment