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)}/>