Databases
StackOverflow2013
Usersdbo
USDean MacGregor
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USDean MacGregor
    primarykey
    data
    text
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. POSubtract every column from each other column in a R data.table
      singulars
      1. PTQuestion
    3. POUse Perl to download files from website that requires a p12 certificate
      singulars
      1. PTQuestion
    1. POsubsetting and combining/matching data
      singulars
      1. PTQuestion
    2. POOptimize SQL view/query with self joins
      singulars
      1. PTQuestion
    3. POR data.frame character column doesn't behave as expected
      singulars
      1. PTQuestion
    1. VO
      singulars
      1. POIs there a way to make UDF that gives a description like the native Excel functions have when user clicks the Fx button?
      1. USDean MacGregor
      1. VTFavorite
    2. VO
      singulars
      1. POHow can I truncate a datetime in SQL Server?
      1. USDean MacGregor
      1. VTFavorite
    3. VO
      singulars
      1. This table or related slice is empty.
      1. USDean MacGregor
      1. VTFavorite
    1. COI did the approach that required 100,000 SQL queries just to see how bad it performed and it was unacceptably slow, as expected. Your pseudo code was the most obvious solution for my needs but the problem is the "complex processing" part and it is the core of my question. My function will do 1 of 3 things, either retrieve data from cache(easy), create/append to a job list(easy), or create the cache from the joblist(doable) but the hard part is making it create cache during the last func call. (ie if user pastes func in 10k cells it should only create the cache once)
      singulars
      1. PO
      1. USDean MacGregor
    2. CO@Bulat, By batch I just meant, the queue of functions to be run like when a user pastes the same function in a bunch of cells. It seems like the application events that Charles suggested might do the trick just not sure how to implement it for my purpose. I'll play around with it and see what I learn.
      singulars
      1. POIs there a way for VBA UDF to "know" what other functions will be run?
      1. USDean MacGregor
    3. COEven in windows I found the odbcDriverConnect statement to be finicky, so much so that I never got it to work. Instead I use odbcConnect('odbc_dsn_entry', uid='username'). I know that ubuntu has a odbc manager that looks a lot like the one windows has but haven't done much with it to give more help especially in red hat. Also, I had more success with setting up the DB as both a user and system dsn in the odbc manager.
      singulars
      1. PORODBC not recognizing my odbc settings
      1. USDean MacGregor
 

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