Databases
StackOverflow2013
Usersdbo
USRomnieEE2
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USRomnieEE2
    primarykey
    data
    text
    plurals
    1. POVBA Referring to a container object--syntax and object-oriented methodology
      singulars
      1. PTQuestion
    2. POVBA Array of variant type as class property
      singulars
      1. PTQuestion
    1. POVBA Array of variant type as class property
      singulars
      1. PTQuestion
    2. POVBA Referring to a container object--syntax and object-oriented methodology
      singulars
      1. PTQuestion
    3. POVBA maintaining the program in memory
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COthe set of trades underlying it, in memory consumption. Oh and Option-Portfolio is another object. The first thing that occurs to me is that maybe I could output the portfolio data to a sheet, and just read that instead of re-reading all the trades. The difficulty with that is creating a lot of code to export and import as text. (Would this be "serializing" an object in C#? Which presumably VBA can't do?) Aside from exporting and importing text (and maybe serializing), I don't know what else suggestion 4 would mean for this problem--?
      singulars
      1. PO
      1. USRomnieEE2
    2. COThanks, osknows. My first reactions are to your suggestions 1 and 6. First a little background: the transactions are option trades. Reading them takes a fair bit of processing, because they come from different sources with eg different sign conventions and units. And because some features have to be computed. I read each trade into an Option-Deal object. I then compile the deals into several different (overlapping) portfolios--trading desk, trading book (under a desk), underlying type, etc. The user selects a particular portfolio from all the combinations. A portfolio is much smaller than...
      singulars
      1. PO
      1. USRomnieEE2
    3. COThanks. So I've tried a quick web search, and didn't find it: but you are saying that there's away to access Forms properties in VBA by unhiding them? I should be able to experiment and get the idea--except how do I get started? To see one Form object, as an example? Thanks again.
      singulars
      1. PO
      1. USRomnieEE2
 

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