I get "Operation must use an updatable query"  when I try to run this;  UPDATE survey  INNER JOIN assay_depths  ON survey.hole_id = assay_depths.hole_id  SET survey.depth = [assay_depths].[max_depth] WHERE survey.depth = -1;   The problem is in the WHERE. Something to do with the '-1'?  UPDATE:  hole_id         azimuth   depth    dip 230DD93_L43         312    0       -78 230DD93_L44         318    34.2    -82 230ER99E33          315.5      -1      -65 230ER99E34          337.5      -1      -65
On some Microsoft Access queries, I get the following message:  Operation must use an updatable query. (Error 3073).  I work around it by using temporary tables, but I'm wondering if there's a better way.  All the tables involved have a primary key. Here's the code:  UPDATE CLOG SET CLOG.NEXTDUE = (     SELECT H1.paidthru      FROM CTRHIST as H1     WHERE H1.ACCT = clog.ACCT AND     H1.SEQNO = (         SELECT MAX(SEQNO)          FROM CTRHIST          WHERE CTRHIST.ACCT = Clog.ACCT AND          CTRHIST.AMTPAID &gt; 0 AND         CTRHIST.DATEPAID &lt; CLOG.UPDATED_ON     ) ) WHERE CLOG.NEXTDUE IS NULL;
Book recommendations Every once in a while, we get a question asking for a book or other educational reference on a particular topic at a particular level. This is a meta-question that collects all those links together. If you're looking for book recommendations, this is probably the place to start.  All the questions linked below, as well as others which deal with more specialized books, can be found under the tag  (formerly ).  If you have a question to add, please edit it in. However, make sure of a few things first:   The question should be tagged  It should be of the form "What are good books to learn/study [subject] at [level]?" It shouldn't duplicate a topic and level that's already on the list   Related Meta: biblatex: Tighter integration of \textcite "in the flow of text" This question led to a new feature in a package:      Many biblatex citation styles feature the \textcite command which is "intended for use in the flow of text, replacing the subject of a sentence" (manual, section 3.6.2). At the moment, this works well for citations of single works -- e.g. (assuming the authoryear style), one may write in the source  The reference work is \textcite{knuth:ct:a}.   which will be typeset as     The reference work is Knuth (1984).   Citing multiple works, on the other hand, is somewhat tedious. If one simply writes (1):  Important works are \textcite{knuth:ct:a,knuth:ct:b,markey}.   the output is rather a list than a correct sentence (2):     Important works are Knuth (1984); Knuth (1986); Markey (2005).   One has to write (3):  Important works are \textcite{knuth:ct:a}, \textcite{knuth:ct:b}, and \textcite{markey}.   to get (4):     Important works are Knuth (1984), Knuth (1986), and Markey (2005).   Can \textcite be modified so that input (1) will yield output (4), hereby achieving a tighter integration "in the flow of text"?  \documentclass{article}  \usepackage[style=authoryear]{biblatex}  \addbibresource{biblatex-examples.bib}  \begin{document}  This is how \texttt{\textbackslash textcite} currently works:\\ Important works are \textcite{knuth:ct:a,knuth:ct:b,markey}.  \bigskip  But I'd like \texttt{\textbackslash textcite} to output the following:\\ Important works are \textcite{knuth:ct:a}, \textcite{knuth:ct:b}, and \textcite{markey}.  \printbibliography  \end{document} Prove that for all $n&gt;2$ there exists at least one prime $p$ such that $\sqrt{n}&lt;p&lt;n$ using elementary methods.  My try: If not, $\sum_{p&lt;\sqrt{n}} (\lfloor n/p \rfloor-\lfloor \sqrt{n}/p \rfloor) \geq n-\sqrt{n}$  then...? I have always wondered why diamonds shine. Can anyone tell me why? The question Is there any way to automatically scale and put an entire document on an A0 page? The thesis for which this is to be done is available as LaTeX code, as well as PDF output. Of course I know it is possible to do this manually, but I would prefer a LaTeX solution.  A small background Our university introduced a new page limit for master theses. This is not exactly appreciated by the teaching staff as well as students. To make a little joke, we decided to try to arrange an entire thesis (of approximately 200 pages) on a A0 poster, put it up in the hallway, and put a magnification glass next to it with a note saying: &quot;New page limit introduced: 1 page maximum for all upcoming theses!&quot;  The final result As some of you asked for this: below you can see a picture of the final result. (I &quot;professionally removed&quot; some of the sensitiv information.) We presented the poster during my final presentation and everyone liked it a lot! Now, it is on display next to my office and is still attracting some attention once in a while. How do you retrieve items from a dictionary in the order that they're inserted? Is it possible to retrieve items from a Python dictionary in the order that they were inserted? Editing Gsettings unsuccesful when initiated from cron Showing that $\int_0^\infty x^{-x} \mathrm{d}x \leq 2$. This is what I see:  GNU GRUB version 2.02~beta2-9ubuntu1  Minimal BASH-like line editing is supported. For the first word, TAB lists possible command completions. Anywhere else TAB lists possible device or file completions.  grub&gt; _   What should I do now? Let's say we have two models trained. And let's say we are looking for good accuracy.  The first has an accuracy of 100% on training set and 84% on test set. Clearly over-fitted. The second has an accuracy of 83% on training set and 83% on test set.   On the one hand, model #1 is over-fitted but on the other hand it still yields better performance on an unseen test set than the good general model in #2.   Which model would you choose to use in production? The First or the Second and why? There are some .exe and .dll files belonging to some programs on my laptop which communicate with the internet without my permission (for self-update generally). I want to prevent those files one by one from accessing the internet. I don't want to install any external firewalls. I'm using Windows 7 Home Pro and if this can be done by Windows Firewall, it's OK. I took a look at Windows Firewall but couldn't find a setting to disable file access. ActiveResource timeout not functioning Atomic clocks were used in Hafele and Keatings experiment which supposedly helped to prove time dilation.    How can we be sure other forces didn't act upon the clocks as a result of their being at different speeds and elevations? Perhaps the elapsed time may have been the same for all and only appeared different as a result of the clock's atoms behaving differently in different environments.  How might the presence of dark matter (presumably all over the place) impacted the clocks if say the dark matter is stationary relative to the earth's rotation?  What experiments have been done to test the constancy of clocks at different speeds and elevations? Convergence of $\sum\limits_{n=2}^\infty \frac{1}{n^\alpha \ln^\beta (n)} $ for nonnegative $\alpha$ and $\beta$ Study the convergence of the following series: $$\sum_{n=2}^\infty \frac{1}{n^\alpha \cdot\ln^\beta(n)} \text{ where }\alpha,\beta \geq 0 $$   Applying d'Alembert criterion I have that $$ \lim_{n\to\infty} \frac{n^\alpha  \ln^\beta(n)}{(n+1)^\alpha  \ln^\beta (n+1)} = \lim_{n\to\infty} \left(\frac{n}{n+1}\right)^\alpha\left(\frac{\ln(n)}{\ln (n+1)}\right)^\beta = 1$$ so the nature of the series is inconclusive.  If $\alpha = \beta = 0$, then the series diverges, since $\sum_{n=2}^\infty 1 = \infty$.  Should I study the rest of the cases (i.e. if $\alpha = 0, \beta &gt; 0$ the root test and the ratio test are also inconclusive). What is the best form to study the series?.  Thanks in advance Extruding surface while keeping the shape here is the picture of what I would like to get(example nr. 2). I need the edge frame to be same in width and length. Also the extrusion is on surface (without depth) I tried extruding region, but it did not give me the result I wanted.   I know I could just adjust the scale and do it manually, but that would be eyeballing without achievign accuracy. I would like to know if it is possible to extrude or inset while keeping the shape (even edge space) Why does Ubuntu fail to run .exe files? / How do I run .exe? Get driving directions using Google Maps API v2 What's the difference between using black and white mode in-camera, and converting in post? For black and white photography, will there be any quality difference between using the built-in black and white mode, or shooting in color initially and then removing the color later using Photoshop (or similar application)?  I have a high-end compact camera, the . TeXLive Pretest 2018: beamer and subfig collide \documentclass{beamer}  \usepackage{subfig}  \begin{document}  test  \end{document}   returns undefined control sequence \@@magyar@captionfix  (It was not so in January; I am on fully updated pretest) Beginner Physics Resources? I'm interested in learning physics. I do realize that the subject is large and that it would be easier if I had a specific area of interest. However, I do not. I suppose I want to learn about the fundamentals of it all; the axioms that combine all physics fields. Or, in other words, a high school physics class.   Specifically, a book or series of videos would be helpful. I looked over MIT and unfortunately the material wasn't for me. I don't mean to be "picky" so I am not completely ruling out any resource just yet.   Thanks in advance.