Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Although Martin's answer describe how to <em>create</em> the unique variables, he didn't explained how to <em>read</em> them. When you are talking about "saves each answer as a unique variable" the involved concept here is <em>ARRAY</em>. You need to use Delayed Expansion in order to get the values of the unique variables ("array elements"); for further details, type <code>set /?</code> and look for "delayed expansion". You may read a detailed description about array management in Batch files at this post: <a href="https://stackoverflow.com/questions/10166386/arrays-linked-lists-and-other-data-structures-in-cmd-exe-batch-script/10167990#10167990">Arrays, linked lists and other data structures in cmd.exe (batch) script</a></p> <pre><code>@echo off setlocal EnableDelayedExpansion set /p howmany=How many files do you want to add? for /L %%i in (1,1,%howmany%) do ( set /p inputfilename[%%i]=what is the name of the file you want to add? ) rem Process array elements (just show them in this case) for /L %%i in (1,1,%howmany%) do ( echo %%i- !inputfilename[%%i]! ) </code></pre> <p>The example below may help you in understanding array management in an easier way:</p> <pre><code>@echo off setlocal EnableDelayedExpansion rem Create an array of ordinal terms set i=0 for %%a in (first second third fourth fifth sixth) do ( set /A i+=1 set term[!i!]=%%a ) rem Previous FOR is equivalent to: set term[1]=first, set term[2]=second, ... set /p howmany=How many files do you want to add? for /L %%i in (1,1,%howmany%) do ( set /p inputfilename[%%i]=what is the name of the !term[%%i]! file you want to add? ) rem Process array elements (just show them in this case) for /L %%i in (1,1,%howmany%) do ( echo The !term[%%i]! file is !inputfilename[%%i]! ) </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POWindows Command line script decrementing variables in FOR loop based on a user defined starting variable
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USAacini
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWindows Command line script decrementing variables in FOR loop based on a user defined starting variable
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI read your detailed explanation and it's great! I'm bookmarking that description of Arrays! I would've "upped" it but unfortunately, I don't have enough reputation yet. :( I also read your comment and I completely agree with you. I don't understand why ANYONE thinks that bashing any programming language should be considered "helpful". I really appreciate you taking the time to help potential programmers understand how to do things not just do it for them. Thank you.
      singulars
      1. PO
      1. USjulesverne
    2. CO+1, in most cases it's possible to work with "arrays" and without `delayed expansion` or "toggeling" it to preserve exclamation marks, but it's really SLOW.
      singulars
      1. PO
      1. USEndoro
 

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