Difference between revisions of "User:DrewJensen/check register"

From Apache OpenOffice Wiki
Jump to: navigation, search
(init)
 
m (what)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
A very simple check register database
 
A very simple check register database
 +
- SQL example, get a running total from the Register table
 +
<source lang="mysql">
 +
SELECT
 +
"ID",
 +
"Number",
 +
"Date",
 +
"Withdrawl",
 +
"Deposit",
 +
( SELECT
 +
SUM( "Deposit" ) - SUM( "Withdrawl" )
 +
FROM "Register"
 +
WHERE "ID" <= "R"."ID" ) AS "Balance"
 +
FROM "Register" AS "R"
 +
</source>
 +
 +
- Dataview example, note the hidden ID column (or not :)
 +
 
   
 
   
 
[[file:CheckRegister.odb]]
 
[[file:CheckRegister.odb]]
Line 6: Line 23:
  
  
[[Category:Database]][[Category:Database_Example]]
+
[[Category:Database]][[Category:Base_Example]]

Latest revision as of 06:52, 29 August 2010

A very simple check register database - SQL example, get a running total from the Register table

SELECT 
	"ID", 
	"Number", 
	"Date", 
	"Withdrawl", 
	"Deposit", 
	( 	SELECT 
			SUM( "Deposit" ) - SUM( "Withdrawl" ) 
		FROM "Register" 
		WHERE "ID" <= "R"."ID" ) AS "Balance" 
FROM "Register" AS "R"

- Dataview example, note the hidden ID column (or not :)


File:CheckRegister.odb

0.1 - table, view showing a running balance, form only partly working

Personal tools