Click here to Skip to main content
15,895,557 members
Articles / Web Development / HTML

Wizard and CRUD Applications to Build other CRUD Applications

Rate me:
Please Sign up or sign in to vote.
4.65/5 (41 votes)
8 Jun 2010GPL37 min read 111.1K   4.1K   146  
Looking at the possibility of using CRUD applications to manage other CRUD applications inside a web browser and without any hand-coding. Also, presenting a step wizard deriving the database structure from the UI rather than the opposite.
��/*** www.evolutility.com - (c) 2008 Olivier Giulieri  ***/ 

/*    Sample applications for EvoDico - Evolutility dictionary samples: address book, to do list, memo pad, restaurants   */



/*** form ***/

SET IDENTITY_INSERT EvoDico_Form ON;



INSERT INTO EvoDico_Form (ID, AppID, UserID, GroupID, Class, Title, icon, entity, entities, dbtable, dbtableread, dbwhere, dbwherelock, dborder, dbcolumnlead, dbpixcolumn, dbtablecomments, dbtableusers, Publish, SecuID, CommentsID, script, Description, sppaging, splogin, spget, spdelete, useTabs, dbDetails, xmlfile, url, help, wcreatedate, wmodifdate, wpublishdate)

  VALUES (147, 1, 1, 0, 1, 'Address book', 'm-address.gif', 'contact', 'contacts', 'EVOL_Contact', '', '', '', 'lastname,firstname', 'firstname', '', '', '', 1, 1, 0, '', '', 'EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @pageid, @pagesize', 'EvoDemoSP_Login @login, @password', '', '', 0, 0, 'xml/evoDemo/addressbook.xml', 'demo_addressbook.aspx', '', '2005-8-23 03:39:00 AM', NULL, NULL);

INSERT INTO EvoDico_Form (ID, AppID, UserID, GroupID, Class, Title, icon, entity, entities, dbtable, dbtableread, dbwhere, dbwherelock, dborder, dbcolumnlead, dbpixcolumn, dbtablecomments, dbtableusers, Publish, SecuID, CommentsID, script, Description, sppaging, splogin, spget, spdelete, useTabs, dbDetails, xmlfile, url, help, wcreatedate, wmodifdate, wpublishdate)

  VALUES (148, 1, 1, 0, 1, 'To Do list', 'm-todo.gif', 'task', 'tasks', 'EVOL_ToDo', '', '', '', 'complete, duedate', '', '', '', '', 1, 1, 0, '', '', 'EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @pageid, @pagesize', 'EvoDemoSP_Login @login, @password', '', '', 0, 0, 'xml/evoDemo/ToDo.xml', '', '', '2005-8-23 03:39:00 AM', NULL, NULL);

INSERT INTO EvoDico_Form (ID, AppID, UserID, GroupID, Class, Title, icon, entity, entities, dbtable, dbtableread, dbwhere, dbwherelock, dborder, dbcolumnlead, dbpixcolumn, dbtablecomments, dbtableusers, Publish, SecuID, CommentsID, script, Description, sppaging, splogin, spget, spdelete, useTabs, dbDetails, xmlfile, url, help, wcreatedate, wmodifdate, wpublishdate)

  VALUES (149, 1, 1, 0, 1, 'Memo pad', 'memo.gif', 'memo', 'memos', 'EVOL_Memo', '', '', '', '', '', '', '', '', 1, 1, 0, '', '', 'EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @pageid, @pagesize', 'EvoDemoSP_Login @login, @password', '', '', 0, 0, 'xml/evoDemo/memo.xml', '', '', '2005-8-23 03:39:00 AM', NULL, NULL);

