Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>if I guess your sequence right, you will have it easier to generate it recursively</p> <p>here an approach in Java, which should generate a sequence that matches your scenario. I hope it helps you (maybe I add more explanation later):</p> <pre><code>public static void init() { // define constants final int length = 3; final char maxValue = '3'; // define buffer final char[] array = new char[length]; java.util.Arrays.fill(array, '0'); final boolean[] alreadySet = new boolean[length]; java.util.Arrays.fill(alreadySet, false); // fill first digit, then let the recursion take place for(char c = '1'; c &lt;= (char)(maxValue); c++) { // iterate from lowest to highest digit for(int i = array.length-1; i &gt;= 0; i--) { // set value array[i] = c; alreadySet[i] = true; // print value System.out.println(new String(array)); // call recursion recursive(array, c, i, alreadySet, length); // unset value alreadySet[i] = false; array[i] = '0'; } } } public static void recursive(char[] array, char lastValue, int lastIndex, boolean[] alreadySet, int leftToSet) { // if we didn't set all digits if(leftToSet &gt; 0) { // iterate from lowest to highest digit for(int i = array.length-1; i &gt;= 0; i--) { // missing all digits already set if(!alreadySet[i]) { // count from 1 to lastValue-1 for(char c = '1'; c &lt; lastValue; c++) { // set value array[i] = c; alreadySet[i] = true; // print value System.out.println(new String(array)); // call recursion recursive(array, c, i, alreadySet, leftToSet-1); // unset value alreadySet[i] = false; array[i] = '0'; } } } char c = lastValue; // iterate from lowest to highest digit for(int i = array.length-1; i &gt; lastIndex; i--) { // missing all digits already set if(!alreadySet[i]) { // set value array[i] = c; alreadySet[i] = true; // print value System.out.println(new String(array)); // call recursion recursive(array, c, i, alreadySet, leftToSet-1); // unset value alreadySet[i] = false; array[i] = '0'; } } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to solve this weird multiple loops scenario (Java or C#)?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USHachi
    1. USHachi
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to solve this weird multiple loops scenario (Java or C#)?
      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. VTAcceptedByOriginator
    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. VTUpMod
    1. COI'm trying to implement it, but I have troubles with "missing all digits already set"? What it means exactly?
      singulars
      1. PO
      1. USSmartK8
    2. COif you set the 3 in 0030, then you iterate from 003* to 0*30 to *030 ; then if you are on 003* and set it 2 => 0032 you iterate from 0*32 to *032 ; hope this makes it more clear
      singulars
      1. PO
      1. USHachi
    3. COFrankly, I'm not able to grasp it. And I read it like thousand times. Can you please try to expand on the pseudo-code a bit?
      singulars
      1. PO
      1. USSmartK8
 

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