Sqlite Database SQLite Shahram ForouzanMehr 1.0 Google Nexus 5 [colnames],[Dbpath],[DelQuery],[DN],[FetchCond],[FetchOption],[FetchResult([TblName])(0)('id')],[FetchResult([TblName])(0)('name')],[FetchResult],[FileNameInput],[isForegr],[ItemID],[ItemName],[lastnin],[myResult],[namein],[pushText],[pushTitle],[randAge],[TbColTp],[TbColumns],[TblName],[TextareaText],[UpdColumns],[UpdColumnsValue],[UpdCondstatement],[UpdCondValue] True 360 640 True True False MobileApp False C:\Users\Shahram\Documents\VisualNeoWeb\Libraries\img\default-icon.png en standalone Offline page #000000 com.FOMECO.SQLite [AndroidOS] normal True False True True True True True True True False <plugin name="cordova-plugin-dialogs" source="npm" /> <plugin name="cordova-plugin-statusbar" source="npm" /> <preference name="fullscreen" value="false" /> <preference name="disallowOverscroll" value="true" /> <preference name="StatusBarOverlaysWebView" value="false" /> <preference name="StatusBarBackgroundColor" value="#000000" /> <preference name="StatusBarStyle" value="default" /> <edit-config file="app/src/main/AndroidManifest.xml" mode="merge" target="/manifest/application"> <application android:usesCleartextTraffic="true" android:requestLegacyExternalStorage="true" /> </edit-config> <script src="cordova.js"></script> NativeView AlertBox "Alert" "You select [clickedBtn]" "" [clickedBtn]|INTEGER|MessageButtonClicked If [ExitResult] = 1 BeginJS window.navigator.app.exitApp(); EndJS EndIf [ExitResult]|INTEGER| AlertBox "result" "test callback success" "" AlertBox "Table create result" "Table [mktablesuccess] Created!" "" [mktablesuccess]|STRING|Tb Name jsAlert "Error. Check inputs!" jsAlert "New Record Added!" jsAlert "[DropSecresult] Droped!" [DropSecresult]|STRING|Tablename jsAlert "Data Deleted!" SetVar [ItemID] "[FetchResult([TblName])(0)('id')]" SetVar [ItemName] "[FetchResult([TblName])(0)('name')]" BeginJS alert("Error occurred while creating the table." + [error]); EndJS [error]|STRING|Error jsAlert "Data Update..." jsAlert "Database Connected..." jsAlert "Database Connect error: [dbconecterr] " [dbconecterr]|STRING|Database connect error 4px 334px 346px 247px 0 5px 172px 345px 158px 0 5px 4px 345px 160px 0 18px 228px 323px 43px Pushbutton BackUp DB glyphicon-floppy-open pright success BackupDatabase "[DN]" "0" "[Dbpath]" true 18px 276px 324px 43px Pushbutton Restore DB glyphicon-retweet pright warning CloseDatabase "" "" RestoreDataBase "[DN]" "0" "[Dbpath]" true 17px 17px 323px 43px DN Database Name (e.g. myDb.db) 17px 66px 324px 41px Pushbutton New Database/Connect Database glyphicon-list pright primary OpenDatabase "[DN]" "0" "openDbSuccess" "opendbError" 18px 341px 325px 37px TblName Table Name (e.g. myTable) 18px 528px 324px 43px DropTable glyphicon-remove pright danger DropTable "[TblName]" "DropTableSuccess" "" 18px 481px 324px 40px Create Table glyphicon-menu-hamburger success CreateTable "[TblName]" "[TbColumns]" "[TbColTp]" "TableSuccess" "ErrorNewTable" 18px 588px 323px 43px Insert Records/Fetch Data custom GotoPage "Pg2" 180px 114px 162px 42px Pushbutton Remove Database glyphicon-erase pright danger RemoveDatabase "[DN]" "0" 18px 384px 324px 41px TbColumns Table Columns (e.g. id, name etc) 18px 432px 324px 43px TbColTp Column Type (e.g. Integer primary key autoincreament, text etc) 17px 180px 325px 41px Dbpath Path (Folder/subFolder)or(Empty for root) 18px 114px 156px 42px Pushbutton Close Database glyphicon-erase pright info CloseDatabase "" "" 18px 107px 324px 42px Pushbutton InsertData glyphicon-text-size pright primary RandomEx 18 40 [randAge] InsertData "[TblName]" "[namein]" "[lastnin]" "InsertNew" "ErrorInsert" 17px 155px 324px 216px Click on me after displaying the table. jsAlert "Successfull! \n The first item ID is: [ItemID] \n The first item name is: [ItemName]" 19px 12px 324px 42px namein Column Name (name, age, etc.) 19px 60px 324px 42px lastnin Column Value (Jhon, 25 etc.) 16px 526px 325px 44px Pushbutton Fetch Database glyphicon-list pright success FetchData "[TblName]" "[colnames]" "[FetchCond]" "[FetchOption]" [FetchResult] "Table" "FetchDone" 18px 431px 324px 40px FetchCond Conditions (e.g. name = 'x' AND age = 'y') 18px 383px 324px 41px colnames Names of the columns (e.g. id, name) or * 18px 480px 324px 40px FetchOption Options (e.g. ORDER BY age ASC) 185px 580px 155px 37px Delete/Update warning GotoPage "Pg3" 17px 581px 156px 37px Previews Page GotoPage "Pg1" 180px 582px 160px 38px CloseApp danger MessageBox "Exit Application" "Are you sure for Exit?" "Ok|Cancel" "ExitApp" 18px 582px 157px 37px Previews Page GotoPage "Pg2" 30px 40px 300px 43px DelQuery Delete query (e.g. id= 'x') 30px 354px 300px 44px Pushbutton Update glyphicon-list pright primary UpdateData "[TblName]" "[UpdColumns]" "[UpdColumnsValue]" "[UpdCondstatement]" "[UpdCondValue]" "AND" "" "UpdateSuccess" "" 30px 96px 300px 42px Delete Record danger DeleteData "[TblName]" "[DelQuery]" "DataDeleted" "" 30px 155px 300px 41px UpdColumns Column names(e.g. name, age etc.) 30px 203px 300px 41px UpdColumnsValue New Value (e.g. Alex, 32) 30px 251px 300px 42px UpdCondstatement Update Condition (id, name etc.) 30px 301px 300px 42px UpdCondValue Update Condition Value (2, John etc.) 0px 0px 360px 640px False custom