Kalipso Studio ico icon is just used to set the icon inside the KClient when testing the application. To have a compative icon you will need to use an icon with 32X32 witho..
A stored procedure that check if a file exists or not and returns 0 or 1 accordingly if file exis..
To make a database backup you need to use a simple code exemplified below. Code: BACKUP DATABASE PRIDEMO TO DISK = ‘C:\MIS\PRIDEMO.BAK’ WITH CHECKSUM BACKUP DATABASE [DATABASE NAME] TO DISK = ‘[DETINATION FULL PATH]’ WIT..
To allow access to this component run the code below to activate. Code: — Activate OLE Access sp_configure ‘show advanced options’, 1 GO RECONFIGURE; GO sp_configure ‘Ole Automation Procedures’, 1 GO RECONFIGURE; GO sp_configure ‘show advanced options’, 1 GO RE..
To use this function you need to give your server user sys.spOACreate permissions. Code: — ============================================= — Author: Bruno Figueiredo — Description: Returns the file information — ============================================= CREATE FUNCTION fn_getfiledetails ( @Filename sysname ) /* How to use: select * from fn_getfiledetails(‘c:\file.ext’) */ RETURNS @filedetails TABLE ( [Path] VARCHAR(100), [ShortPath] VARCHAR(100), [Type] VARCHAR(100), ..
$file_url = ‘https://www.airtistic.net/wp-content/uploads/2019/01/logo_main-2.png’; function getRemoteFilesize($file_url, $formatSize = true) { $head = array_change_key_case(get_headers($file_url, 1)); // content-length of download (in bytes), read from Content-Length: field $clen = isset($head[‘content-length’]) ? $head[‘content-length’] : 0; // cannot retrieve file size, return “-1” if (!$clen) { return –1; } if (!$formatSize) { return $clen; // return size in bytes } $size ..
Action Bank Infusion
This plugin adds some much-needed, functions to the general Action Bank.
New Actions range from DialogEx functions to XML functions and are infused directly into their respective pare..
This sample calculates the MD5 from a string using the Kalipso function and a java script function. Topics covered: MD5 Calculation Use of javascript function &nb..
This sample searches all the Bluetooth devices near the device. Topics covered: Devices search Devices find Pair device function &nb..
This sample show a working digi..
This sample shows how you can read and write a..
If you need to test communication to and from a specific port you can use a software called i4SocketWorkBench that can send and receive packets on designated ports. It’s specially handy if you are developing applications to work with iOT devices and specific port..
This sample shows how to make a simple HTTP Request to a online server API based in a simple P..
To connect to other types of databases you can also use a connection string and define as manual. You can check the different connection string on the link below. https://www.connectionstrings.c..
This functionality only works on the latest versions of SQL Server, FOR XML needs the 2014 version and the FOR JSON 2017 version. SELECT Column1, Column2, * FROM Table FOR JSON AUTO SELECT Column1, Column2, * FROM Table FO..
CommandCam is a simple and easy to use command line webcam image grabber for Windows. It captures a single image from a webcam and stores it in a bitmap file. CommandCam is ideal for use in batch files and other situations where you want a very simple way to automate image capture. CommandCam uses Microsoft’s DirectShow API to access webcams, so it should work with most USB ..
How to get the actual date subtracting 1 day, 1 month and 1 year. You can use this example also to add. ..
The easiest way is to create a function to get the HASH with a simple online request. The script to see the HASH in the browser (PHP): <?php function get_hash($address) { function x509_fingerprint($pem,$hash=’sha1′) { $hash = in_array($hash,array(‘sha1′,’md5′,’sha256’)) ? $hash: ‘sha1’; $pem = preg_replace(‘/\-+BEGIN CERTIFICATE\-+/’,”,$pem); $pem = preg_replace(‘/\-+END CERTIFICATE\-+/’,”,$pem); $pem = str_replace( array(“\n”,”\r”), ”, trim($pem)); return ..
There is only a way to connect Kalipso to a MySQL database, is by installing an ODBC Driver to do that. Links to download below. https://dev.mysql.com/downloads/connector/odbc/ Just download the connector and install it. After installing and rebooting the pc, create a new ODBC of 32bits (System DSN) using the installed connector. After creating the connection ..
If you are getting this error is due to the device is not being properly detected, installed or authorised. Run the ADB command below to check the device properties and check if it’s properly detected. If not you must reinstall the device drivers. (Check related article about ADB commands) adb she..