Databases
StackOverflow2013
Usersdbo
USCary Jensen
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USCary Jensen
    primarykey
    data
    text
    <p>Developer, consultant, trainer, and author. In addition to being a professional database developer for more than 25 years, Cary has focused on communicating information about software technology and development techniques to developers, and interfacing between developers and clients. Best-selling author of more than twenty books on computer software, and hundreds of magazine and Web articles, Cary is also an award-winning trainer and internationally-respected speaker at software conferences. His interests include database development, database design, user-interface design, client-server architecture, object-oriented development, Web browser-based applications, Web services, Delphi, and SQL. He is an Embarcadero MVP, and holds a PH.D. from Rice University in Engineering Psychology, specializing in human/computer interaction.</p>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. POWhat values do I pass to the Attributes parameter of SQLConfigDataSource to create a system DSN for the Microsoft Paradox Driver
      singulars
      1. PTQuestion
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYour solution is a good one, in that you can still reliably refer to specific TFields by their known physical location in the structure of the underlying DataSet. The limitation is, as you've pointed out, this works for ADO DataSet only. However, you sent me back on second search for a corresponding member of the TFields class. This class has a FieldByNumber method, which is invariant with respect to the order of Columns in an associated grid. FieldByNumber is like your Item property. I've added an answer to the question that explains FieldByNumber in more detail than is availale here.
      singulars
      1. PO
      1. USCary Jensen
    2. COI don't think that this is a bug. It may be unexpected, simply because it is a little known artifact, but it doesn't look like a bug.
      singulars
      1. POMoving Columns in a DBGrid seems to move the attached DataSet fields
      1. USCary Jensen
    3. COThere is a question, which appears in the second sentence: "Is it something internal to the TDataSet class, an artifact of the TDBGrid, or something else?" I spend some time (an hour or so) searching both the TCustomGrid and TDataSet source, but didn't see where this is happening. More importantly, and this is why my post is so long, I wanted to at least make Delphi developers aware of this interesting behavior. For anyone who is using a DBGrid, or some other similar grid that produces these changes in the TFields order, it could be a source of an intermittent, and difficult to find bug.
      singulars
      1. POMoving Columns in a DBGrid seems to move the attached DataSet fields
      1. USCary Jensen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload