HFSQL

PROGRAMMING: SQL AND 5GL LANGUAGE EASY YET POWERFUL PROGRAMMING The programming of the HFSQL database is both powerful and easy. This programming is done in SQL and/or in WLanguage 5GL. Programming with the SQL language is universally known. Programming with the 5 th generation WLanguage allows for the streamlined and powerful cursor programming. Thus, automation with the applications and sites developed in WINDEV and WEBDEV is very strong. RAD: TO GENERATE CODE The code can be generated on demand by WINDEV and WEBDEV by using the RAD functionality, or by using the large number of wizards available for these environments. The generated code can be modified later. RAD supports the pattern concept, which lets you define by your- self the code to be generated. LIST OF SUPPORTED SQL STATEMENTS Let’s see the list of supported SQL functions (this list is not exhaus- tive). Each SQL function is not presented in details here. ABS ACOS ADD_MONTHS ALL ALTER TABLE AND ANY AS ASC ASCII ASIN ATAN ATAN2 AUTO_INCREMENT AVG BEGIN TRANSACTION BETWEEN BIGINT BIN BINARY BITAND BITOR BITNOT BITANDNOT BLOB BOTH BOTTOM BTRIM CASE CAST CBRT CEIL CEILING CHAR_LENGTH CHARACTER_LENGTH CI CLOB COALESCE COLLATE COLUMN COMMENT COMMIT CONCAT CONSTRAINT COS COUNT CREATE TABLE CREATE VIEW CROSS CURRENT_DATE DATE DATETIME DAY DAYOFWEEK DAYOFMONTH DAYOFYEAR DECIMAL DECODE DEFAULT DEGREES DELETE DESC DISTINCT DIV DOUBLE DROP TABLE DROP VIEW ELSE ELT END ESCAPE EXISTS EXP EXPLAIN EXTRACTVALUE FIELD FIND_IN_SET FLOAT FLOOR FOR FROM FULL OUTER JOIN GRANT GREATEST GROUP BY HAVING HEX IF IFNULL IN INDEX INITCAP INNER JOIN INSERT INSTR INTO ISNULL LAST_DAY LAST_INSERT_ID LCASE LEADING LEAST LEFT LEFT OUTER JOIN LEN LENGTH LIKE LIMIT LN LOG LOG10 LOWER LPAD LTRIM MATCH AGAINST MAX MD5 MID MIN MOD MONEY MONTHS_BETWEEN NATURAL NCLOB NEW_TIME NEXT_DAY NOT NTEXT NULL NUMBER NUMERIC NVARCHAR NVL OCT OCTET_LENGTH Offset ON OR ORDER BY OVERLAY PATINDEX PERCENT PI PLACING POSITION POWER PRECISION RADIANS RANDOM REAL REFRESH VIEW REGEXP/REGLIKE RENAME REPEAT REPLACE REVERSE REVOKE ROLLBACK RIGHT RIGHT OUTER JOIN ROUND RPAD RTRIM SELECT SET SHA SHA1 SIGN SIN SMALLINT SOME SOUND SOUND2 SOUNDEX SOUNDEX2 SPACE SPLIT_PART SQRT STDDEV STDDEV_POP STDDEV_SAMP STRING_AGG SUBSTR SUBSTRING SUM SYSDATE TAN TEXT THEN TIME TINYINT TO_CHAR TO_DATE TOP TRAILING TRANSLATE TRIM TRUNC UCASE UNHEX UNICODE UNION UNIQUE UNSIGNED UPDATE UPPER USING UUID VALUES VAR_POP VAR_SAMP VARBINARY VARCHAR VARIANCE VARYING WHEN WHERE WITH XOR The “Select” type SQL queries accept a large number of WLan- guage functions as parameters, which lets you easily refine the se- lection. The accepted WLanguage functions are: Abs Age CurrentYear AnsiToOem AnsiToUnicode ArcCos ArcSin ArcTang ArcTang2 Round RoundDown RoundUp Asc BufferToInteger BufferToHexa BufferToReal Charact CharactTypeOccurrence CharactType CharactUnicode StringStartsWith StringCompare StringBuild StringEndsWith StringFormat StringIncrement StringInsert StringReverse StringCount StringDelete StringToDate StringToDuration StringToUTF8 Complete CompleteDir Compress MakeInteger Contains Conversion Cos CoTan ColorLightness ColorSaturation ColorHue Crypt DateDifference Today DateTimeDifference DateTimeLocalToUTC SysDateTime DateTimeUTCToLocal DateTimeValid DateSys DateValid DateToString DateToInteger DateToDay DateToDayInAlpha DateToMonthInAlpha DateToWeekNumber DecimalToSexagesimal UncompleteDir Uncompress Uncrypt LastDayOfWeek LastDayOfMonth GetGUID Right DurationToString EmailCheckAddress IntegerToDate IntegerToTime IntToHexa IntegerToDay IntegerToDayInAlpha IntegerToMonthInAlpha IntegerToWeekNumber IsOdd IsNumeric IsEven BinaryAND ExeInfo Exp ExtractString ExtractLine Factorial fAttributeReadOnly fLoadBuffer fLoadText fShortPath fLongPath fCompress fCompare fBuildPath fCopyFile fCreateLink fCrypt fDate fDateTime fUncompress fUncrypt fMoveFile fDriveInfo fExtractPath fFileExist fTime fShortName fLongName fDirAttribute fCopyDir fMakeDir fDirAttrib fDirectoryExist fTempPath fParentDir fRemoveDir fDirSize fSaveBuffer fSaveText fSep fSeparator fDelete fSize fSizeUncompressed Left GeneratePassword Random TimeDifference TimeSys TimeValid TimeToString TimeToInteger HexaToBuffer HexaToInt HTMLToRGB HTMLToText INIWrite INIRead InitRandom Reverse ExeRun LineToPosition Ln Log Now Upper Max Middle Min Lower CurrentMonth WordOccurrence NetMACAddress NetIPToMAC NetMACToIP NumberInWords BinaryNOT NumToString DayNumberInAlpha MonthNumberInAlpha WeekNumber OemToAnsi BinaryOR BinaryXOR Easter DecimalPart IntegerPart Phonetic LoWord HiWord Position PositionOccurrence HFSQL • www.windev.com 17