INSERT INTO EvoDico_Form (ID, AppID, UserID, GroupID, Class, Title, icon, entity, entities, dbtable, dbtableread, dbwhere, dbwherelock, dborder, dbcolumnlead, dbpixcolumn, dbtablecomments, dbtableusers, Publish, SecuID, CommentsID, script, Description, sppaging, splogin, spget, spdelete, useTabs, dbDetails, xmlfile, url, help, wcreatedate, wmodifdate, wpublishdate)

  VALUES (152, 1, 1, 0, 1, 'Restaurants', 'resto.gif', 'restaurant', 'restaurants', 'EVOL_Restaurant', '', '', '', 't.name', '', '', '', '', 1, 1, 0, '', '', 'EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @pageid, @pagesize', 'EvoDemoSP_Login @login, @password', '', '', 0, 0, 'xml/evoDemo/restaurant.xml', '', '', '2005-8-23 03:40:00 AM', NULL, NULL);



SET IDENTITY_INSERT EvoDico_Form OFF;





/*** EvoDico_Field ***/

SET IDENTITY_INSERT EvoDico_Field  ON;



INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (1, 147, 1, 'Lastname', '', '', 5, 'Lastname', 'Lastname', '', '', 0, 0, 50, '', '', '', '', '', 0, '', '', '', '', 0, 1, 0, '', 371, 1, 10, '', '', '', 1, 1, 1, 1, 0, 'fieldmain', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (2, 147, 1, 'Firstname', '', '', 5, 'Firstname', 'Firstname', '', '', 0, 0, 50, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 371, 1, 10, '', '', '', 1, 1, 1, 1, 0, 'fieldmain', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (3, 147, 1, 'Title', '', '', 5, 'Title', 'Title', '', '', 0, 0, 50, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 371, 1, 10, '', '', '', 0, 1, 0, 1, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (4, 147, 1, 'Company', '', '', 5, 'Company', 'Company', '', '', 0, 0, 50, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 371, 1, 10, '', '', '', 1, 1, 1, 1, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (5, 147, 1, 'email', '', '', 3, 'emailaddress', 'emailaddress', '', '', 0, 0, 255, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 371, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 100, 'someone@somecompany.com', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (6, 147, 1, 'Work Phone', '', '', 5, 'phone', 'phone', '', '', 0, 0, 20, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 372, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (7, 147, 1, 'Home Phone', '', '', 5, 'phoneh', 'phoneh', '', '', 0, 0, 20, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 372, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (8, 147, 1, 'Mobile', '', '', 5, 'phonem', 'phonem', '', '', 0, 0, 20, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 372, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (9, 147, 1, 'Fax', '', '', 5, 'Fax', 'Fax', '', '', 0, 0, 20, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 372, 1, 10, '', '', '', 0, 0, 0, 0, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (10, 147, 1, 'URL', '', '', 7, 'url', 'url', '', '', 0, 0, 255, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 372, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 100, 'http://www.evolutility.com', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (11, 147, 1, 'Address', 'Address', '', 6, 'AddressLine1', 'AddressLine1', '', '', 0, 0, 255, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 373, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 3, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (12, 147, 1, 'City', '', '', 5, 'City', 'City', '', '', 0, 0, 100, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 373, 1, 10, '', '', '', 1, 1, 0, 1, 0, '', 1, 60, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (13, 147, 1, 'State', '', '', 5, 'State', 'State', '', '', 0, 0, 3, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 373, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 20, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (14, 147, 1, 'Zip', '', '', 5, 'Zip', 'Zip', '', '', 0, 0, 12, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 373, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 20, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (15, 147, 1, 'Category', '', '', 4, 'CategoryID', 'Category', '', '', 0, 0, 100, 'EVOL_ContactCategory', 'id', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 374, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 70, '', '[Unfiled], Hobby, Travel, Finances, Personal, Business, Restaurant, Health ', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (16, 147, 1, 'Notes', '', '', 6, 'notes', 'notes', '', '', 0, 0, 500, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 374, 1, 10, '', '', '', 0, 0, 0, 0, 0, '', 4, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (17, 148, 1, 'Title', '', '', 5, 'title', 'title', '', '', 0, 0, 255, '', '', '', '', '', 0, '', '', '', '', 0, 1, 0, '', 375, 1, 10, '', '', '', 1, 1, 1, 1, 0, 'fieldmain', 1, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (18, 148, 1, 'Due Date', '', '', 2, 'duedate', 'duedate', '', '', 0, 0, 10, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, 'short date', 375, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 40, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (19, 148, 1, 'Priority', '', '', 4, 'PriorityID', 'Priority', '', '', 0, 0, 100, 'EVOL_ToDoPriority', 'id', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 375, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 40, '', '1-ASAP, 2-Urgent, 3-Important, 4-Secondary, 5-Whenever', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (20, 148, 1, 'Category', '', '', 4, 'CategoryID', 'Category', '', '', 0, 0, 100, 'EVOL_ToDoCategory', 'id', '', 'namer', '', 0, '', '', '', '', 0, 0, 0, '', 376, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 100, '', '[Unfiled], Hobby, Travel, Finances, Personal, Business, Restaurant, Health ', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (21, 148, 1, 'Complete', '', 'C.', 1, 'Complete', 'Complete', '', '', 0, 0, 100, '', '', '', '', '', 0, '', 'checkb.gif', '', '', 0, 0, 0, '', 376, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (22, 148, 1, '', 'Notes', 'Notes', 6, 'notes', 'notes', '', '', 0, 0, 1000, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 377, 1, 10, '', '', '', 0, 1, 0, 1, 0, '', 6, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (23, 149, 1, 'Title', 'Title', 'Title', 5, 'Title', 'Title', '', '', 0, 0, 200, '', '', '', '', '', 0, '', '', '', '', 0, 1, 0, '', 378, 1, 10, '', '', '', 1, 1, 1, 1, 0, 'fieldmain', 1, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (24, 149, 1, 'Category', '', '', 4, 'CategoryID', 'Category', '', '', 0, 0, 100, 'EVOL_MemoCategory', 'id', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 378, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 62, '', '[Unfiled], Hobby, Travel, Finances, Personal, Business, Restaurant, Health ', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (25, 149, 1, 'Date', '', '', 2, 'MDate', 'mdate', '', '', 0, 0, 100, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 378, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 38, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (27, 152, 1, 'Name', 'Name', 'Name', 5, 'name', 'name', '', '', 0, 0, 50, '', '', '', '', '', 0, '', '', '', '', 0, 1, 0, '', 381, 1, 10, '', '', '', 1, 1, 1, 0, 0, 'fieldmain', 1, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (28, 152, 1, 'Food', '', '', 4, 'CategoryID', 'CategoryName', '', '', 0, 0, 100, 'EVOL_Restaurant_Category', 'id', '', '', '', 0, '', '', '', '', 0, 1, 0, '', 381, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 40, '', '[Unfiled], French, Vietnamese, Chinese, Fusion, Japanese, Thai, Mexican, Mediterranean, American, Indian, Korean, Italian, Spanish', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (29, 152, 1, 'Rating', '', '', 4, 'RatingID', 'RatingName', '', '', 0, 0, 100, 'EVOL_Restaurant_rating', 'id', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 381, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 30, '', 'NR, ,*, **, ***, ****, *****', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (30, 152, 1, 'Web site', 'Web', 'Web', 7, 'url', 'url', '', '', 0, 0, 200, '', '', '', '', '', 0, '', '', '', '', 0, 0, 1, '', 381, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 70, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (31, 152, 1, 'Phone', '', '', 5, 'phone', 'phone', '', '', 0, 0, 16, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 382, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (32, 152, 1, 'Phone 2', '', '', 5, 'phone2', 'phone2', '', '', 0, 0, 16, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 382, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (33, 152, 1, 'Fax', '', '', 5, 'Fax', 'Fax', '', '', 0, 0, 16, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 382, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 50, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (34, 152, 1, 'email', '', '', 3, 'email', 'email', '', '', 0, 0, 100, '', '', '', '', '', 0, '', '', '', '', 0, 0, 1, '', 382, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 70, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (35, 152, 1, 'Comments', '', '', 6, 'comments', 'comments', '', '', 0, 0, 300, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 383, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 2, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (36, 152, 1, 'Favorite Dishes', '', '', 6, 'favorite', 'favorite', '', '', 0, 0, 300, '', '', '', '', '', 0, '', '', '', '', 0, 0, 1, '', 383, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 2, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (37, 152, 1, 'Address', '', '', 5, 'Address1', 'Address1', '', '', 0, 0, 100, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 384, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (38, 152, 1, '', '', 'Address 2', 5, 'Address2', 'Address2', '', '', 0, 0, 100, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 384, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 100, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (39, 152, 1, 'City', '', '', 5, 'City', 'City', '', '', 0, 0, 100, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 384, 1, 10, '', '', '', 1, 1, 1, 0, 0, '', 1, 60, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (40, 152, 1, 'State', '', '', 5, 'State', 'State', '', '', 0, 0, 2, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 384, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 20, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (41, 152, 1, 'Zip', '', '', 5, 'Zip', 'Zip', '', '', 0, 0, 12, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 384, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 1, 20, '', '', 1);

INSERT INTO EvoDico_Field (ID, FormID, UserID, Label, LabelEdit, LabelList, TypeID, dbcolumn, dbcolumnread, dbcolumnimg, script, min, max, maxlength, dbtablelov, dborderlov, dbcolumnreadlov, dbcolumndetails, dbwherelov, lovmany, lovsplist, img, imglist, defaultvalue, readonly, required, optional, format, PanelID, PanelIndex, fpos, link, linkcaption, linktarget, search, searchadv, searchlist, searchquick, lookup, cssclass, height, width, help, options, Publish)

  VALUES (139009, 149, 1, 'Notes', '', '', 6, 'Notes', 'Notes', '', '', 0, 0, 500, '', '', '', '', '', 0, '', '', '', '', 0, 0, 0, '', 378, 1, 10, '', '', '', 0, 1, 0, 0, 0, '', 6, 100, '', '', 1);



SET IDENTITY_INSERT EvoDico_Field OFF; 





 

/*** EvoDico_Panel ***/



SET IDENTITY_INSERT EvoDico_Panel ON;

 

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (371, 147, 1, 1, 0, 1, 0, 'Name', '61', '', '', 1, 1, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (372, 147, 1, 1, 0, 1, 0, 'Contact Info', '39', '', '', 1, 2, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (373, 147, 1, 1, 0, 1, 0, 'Address', '61', '', '', 1, 3, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (374, 147, 1, 1, 0, 1, 0, 'Misc.', '39', '', '', 1, 4, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (375, 148, 1, 1, 0, 1, 0, 'Task', '62', '', '', 1, 1, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (376, 148, 1, 1, 0, 1, 0, 'Status', '38', '', '', 1, 1, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (377, 148, 1, 1, 0, 1, 0, 'Notes', '100', '', '', 1, 1, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (378, 149, 1, 1, 0, 1, 0, '', '100', '', '', 1, 1, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (381, 152, 1, 1, 0, 1, 0, 'Name', '60', '', '', 1, 1, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (382, 152, 1, 1, 0, 1, 0, 'Contact Info', '40', '', '', 1, 2, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (383, 152, 1, 1, 0, 1, 0, 'Notes', '60', '', '', 1, 3, '', '', '', '', '', '', '');

INSERT INTO EvoDico_Panel (ID, FormID, UserID, TypeID, Readonly, ModeID, TabID, Label, Width, CSSClass, CSSClassTitle, Optional, pPos, DBtableDetails, DBcolumnDetails, DBWhere, DBOrder, Pix, Pix2, Summary)

  VALUES (384, 152, 1, 1, 0, 1, 0, 'Address', '40', '', '', 1, 4, '', '', '', '', '', '', '');



SET IDENTITY_INSERT EvoDico_Panel OFF;



By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The GNU General Public License (GPLv3)


Written By
United States United States
I'm a UI engineer with an eye for UX and a passion for model-driven UIs.

I usually build UIs for startups in the San Francisco Bay Area.

My hobby open source project is Evolutility, a minimalist low-code platform with a model-driven UI, a model-driven backend, and a set of models to play with.

More about me on my GitHub page.

Comments and Discussions