Databases
StackOverflow2013
Usersdbo
USuser2926620
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USuser2926620
    primarykey
    data
    text
    plurals
    1. POVariable from block is put into a calculation but throws off wrong reading
      singulars
      1. PTQuestion
    1. POScanner in java won't match with my double variable
      singulars
      1. PTQuestion
    2. POVariable from block is put into a calculation but throws off wrong reading
      singulars
      1. PTQuestion
    3. POIf/else nesting is skipped and goes to the next else statement
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. CO0.12 is a rate during that month "4/15/13" that they charge to use per kw. The value of kw used is 375. The logic for the code is that they charge is base rate up to 350kw and charge an additional 0.1 for what is left over up to 500kw and above 500kw is an additional 0.25. If you replace "quarter" with 0.12 which the results should be base: 42.0 over: 3.3. When quarter in else/if state is left as is, the results is base:15,750 over: 1237.50 which does't make any sense.
      singulars
      1. PO
      1. USuser2926620
    2. CO@TonnyMadsen I printed the quarter value and it came out the correct answer but my results are totally off. If I were to replace both "quarter" in my else/if statement with 0.12 the answer would read out: base:$42.00 over:$3.30 which is what I want but when quarter is left alone I get this reading: Baseline charge: $15,750.00 Over-baseline charge: $1,237.50 Excess charge: $0.00 Total amount due: $16,987.50
      singulars
      1. POVariable from block is put into a calculation but throws off wrong reading
      1. USuser2926620
    3. CO@TonnyMadsen the date is already predetermined. That is not of concern. Whats giving me an issue is when i try to call back the quarter in my else/if statement, it does not send the data from my switch block. It would then calculate the else/if statement as the first declared value of "quarter" which is 0. I hope that make sense
      singulars
      1. POVariable from block is put into a calculation but throws off wrong reading
      1. USuser2926620
 

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