open Dbgrid
table t1 : {Id : int, A : string}
PRIMARY KEY Id
sequence s
table t : {Id : int, A : int, B : string, C : bool, D : int, E : option int, F : option int}
PRIMARY KEY Id,
CONSTRAINT Foreign FOREIGN KEY (D) REFERENCES t1(Id) ON DELETE CASCADE
fun page (n, s) = return A = {[n]}, B = {[s]}
open Make(struct
val tab = t
con key = [Id = _]
val raw = {Id = {New = nextval s,
Inj = _},
A = {New = return 0,
Inj = _},
B = {New = return "",
Inj = _},
C = {New = return False,
Inj = _},
D = {New = return 0,
Inj = _},
E = {New = return None,
Inj = _},
F = {New = return None,
Inj = _}}
structure F = Direct.Foreign(struct
con nm = #Id
val tab = t1
fun render r = r.A
end)
val cols = {Id = Direct.readOnly [#Id] ! "Id" Direct.int,
A = Direct.editable [#A] ! "A" Direct.int,
B = Direct.editable [#B] ! "B" Direct.string,
C = Direct.editable [#C] ! "C" Direct.bool,
D = Direct.editable [#D] ! "D" F.meta,
E = Direct.editable [#E] ! "E" (Direct.nullable Direct.int),
F = Direct.editable [#F] ! "F" (Direct.nullable F.meta),
DA = computed "2A" (fn r => 2 * r.A),
Link = computedHtml "Link" (fn r => Go)}
val aggregates = {Dummy1 = {Initial = (),
Step = fn _ _ => (),
Display = fn _ => },
Sum = {Initial = 0,
Step = fn r n => r.A + n,
Display = txt},
Dummy2 = {Initial = (),
Step = fn _ _ => (),
Display = fn _ => },
And = {Initial = True,
Step = fn r b => r.C && b,
Display = txt}}
val pageLength = Some 10
end)
fun main () =
grid <- grid;
set (showSelection grid) True;
return
{render grid}
Show selection
Selection: {[r.Id]}; ) ls)}/>