Sqlite Database SQLite Shahram ForouzanMehr 1.0 Google Nexus 5 [colnames],[CSVREs],[Dbpath],[DelQuery],[DN],[FetchCond],[FetchOption],[FetchResult([TblName])(0)('id')],[FetchResult([TblName])(0)('name')],[FetchResult],[FileAddress],[ItemID],[ItemName],[lastnin],[myFilecont],[namein],[randAge],[RestoreLoad],[TbColTp],[TbColumns],[TblName],[UpdAdvQuer],[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> OpenDatabase "[DN]" "0" "openDbSuccess" "opendbError" 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 WriteOnFile "SD-Card" "XSQLite" "[TblName].csv" "[CSVREs]" false "" "" jsAlert "is done!" jsAlert "[filerr]" [filerr]|STRING|Erro MakeFile "SD-Card" "XSQLite" "[TblName].csv" true "fileSux" "fileErr" jsAlert "[bkpres]" [bkpres]|STRING|esult [BKkperr]|STRING|erro jsAlert "Database restore successful." jsAlert "Database restore Error. [Err]" [Err]|STRING| jsAlert "Database closed successfully" jsAlert "An error eccured to close database" jsAlert "Database removed successfully" jsAlert "Update Error... code: [upderr]" [upderr]|STRING| jsAlert "[restoredNum] records restored..." [restoredNum]|STRING| jsAlert "[csvResErr]" [csvResErr]|STRING| 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]" "[Dbpath]" "BakcupSux" "BkpErr" 18px 276px 324px 43px Pushbutton Restore DB glyphicon-retweet pright warning RestoreDataBase "[DN]" "[Dbpath]" "restoreDBsux" "restoreDBErr" 17px 17px 323px 43px DN sql.db 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 Tb1 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]" "dbRemoveSux" "" 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 "closesux" "closeErr" 18px 491px 324px 44px Pushbutton Fetch glyphicon-list pright success FetchData "[TblName]" "[colnames]" "[FetchCond]" "[FetchOption]" [FetchResult] "Table" [CSVREs] "FetchDone" 17px 106px 324px 37px Pushbutton InsertData glyphicon-text-size pright primary InsertData "[TblName]" "[namein]" "[lastnin]" "InsertNew" "ErrorInsert" 16px 172px 324px 169px 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.) 18px 396px 324px 40px FetchCond Conditions (e.g. name = 'x' AND age = 'y') 18px 348px 324px 41px colnames Names of the columns (e.g. id, name) or * 18px 445px 324px 40px FetchOption Options (e.g. ORDER BY age ASC) 186px 593px 155px 37px Delete/Update warning GotoPage "Pg3" 18px 594px 156px 37px Previews Page GotoPage "Pg1" 16px 540px 97px 41px Pushbutton Save CSV glyphicon-floppy-disk pright danger MakeFolder "SD-Card(external)" "" "XSQLite" "FoldMaked" "" 300px 540px 40px 41px Pushbutton glyphicon-download-alt pright danger RestoreFromCSV "[TblName]" "[myFilecont]" [RestoreLoad] "csvresSux" "csvResErr" 17px 150px 324px 17px False [RestoreLoad] % RestoreLoad 0 100 pinfo 120px 540px 172px 41px FileSelected FileAddress Brows File LocalFileToVar "FileInput1" [myFilecont] Restore from CSV 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 396px 300px 44px Pushbutton Update glyphicon-list pright primary UpdateData "[TblName]" "[UpdColumns]" "[UpdColumnsValue]" "[UpdCondstatement]" "[UpdCondValue]" "AND" "[UpdAdvQuer]" "UpdateSuccess" "UpdateErr" 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.) 30px 348px 300px 42px UpdAdvQuer Combined conditions 0px 0px 360px 640px False custom