Loading...

SQL-MVC Firebird example implementation of todomvc.com

Must be a valid email address.
 
  • Field Style Debug+ 8048 Bytes
    • * root -->
      • * table -->
        • Title:Make new records
        • from:TODO_MVC
        • autoinsert:top
        • tablestyle:Todo
        • object_ended_at:71
        • table:
        • quickinput:Select
        • autoinsert_internal:1
      • * STATUS -->
        • * Qualia -->
          • Action:Edit
          • autosave:yes
          • onupdate:owner=session.id
          • object_ended_at:54
          • name:STATUS
          • table:TODO_MVC
          • Default_length:20
          • length:10
          • Type:Pick
          • quickinput:STATUS,
          • as:ticked
          • List:Ticked
          • context:TODO_MVC
          • indx:0
          • title:STATUS
          • pointer:2
          • to:TODO_MVC
          • pkname:REF
        • search:STATUS : Todo..Pick.Field.Edit
        • * tried -->
          • + _Main -->
            • _Main[0]:TodoPickFieldEdit_Main
            • _Main[1]:PickFieldEdit_Main
          • + _Div -->
            • _Div[0]:TodoPickFieldEdit_Div
            • _Div[1]:PickFieldEdit_Div
          • + _Script -->
            • _Script[0]:TodoPickFieldEdit_Script
            • _Script[1]:PickFieldEdit_Script
            • _Script[2]:InheritingFrom:PickFieldEdit_Script
            • _Script[3]:Edit_Script
      • * NAME -->
        • * Qualia -->
          • Action:Edit
          • placeholder:What needs to be done (tab to save)
          • autosave:yes
          • onupdate:owner=session.id
          • object_ended_at:104
          • name:NAME
          • table:TODO_MVC
          • Default_length:20
          • length:100
          • Type:Text
          • quickinput:NAME,
          • as:text
          • size:40
          • title:todo
          • context:TODO_MVC
          • indx:1
          • pointer:2
          • to:TODO_MVC
          • pkname:REF
        • search:NAME : Todo..Text.Field.Edit
        • * tried -->
          • + _Main -->
            • _Main[0]:TodoTextFieldEdit_Main
            • _Main[1]:TextFieldEdit_Main
            • _Main[2]:InheritingFrom:TextFieldEdit_Main
            • _Main[3]:Edit_Main
          • + _Div -->
            • _Div[0]:TodoTextFieldEdit_Div
            • _Div[1]:TextFieldEdit_Div
          • + _Script -->
            • _Script[0]:TodoTextFieldEdit_Script
            • _Script[1]:TextFieldEdit_Script
            • _Script[2]:InheritingFrom:TextFieldEdit_Script
            • _Script[3]:Edit_Script
      • * REF -->
        • * Qualia -->
          • object_ended_at:2
          • name:REF
          • table:TODO_MVC
          • Default_length:20
          • length:40
          • Type:Hide
          • Action:View
          • quickinput:REF
          • as:pk
          • PrimaryKey:true
          • fb_trigger:true
          • context:TODO_MVC
          • indx:2
          • title:REF
          • pointer:2
          • to:TODO_MVC
        • search:REF : Todo..Hide.Field.View
        • * tried -->
          • + _Main -->
            • _Main[0]:TodoHideFieldView_Main
            • _Main[1]:HideFieldView_Main
            • _Main[2]:TodoHideFieldView_Main
            • _Main[3]:TodoFieldView_Main
            • _Main[4]:HideFieldView_Main
            • _Main[5]:HideFieldView_Main
            • _Main[6]:FieldView_Main
            • _Main[7]:View_Main
          • + _Div -->
            • _Div[0]:TodoHideFieldView_Div
            • _Div[1]:HideFieldView_Div
            • _Div[2]:InheritingFrom:HideFieldView_Div
            • _Div[3]:View_Div
          • + _Script -->
            • _Script[0]:TodoHideFieldView_Script
            • _Script[1]:HideFieldView_Script
            • _Script[2]:InheritingFrom:HideFieldView_Script
            • _Script[3]:View_Script
      • * table_style -->
        • * TopTitle -->
          • + tries -->
            • tries[0]:firstLook:TodoDataTopTitle:
          • Found:
          • FoundFrom:firstLook:TodoDataTopTitle:
        • * HeadFirstFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHeadFirstFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataHeadFirstFieldCell: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th >
          • Found: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th >
          • FoundFrom:first Inherit:DataHeadFirstFieldCell: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th >
        • * HeadFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHeadFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataHeadFieldCell: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td >
          • Found: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td >
          • FoundFrom:first Inherit:DataHeadFieldCell: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td >
        • * HeadRecordWrap -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHeadRecordWrap:
          • Found:
          • FoundFrom:firstLook:TodoDataHeadRecordWrap:
        • * HeadRow -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHeadRow: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataHeadRow: < tr > { { { pop } } } < /tr >
          • Found: < tr > { { { pop } } } < /tr >
          • FoundFrom:first Inherit:DataHeadRow: < tr > { { { pop } } } < /tr >
        • * Head -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHead: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataHead:$CRLF$ < thead > { { { pop } } } < /thead >
          • Found:$CRLF$ < thead > { { { pop } } } < /thead >
          • FoundFrom:first Inherit:DataHead:$CRLF$ < thead > { { { pop } } } < /thead >
        • * BodyFirstFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyFirstFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyFirstFieldCell: < th scope="row" > { { { pop } } } < /th >
          • Found: < th scope="row" > { { { pop } } } < /th >
          • FoundFrom:first Inherit:DataBodyFirstFieldCell: < th scope="row" > { { { pop } } } < /th >
        • * BodyFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyFieldCell: < td > { { { pop } } } < /td >
          • Found: < td > { { { pop } } } < /td >
          • FoundFrom:first Inherit:DataBodyFieldCell: < td > { { { pop } } } < /td >
        • * BodyRecordWrap -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyRecordWrap: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyRecordWrap:{ { { pop } } }
          • Found:{ { { pop } } }
          • FoundFrom:first Inherit:DataBodyRecordWrap:{ { { pop } } }
        • * BodyRow -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyRow: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyRow: < tr > { { { pop } } } < /tr >
          • Found: < tr > { { { pop } } } < /tr >
          • FoundFrom:first Inherit:DataBodyRow: < tr > { { { pop } } } < /tr >
        • * BodyArray -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyArray: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyArray:}
          • Found:}
          • FoundFrom:first Inherit:DataBodyArray:}
        • * Body -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBody: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBody:$CRLF$ < tbody > { { { pop } } } < /tbody >
          • Found:$CRLF$ < tbody > { { { pop } } } < /tbody >
          • FoundFrom:first Inherit:DataBody:$CRLF$ < tbody > { { { pop } } } < /tbody >
        • * FootFirstFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFootFirstFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataFootFirstFieldCell: < th scope="col" > { { { pop } } } < /th >
          • Found: < th scope="col" > { { { pop } } } < /th >
          • FoundFrom:first Inherit:DataFootFirstFieldCell: < th scope="col" > { { { pop } } } < /th >
        • * FootFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFootFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataFootFieldCell: < td > { { { pop } } } < /td >
          • Found: < td > { { { pop } } } < /td >
          • FoundFrom:first Inherit:DataFootFieldCell: < td > { { { pop } } } < /td >
        • * FootRecordWrap -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFootRecordWrap:
          • Found:
          • FoundFrom:firstLook:TodoDataFootRecordWrap:
        • * FootRow -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFootRow: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataFootRow: < tr > { { { pop } } } < /tr >
          • Found: < tr > { { { pop } } } < /tr >
          • FoundFrom:first Inherit:DataFootRow: < tr > { { { pop } } } < /tr >
        • * Foot -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFoot: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataFoot:$CRLF$
          • Found:$CRLF$
          • FoundFrom:first Inherit:DataFoot:$CRLF$
        • * Wrap -->
          • + tries -->
            • tries[0]:firstLook:TodoDataWrap: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataWrap: < div > < form autocomplete="off" > < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table > < /form > < /div >
          • Found: < div > < form autocomplete="off" > < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table > < /form > < /div >
          • FoundFrom:first Inherit:DataWrap: < div > < form autocomplete="off" > < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table > < /form > < /div >
     
  • Field Style Debug+ 8048 Bytes
    • * root -->
      • * table -->
        • Title:Make new records
        • from:TODO_MVC
        • autoinsert:top
        • tablestyle:Todo
        • object_ended_at:71
        • table:
        • quickinput:Select
        • autoinsert_internal:0
      • * STATUS -->
        • * Qualia -->
          • Action:Edit
          • autosave:yes
          • onupdate:owner=session.id
          • object_ended_at:54
          • name:STATUS
          • table:TODO_MVC
          • Default_length:20
          • length:10
          • Type:Pick
          • quickinput:STATUS,
          • as:ticked
          • List:Ticked
          • context:TODO_MVC
          • indx:0
          • title:STATUS
          • pointer:2
          • to:TODO_MVC
          • pkname:REF
        • search:STATUS : Todo..Pick.Field.Edit
        • * tried -->
          • + _Main -->
            • _Main[0]:TodoPickFieldEdit_Main
            • _Main[1]:PickFieldEdit_Main
          • + _Div -->
            • _Div[0]:TodoPickFieldEdit_Div
            • _Div[1]:PickFieldEdit_Div
          • + _Script -->
            • _Script[0]:TodoPickFieldEdit_Script
            • _Script[1]:PickFieldEdit_Script
            • _Script[2]:InheritingFrom:PickFieldEdit_Script
            • _Script[3]:Edit_Script
      • * NAME -->
        • * Qualia -->
          • Action:Edit
          • placeholder:What needs to be done (tab to save)
          • autosave:yes
          • onupdate:owner=session.id
          • object_ended_at:104
          • name:NAME
          • table:TODO_MVC
          • Default_length:20
          • length:100
          • Type:Text
          • quickinput:NAME,
          • as:text
          • size:40
          • title:todo
          • context:TODO_MVC
          • indx:1
          • pointer:2
          • to:TODO_MVC
          • pkname:REF
        • search:NAME : Todo..Text.Field.Edit
        • * tried -->
          • + _Main -->
            • _Main[0]:TodoTextFieldEdit_Main
            • _Main[1]:TextFieldEdit_Main
            • _Main[2]:InheritingFrom:TextFieldEdit_Main
            • _Main[3]:Edit_Main
          • + _Div -->
            • _Div[0]:TodoTextFieldEdit_Div
            • _Div[1]:TextFieldEdit_Div
          • + _Script -->
            • _Script[0]:TodoTextFieldEdit_Script
            • _Script[1]:TextFieldEdit_Script
            • _Script[2]:InheritingFrom:TextFieldEdit_Script
            • _Script[3]:Edit_Script
      • * REF -->
        • * Qualia -->
          • object_ended_at:2
          • name:REF
          • table:TODO_MVC
          • Default_length:20
          • length:40
          • Type:Hide
          • Action:View
          • quickinput:REF
          • as:pk
          • PrimaryKey:true
          • fb_trigger:true
          • context:TODO_MVC
          • indx:2
          • title:REF
          • pointer:2
          • to:TODO_MVC
        • search:REF : Todo..Hide.Field.View
        • * tried -->
          • + _Main -->
            • _Main[0]:TodoHideFieldView_Main
            • _Main[1]:HideFieldView_Main
            • _Main[2]:TodoHideFieldView_Main
            • _Main[3]:TodoFieldView_Main
            • _Main[4]:HideFieldView_Main
            • _Main[5]:HideFieldView_Main
            • _Main[6]:FieldView_Main
            • _Main[7]:View_Main
          • + _Div -->
            • _Div[0]:TodoHideFieldView_Div
            • _Div[1]:HideFieldView_Div
            • _Div[2]:InheritingFrom:HideFieldView_Div
            • _Div[3]:View_Div
          • + _Script -->
            • _Script[0]:TodoHideFieldView_Script
            • _Script[1]:HideFieldView_Script
            • _Script[2]:InheritingFrom:HideFieldView_Script
            • _Script[3]:View_Script
      • * table_style -->
        • * TopTitle -->
          • + tries -->
            • tries[0]:firstLook:TodoDataTopTitle:
          • Found:
          • FoundFrom:firstLook:TodoDataTopTitle:
        • * HeadFirstFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHeadFirstFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataHeadFirstFieldCell: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th >
          • Found: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th >
          • FoundFrom:first Inherit:DataHeadFirstFieldCell: < th scope="col" > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /th >
        • * HeadFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHeadFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataHeadFieldCell: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td >
          • Found: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td >
          • FoundFrom:first Inherit:DataHeadFieldCell: < td > { { #proper } }{ { field.f.title } }{ { /proper } }{ { { pop } } } < /td >
        • * HeadRecordWrap -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHeadRecordWrap:
          • Found:
          • FoundFrom:firstLook:TodoDataHeadRecordWrap:
        • * HeadRow -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHeadRow: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataHeadRow: < tr > { { { pop } } } < /tr >
          • Found: < tr > { { { pop } } } < /tr >
          • FoundFrom:first Inherit:DataHeadRow: < tr > { { { pop } } } < /tr >
        • * Head -->
          • + tries -->
            • tries[0]:firstLook:TodoDataHead: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataHead:$CRLF$ < thead > { { { pop } } } < /thead >
          • Found:$CRLF$ < thead > { { { pop } } } < /thead >
          • FoundFrom:first Inherit:DataHead:$CRLF$ < thead > { { { pop } } } < /thead >
        • * BodyFirstFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyFirstFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyFirstFieldCell: < th scope="row" > { { { pop } } } < /th >
          • Found: < th scope="row" > { { { pop } } } < /th >
          • FoundFrom:first Inherit:DataBodyFirstFieldCell: < th scope="row" > { { { pop } } } < /th >
        • * BodyFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyFieldCell: < td > { { { pop } } } < /td >
          • Found: < td > { { { pop } } } < /td >
          • FoundFrom:first Inherit:DataBodyFieldCell: < td > { { { pop } } } < /td >
        • * BodyRecordWrap -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyRecordWrap: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyRecordWrap:{ { { pop } } }
          • Found:{ { { pop } } }
          • FoundFrom:first Inherit:DataBodyRecordWrap:{ { { pop } } }
        • * BodyRow -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyRow: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyRow: < tr > { { { pop } } } < /tr >
          • Found: < tr > { { { pop } } } < /tr >
          • FoundFrom:first Inherit:DataBodyRow: < tr > { { { pop } } } < /tr >
        • * BodyArray -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBodyArray: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBodyArray:}
          • Found:}
          • FoundFrom:first Inherit:DataBodyArray:}
        • * Body -->
          • + tries -->
            • tries[0]:firstLook:TodoDataBody: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataBody:$CRLF$ < tbody > { { { pop } } } < /tbody >
          • Found:$CRLF$ < tbody > { { { pop } } } < /tbody >
          • FoundFrom:first Inherit:DataBody:$CRLF$ < tbody > { { { pop } } } < /tbody >
        • * FootFirstFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFootFirstFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataFootFirstFieldCell: < th scope="col" > { { { pop } } } < /th >
          • Found: < th scope="col" > { { { pop } } } < /th >
          • FoundFrom:first Inherit:DataFootFirstFieldCell: < th scope="col" > { { { pop } } } < /th >
        • * FootFieldCell -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFootFieldCell: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataFootFieldCell: < td > { { { pop } } } < /td >
          • Found: < td > { { { pop } } } < /td >
          • FoundFrom:first Inherit:DataFootFieldCell: < td > { { { pop } } } < /td >
        • * FootRecordWrap -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFootRecordWrap:
          • Found:
          • FoundFrom:firstLook:TodoDataFootRecordWrap:
        • * FootRow -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFootRow: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataFootRow: < tr > { { { pop } } } < /tr >
          • Found: < tr > { { { pop } } } < /tr >
          • FoundFrom:first Inherit:DataFootRow: < tr > { { { pop } } } < /tr >
        • * Foot -->
          • + tries -->
            • tries[0]:firstLook:TodoDataFoot: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataFoot:$CRLF$
          • Found:$CRLF$
          • FoundFrom:first Inherit:DataFoot:$CRLF$
        • * Wrap -->
          • + tries -->
            • tries[0]:firstLook:TodoDataWrap: undefined
            • tries[1]:InheritLook:TodoData_Inherit:
            • tries[2]:first Inherit:DataWrap: < div > < form autocomplete="off" > < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table > < /form > < /div >
          • Found: < div > < form autocomplete="off" > < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table > < /form > < /div >
          • FoundFrom:first Inherit:DataWrap: < div > < form autocomplete="off" > < table class="full" id="{ { tid } }" > { { { head_html } } }{ { { body_html } } }{ { { foot_html } } } < /table > < /form > < /div >
    0 items left View all Active Completed




    Info


    0 actions from you and 0 actions total (in this session).
    View
    This source file is //Home/Guest/Index:
    
    <#script()
    
    sqlcomment Index.quicc;
    
    dialect(fb)
    
    
    UPDATE OR INSERT INTO MAIL (FROM_USER, STAMP,SUBJECT)
    VALUES (
        session.id, 
        'now',
        'last contact'
    ) matching (FROM_USER,SUBJECT) ;
    
    dialect()
    
    INSERT INTO MAIL (FROM_USER, STAMP,SUBJECT)
    VALUES (
        session.id, 
        'now',
        'login log'
    ) ;
    
    #>
    
    <#view
    Container(style=Center)
    
    
    dialect(fb)
    
    notify(style=Heading) 
    <a href="https://github.com/quale-quest/sql-mvc">SQL-MVC</a> Firebird example implementation of <a href="http://todomvc.com">todomvc.com</a>
    
    
    dialect(mysql57)
    
    notify(style=Heading) 
    <a href="https://github.com/quale-quest/sql-mvc">SQL-MVC</a> MYSQL example implementation of <a href="http://todomvc.com">todomvc.com</a>
    
    dialect(mssql)
    
    notify(style=Heading) 
    <a href="https://github.com/quale-quest/sql-mvc">SQL-MVC</a> MSSQL example implementation of <a href="http://todomvc.com">todomvc.com</a>
    
    dialect()
    
    
    ifquery (not key.admin)
    ifquery (once.session_showmessageatstartX) 
    notify (style=Brief title="Built with SQL-MVC") This entire web application, with layout, menu's, user administration, demo's and documentation is build with SQL-MVC.
    endquery
    endquery
    
    table()
    	Select  --:{Title:"Make new records",from:TODO_MVC,autoinsert:top,tablestyle:Todo}
    	first 10
    	STATUS, --:{Action:Edit,autosave:yes,onupdate:"owner=session.id"}
    	NAME,   --:{Action:Edit,placeholder:"What needs to be done (tab to save)",autosave:yes,onupdate:"owner=session.id"}
    	REF	    --:{}
    	From TODO_MVC 
    	where (owner=session.id and ( (here.todo_type='' and (status!='3' or status is null)) 
    	or( (status='' or status is null) and here.todo_type='1')or(status='1' and here.todo_type='2')))
    	
    
    use("todo.itemcount",max=600000)
    
    button (title:"View all")
        set here.todo_type='';
    
    button {title:"Active"}
    	set here.todo_type='1';
    
    button {title:"Completed"}
    	set here.todo_type='2';
    
    use(todo.clear.button)
    
    CloseContainer
    
    use(todo.source_files)
                                                                             
    #>
    
    
    
    
    
    Model
    This source file is Models/TodoModel :
    
    
    <#model
    
    CREATE TABLE TODO_MVC				--:{as:"Table"} 
    (
      REF VARCHAR(40),					--:{as:pk}
      NAME VARCHAR(100),				--:{as:text,size:40,title:"todo"}  
      PROGRESS VARCHAR(100),			--:{as:text,size:40,title:"Progress"}  
      OWNER VARCHAR(40),				--:{as:hidden}
      STATUS VARCHAR(10) default ''    	--:{as:ticked}  
    );
    
    CREATE INDEX IDX_TODO_MVC1 ON TODO_MVC (REF);
    CREATE INDEX IDX_TODO_MVC2 ON TODO_MVC (OWNER,STATUS);
    
    #>
    
    
    
    
    Controller
    This source file is Controllers/TodoController :
    <#controller(todo.clear.button)
    button()
    --{title:"Clear Completed",if:"(select count(ref) from TODO_MVC where owner=session.id and status='1')!=0" }
    sql update TODO_MVC set status='3' where owner=session.id and (status='1');
    #>
    
    <#controller(todo.items) 
    ($select count(*) from TODO_MVC where owner=session.id and (status='' or status is null) $)
    #>
    
    <#controller(todo.itemcountsub)
    ifquery (controller.todo.items!=1)
    print () controller.todo.items items left
    elsequery
    print () 1 item left
    endquery
    #>
    
    
    <#controller(todo.itemcount,max=5)
    ifquery (controller.todo.items>parameter.max)
    print () To many items left
    elsequery
    use(todo.itemcountsub)
    endquery
    #>
    
    
    <#controller(todo.source_files)	
    html <div align="center"><br><br><br><br></div></div>	
    
    Container( style=Tab                                                                                tab=Info)
    rem -------------------------------------------------------------------------------------------------------
    notify(style=Heading) Info
    
    rem here should not be used in guest user
    rem print() you were here last at here.this_page_info
    rem script() set here.this_page_info=cast('now' as timestamp);
    html() <br>
    
    print() ($select count(*) from MAIL where FROM_USER=session.id and SUBJECT='login log' $) actions from you 
    	and ($select count(*) from MAIL where SUBJECT='login log' $) actions total (in this session).
    
    NextContainer                                                                   (tab=Source_Code)
    Container (style=Accordion                                                title=View)
    print <b>This source file is <u>here.thisfile</u>:</b>
    include (type="pre" file="this" )
    NextContainer                                                           (title=Model)
    print This source file is Models/TodoModel :
    include (type="pre" file="Models/TodoModel" )
    NextContainer                                                      (title=Controller)
    print This source file is Controllers/TodoController :
    include (type="pre" file="Controllers/TodoController" )
    
    CloseContainer                                                                     
    
    CloseContainer                                                                                 
    #>