VisualNeo Web Test VisNeoApp Shahram ForouzanMehr 1.0 Google Nexus 5 [colnames],[DelQuery],[FetchCond],[FetchOption],[FetchResult.MyFriends(0).age],[FetchResult.MyFriends(0).name],[FetchResult],[FileNameInput],[isForegr],[lastnin],[myResult],[namein],[pushText],[pushTitle],[randAge],[selcond],[TextareaText],[UpdColumns],[UpdColumnsValue],[UpdCondstatement],[UpdCondValue] True 360 640 True True False MobileApp False C:\Users\shahr\Desktop\MyLogoTransparent.png en standalone Offline page #000000 com.myCom.VisualNeoApp [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 "VisualNeoDB" "" "" 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" jsAlert "[namein] [lastnin] Added!" jsAlert "[DropSecresult] Droped!" [DropSecresult]|STRING|Tablename jsAlert "Data Deleted!" jsAlert "Successfull! \n The first item name is: [FetchResult.MyFriends(0).name] \n The first item age is: [FetchResult.MyFriends(0).age]" BeginJS alert("Error occurred while creating the table." + [error]); EndJS [error]|STRING|Error jsAlert "Data Update..." C:\Users\shahr\Desktop\cordova-sqlite\cordova-sqlite-example-master\js\geturi.js 18px 582px 324px 37px Delete/Update Records warning GotoPage "Pg2" 17px 161px 324px 42px Pushbutton InsertData glyphicon-text-size pright primary RandomEx 18 40 [randAge] InsertData "MyFriends" "name, lastname, age" "[namein], [lastnin], [randAge]" "InsertNew" "ErrorInsert" 17px 210px 324px 161px <table class="table table-bordered table-dark table-hover"> <thead id="TblCol"></thead> <tbody id="TblRow"></tbody> </table> 18px 66px 324px 42px namein Name 18px 114px 324px 42px lastnin Lastname 18px 528px 325px 42px Pushbutton Fetch Database glyphicon-list pright success FetchData "MyFriends" "[colnames]" "[FetchCond]" "[FetchOption]" [FetchResult] "Table" "FetchDone" 180px 19px 160px 36px DropTable glyphicon-remove pright danger DropTable "MyFriends" "DropTableSuccess" "" 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 19px 156px 36px Create Table glyphicon-menu-hamburger CreateTable "MyFriends" "id,name,lastname,age,Timestamp" "INTEGER PRIMARY KEY AUTOINCREMENT,TEXT NULL,TEXT NULL,INTEGER,DATETIME DEFAULT CURRENT_TIMESTAMP" "TableSuccess" "ErrorNewTable" 18px 480px 324px 40px FetchOption Options (e.g. ORDER BY age ASC) 191px 586px 149px 36px CloseApp danger MessageBox "Exit Application" "Are you sure for Exit?" "Ok|Cancel" "ExitApp" 18px 587px 168px 35px Previews Page GotoPage "Pg1" 30px 40px 300px 43px DelQuery Delete query (e.g. id= 'x') 30px 353px 300px 44px Pushbutton Update glyphicon-list pright primary UpdateData "MyFriends" "[UpdColumns]" "[UpdColumnsValue]" "[UpdCondstatement]" "[UpdCondValue]" "AND" "UpdateSuccess" "" 30px 96px 300px 42px Delete Record danger DeleteData "MyFriends" "[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