Download CUT (Crystal UTilities) Documentation

GMT/LOCAL TIME ................................................................................................................................................. 21
GMTTOLOCALMINUTES()....................................................................................................................................... 21
GMTTOLOCAL() ..................................................................................................................................................... 22
GMTTOZONE() ....................................................................................................................................................... 23
MESSAGE/INPUT BOXES ...................................................................................................................................... 24
MESSAGEBOXOK() ................................................................................................................................................. 24
MESSAGEBOXYESNO() ........................................................................................................................................... 24
INPUTBOX()............................................................................................................................................................. 25
INPUTBOX2COMMAND() ......................................................................................................................................... 26
WEB/HTML .............................................................................................................................................................. 27
HTMLFILE2RTFFILE()............................................................................................................................................ 27
HTMLSTRING2RTFFILE() ...................................................................................................................................... 29
HTMLSTRING2TXTFILE() ....................................................................................................................................... 30
HTTPFILEEXISTS() ................................................................................................................................................... 31
HTTPFILEDOWNLOAD() ........................................................................................................................................... 32
HTTPFILEDOWNLOADRENAME() ............................................................................................................................. 32
SQL ............................................................................................................................................................................. 33
EXECUTESQLCANCONNECT() ................................................................................................................................ 33
EXECUTESQLNORETURN()..................................................................................................................................... 34
Avoiding Duplicate Processing (old approach).................................................................................................. 35
EXECUTESQLRETURNVALUE() .............................................................................................................................. 36
Example with a Connection String ..................................................................................................................... 37
EXECUTESQLRETURNDELIMITED() ........................................................................................................................ 37
EXECUTESQLRETURNDELIMITEDSEGMENT()......................................................................................................... 38
GEO ............................................................................................................................................................................ 39
DISTANCE() ............................................................................................................................................................. 39
DISTANCEBYZIP5() ................................................................................................................................................. 39
DISTANCEBYZIPUK() ............................................................................................................................................. 39
DISTANCEBYZIP() ................................................................................................................................................... 40
GETLATLONGFROMZIP () ....................................................................................................................................... 40
GETLATLONGFROMZIP5 () ..................................................................................................................................... 40
EXCEL ....................................................................................................................................................................... 41
GETXLSVALUE() .................................................................................................................................................... 41
SETXLSVALUE()..................................................................................................................................................... 41
GETXLSOUTPUT() .................................................................................................................................................. 41
FONT .......................................................................................................................................................................... 42
GETTEXTWIDTH () .................................................................................................................................................. 42
GETFONTSIZETOFITTEXT ().................................................................................................................................... 42
ENCRYPTION .......................................................................................................................................................... 43
BLOWFISHENCRYPT ()............................................................................................................................................. 43
BLOWFISHDECRYPT () ............................................................................................................................................ 43
©2002-2015, Ido Millet, [email protected]
Page 3