Innov-AI
    Documentation | MentDB Weak Server
Generate Web-Service to DELETE on table

  • To generate Web-Service to DELETE on table:
  • Right click on the table 'apps' and select 'GEN WS > DELETE'
  • script create delete "MENTDB.apps.delete" false 1
      (param
      )
      "Delete an element from the table 'apps'."
    {
    	
    	try {
    		
    		#Connection ...;
    		sql connect "session1" {cm get "MENTDB"};
    		
    		-> "[result]" (sql dml "session1" (concat 
    			"DELETE FROM public.apps
    			WHERE 
    			;"
    		));
    		
    		#Disconnection ...;
    		sql disconnect "session1";
    		
    		# Return the json;
    		[result]
    		
    	} {
    
    		#Close the connection;
    		try {sql disconnect "session1"} {} "[sub_err]";
    
    		#Generate an error;
    		exception (1) ([err]);
    		
    	} "[err]";
    	
    } "Return the number of impacted lines.";
  • Update the script and save:
  • Execute buttons
Services     Supporters     Contact     About     Legal notice © 2024