Databases
StackOverflow2013
Usersdbo
USmcottle
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USmcottle
    primarykey
    data
    text
    plurals
    1. This table or related slice is empty.
    1. POCalling a DLL from an Applet via JNI
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CODelphi's not ideal for this unless you use the RegExp library. I would recommend writing a PERL script to parse the DFM and extract the SQL. I did something similar to convert TTable/TQuery components to the DOA "equivalents" and that involved keeping the pas & dfm in synch as you were modifying the files. Use the right tool for the job. In this case a scripting language with a good implementation of regular expressions. PERL might not be your cup of tea but you should be able to find something you like Python, Ruby?
      singulars
      1. PO
      1. USmcottle
    2. COYou can create forms in different ways but the ways you describe involve you having to write extra code for no apparent gain. Why would you want to deliberately do things the "non-Delphi" way? If you create a form or Datamodule in the IDE Delphi helpfully allows you to create it at runtime using Application.Createform statements that it puts into the .dpr. In 16 years of working with Delphi I have yet to see any evidence that Application.Createform is inherently inefficient or undesirable for forms that are needed for the lifetime of the application which seems to be the authors assertion.
      singulars
      1. PO
      1. USmcottle
    3. COIf one panel on a form has a name you don't need to register the class - Delphi does it automagically. Same for Labels. If you need to reference a panel (or Label) programatically you really need to name it (you could iterate through controls but.. why?) That way the number of Panels and labels in the form object declaration is equal to the number that you have to reference at runtime - and they'll have meaningful names not "Label1" won't they :). The main form is any other form - the .dpr project file is the the REAL main procedure. You could try Registering a class there but I can'
      singulars
      1. PO
      1. USmcottle
 

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