OS/2 Shareware BBS: 5 Edit/05-Edit.zip/con2v766.zip/colore01.zip/includes/rarelng/sql.hrc

Text File | 2000-02-26 | 15KB | 541 lines

<!--
    TSQL Defines
With help of:
    Sergey <[e-mail]>
    Konstantin E. Protopopov
-->

<Define Name="SQLString"  Value="dStrings">
<Define Name="SQLComment" Value="dComments">
<Define Name="SQLNumb"    Value="dNumbers">
<Define Name="SQLWord"    Value="dResWords">
<Define Name="TSQLWord"   Value="dResWords">
<Define Name="TSQLfunc"   Value="dResWords">

<Scheme Name="SQL">
   <!-- Linear Comments -->
   <RegExp Start="/(--.*$)/" Color0="SQLComment">
   <Block  Start="/\/\*/" End="/\*\//" Scheme="Comment" Color0="SQLComment">
   <!-- Strings -->
   <RegExp Start='/("((\\.)|[^\\"])*?")/' Color0="SQLString">
   <RegExp Start="/('((\\.)|[^\\'])*?')/" Color0="SQLString">
   <!-- Numbers -->
   <Include Scheme="mCHexNumb">
   <Include Scheme="mFloatNumb">
   <Include Scheme="mDecNumb">
   <!-- Variables -->
   <RegExp Start="/(\@\@\w*)/" Color0="dVarsEx">
   <RegExp Start="/(\@\w*)/" Color0="dVarsEx">
   <RegExp Start="/(^[\w\s]+:)/" Color0="dLabels">
   <!-- ODBC Reserved Keywords -->
   <KeyWords MatchCase="False" Color="TSQLWord">
      <Word Name="ABSOLUTE">
      <Word Name="ACTION">
      <Word Name="ADA">
      <Word Name="ADD">
      <Word Name="ALL">
      <Word Name="ALLOCATE">
      <Word Name="ALTER">
      <Word Name="AND">
      <Word Name="ANY">
      <Word Name="ARE">
      <Word Name="AS">
      <Word Name="ASC">
      <Word Name="ASSERTION">
      <Word Name="AT">
      <Word Name="AUTHORIZATION">
      <Word Name="AVG">
      <Word Name="BEGIN">
      <Word Name="BETWEEN">
      <Word Name="BIT">
      <Word Name="BIT_LENGTH">
      <Word Name="BOTH">
      <Word Name="BY">
      <Word Name="CASCADE">
      <Word Name="CASCADED">
      <Word Name="CASE">
      <Word Name="CAST">
      <Word Name="CATALOG">
      <Word Name="CHAR">
      <Word Name="CHAR_LENGTH">
      <Word Name="CHARACTER">
      <Word Name="CHARACTER_LENGTH">
      <Word Name="CHECK">
      <Word Name="CLOSE">
      <Word Name="COALESCE">
      <Word Name="COLLATE">
      <Word Name="COLLATION">
      <Word Name="COLUMN">
      <Word Name="COMMIT">
      <Word Name="CONNECT">
      <Word Name="CONNECTION">
      <Word Name="CONSTRAINT">
      <Word Name="CONSTRAINTS">
      <Word Name="CONTINUE">
      <Word Name="CONVERT">
      <Word Name="CORRESPONDING">
      <Word Name="COUNT">
      <Word Name="CREATE">
      <Word Name="CROSS">
      <Word Name="CURRENT">
      <Word Name="CURRENT_DATE">
      <Word Name="CURRENT_TIME">
      <Word Name="CURRENT_TIMESTAMP">
      <Word Name="CURRENT_USER">
      <Word Name="CURSOR">
      <Word Name="DATE">
      <Word Name="DAY">
      <Word Name="DEALLOCATE">
      <Word Name="DEC">
      <Word Name="DECIMAL">
      <Word Name="DECLARE">
      <Word Name="DEFAULT">
      <Word Name="DEFERRABLE">
      <Word Name="DEFERRED">
      <Word Name="DELETE">
      <Word Name="DESC">
      <Word Name="DESCRIBE">
      <Word Name="DESCRIPTOR">
      <Word Name="DIAGNOSTICS">
      <Word Name="DISCONNECT">
      <Word Name="DISTINCT">
      <Word Name="DOMAIN">
      <Word Name="DOUBLE">
      <Word Name="DROP">
      <Word Name="ELSE">
      <Word Name="END">
      <Word Name="END-EXEC">
      <Word Name="ESCAPE">
      <Word Name="EXCEPT">
      <Word Name="EXCEPTION">
      <Word Name="EXEC">
      <Word Name="EXECUTE">
      <Word Name="EXISTS">
      <Word Name="EXTERNAL">
      <Word Name="EXTRACT">
      <Word Name="FALSE">
      <Word Name="FETCH">
      <Word Name="FIRST">
      <Word Name="FLOAT">
      <Word Name="FOR">
      <Word Name="FOREIGN">
      <Word Name="FORTRAN">
      <Word Name="FOUND">
      <Word Name="FROM">
      <Word Name="FULL">
      <Word Name="GET">
      <Word Name="GLOBAL">
      <Word Name="GO">
      <Word Name="GOTO">
      <Word Name="GRANT">
      <Word Name="GROUP">
      <Word Name="HAVING">
      <Word Name="HOUR">
      <Word Name="IDENTITY">
      <Word Name="IMMEDIATE">
      <Word Name="IN">
      <Word Name="INCLUDE">
      <Word Name="INDEX">
      <Word Name="INDICATOR">
      <Word Name="INITIALLY">
      <Word Name="INNER">
      <Word Name="INPUT">
      <Word Name="INSENSITIVE">
      <Word Name="INSERT">
      <Word Name="INT">
      <Word Name="INTEGER">
      <Word Name="INTERSECT">
      <Word Name="INTERVAL">
      <Word Name="INTO">
      <Word Name="IS">
      <Word Name="ISOLATION">
      <Word Name="JOIN">
      <Word Name="KEY">
      <Word Name="LANGUAGE">
      <Word Name="LAST">
      <Word Name="LEADING">
      <Word Name="LEFT">
      <Word Name="LEVEL">
      <Word Name="LIKE">
      <Word Name="LOCAL">
      <Word Name="LOWER">
      <Word Name="MATCH">
      <Word Name="MAX">
      <Word Name="MIN">
      <Word Name="MINUTE">
      <Word Name="MODULE">
      <Word Name="MONTH">
      <Word Name="NAMES">
      <Word Name="NATIONAL">
      <Word Name="NATURAL">
      <Word Name="NCHAR">
      <Word Name="NEXT">
      <Word Name="NO">
      <Word Name="NONE">
      <Word Name="NOT">
      <Word Name="NULL">
      <Word Name="NULLIF">
      <Word Name="NUMERIC">
      <Word Name="OCTET_LENGTH">
      <Word Name="OF">
      <Word Name="ON">
      <Word Name="ONLY">
      <Word Name="OPEN">
      <Word Name="OPTION">
      <Word Name="OR">
      <Word Name="ORDER">
      <Word Name="OUTER">
      <Word Name="OUTPUT">
      <Word Name="OVERLAPS">
      <Word Name="PAD">
      <Word Name="PARTIAL">
      <Word Name="PASCAL">
      <Word Name="POSITION">
      <Word Name="PRECISION">
      <Word Name="PREPARE">
      <Word Name="PRESERVE">
      <Word Name="PRIMARY">
      <Word Name="PRIOR">
      <Word Name="PRIVILEGES">
      <Word Name="PROCEDURE">
      <Word Name="PUBLIC">
      <Word Name="READ">
      <Word Name="REAL">
      <Word Name="REFERENCES">
      <Word Name="RELATIVE">
      <Word Name="RESTRICT">
      <Word Name="REVOKE">
      <Word Name="RIGHT">
      <Word Name="ROLLBACK">
      <Word Name="ROWS">
      <Word Name="SCHEMA">
      <Word Name="SCROLL">
      <Word Name="SECOND">
      <Word Name="SECTION">
      <Word Name="SELECT">
      <Word Name="SESSION">
      <Word Name="SESSION_USER">
      <Word Name="SET">
      <Word Name="SIZE">
      <Word Name="SMALLINT">
      <Word Name="SOME">
      <Word Name="SPACE">
      <Word Name="SQL">
      <Word Name="SQLCA">
      <Word Name="SQLCODE">
      <Word Name="SQLERROR">
      <Word Name="SQLSTATE">
      <Word Name="SQLWARNING">
      <Word Name="SUBSTRING">
      <Word Name="SUM">
      <Word Name="SYSTEM_USER">
      <Word Name="TABLE">
      <Word Name="TEMPORARY">
      <Word Name="THEN">
      <Word Name="TIME">
      <Word Name="TIMESTAMP">
      <Word Name="TIMEZONE_HOUR">
      <Word Name="TIMEZONE_MINUTE">
      <Word Name="TO">
      <Word Name="TRAILING">
      <Word Name="TRANSACTION">
      <Word Name="TRANSLATE">
      <Word Name="TRANSLATION">
      <Word Name="TRIM">
      <Word Name="TRUE">
      <Word Name="UNION">
      <Word Name="UNIQUE">
      <Word Name="UNKNOWN">
      <Word Name="UPDATE">
      <Word Name="UPPER">
      <Word Name="USAGE">
      <Word Name="USER">
      <Word Name="USING">
      <Word Name="VALUE">
      <Word Name="VALUES">
      <Word Name="VARCHAR">
      <Word Name="VARYING">
      <Word Name="VIEW">
      <Word Name="WHEN">
      <Word Name="WHENEVER">
      <Word Name="WHERE">
      <Word Name="WITH">
      <Word Name="WORK">
      <Word Name="WRITE">
      <Word Name="YEAR">
      <Word Name="ZONE">
   </KeyWords>
   <!-- SQL Syntax -->
   <KeyWords MatchCase="False" Color="SQLWord">
      <Word Name="add">
      <Word Name="all">
      <Word Name="alter">
      <Word Name="and">
      <Word Name="any">
      <Word Name="as">
      <Word Name="asc">
      <Word Name="authorization">
      <Word Name="avg">
      <Word Name="backup">
      <Word Name="begin">
      <Word Name="between">
      <Word Name="break">
      <Word Name="browse">
      <Word Name="bulk">
      <Word Name="by">
      <Word Name="cascade">
      <Word Name="case">
      <Word Name="check">
      <Word Name="checkpoint">
      <Word Name="close">
      <Word Name="clustered">
      <Word Name="coalesce">
      <Word Name="column">
      <Word Name="commit">
      <Word Name="commited">
      <Word Name="compute">
      <Word Name="confirm">
      <Word Name="constraint">
      <Word Name="contains">
      <Word Name="containstable">
      <Word Name="continue">
      <Word Name="controlrow">
      <Word Name="convert">
      <Word Name="count">
      <Word Name="create">
      <Word Name="cross">
      <Word Name="current">
      <Word Name="current_date">
      <Word Name="current_time">
      <Word Name="current_timestamp">
      <Word Name="current_user">
      <Word Name="cursor">
      <Word Name="database">
      <Word Name="dbcc">
      <Word Name="deallocate">
      <Word Name="declare">
      <Word Name="default">
      <Word Name="delete">
      <Word Name="deny">
      <Word Name="desc">
      <Word Name="disk">
      <Word Name="distinct">
      <Word Name="distributed">
      <Word Name="double">
      <Word Name="drop">
      <Word Name="dummy">
      <Word Name="dump">
      <Word Name="else">
      <Word Name="end">
      <Word Name="errlvl">
      <Word Name="errorexit">
      <Word Name="escape">
      <Word Name="except">
      <Word Name="exec">
      <Word Name="exit">
      <Word Name="file">
      <Word Name="fillfactor">
      <Word Name="floppy">
      <Word Name="for">
      <Word Name="foreign">
      <Word Name="freetext">
      <Word Name="freetexttable">
      <Word Name="from">
      <Word Name="full">
      <Word Name="goto">
      <Word Name="grant">
      <Word Name="group">
      <Word Name="having">
      <Word Name="holdlock">
      <Word Name="identity">
      <Word Name="identity_insert">
      <Word Name="identitycol">
      <Word Name="if">
      <Word Name="in">
      <Word Name="index">
      <Word Name="insert">
      <Word Name="intersect">
      <Word Name="into">
      <Word Name="is">
      <Word Name="isolation">
      <Word Name="join">
      <Word Name="key">
      <Word Name="kill">
      <Word Name="left">
      <Word Name="level">
      <Word Name="like">
      <Word Name="lineno">
      <Word Name="load">
      <Word Name="max">
      <Word Name="min">
      <Word Name="mirrorexit">
      <Word Name="national">
      <Word Name="nocheck">
      <Word Name="nonclustered">
      <Word Name="not">
      <Word Name="null">
      <Word Name="nullif">
      <Word Name="of">
      <Word Name="off">
      <Word Name="offsets">
      <Word Name="on">
      <Word Name="once">
      <Word Name="only">
      <Word Name="open">
      <Word Name="opendatasource">
      <Word Name="openquery">
      <Word Name="openrowset">
      <Word Name="option">
      <Word Name="or">
      <Word Name="order">
      <Word Name="outer">
      <Word Name="over">
      <Word Name="percent">
      <Word Name="perm">
      <Word Name="permanent">
      <Word Name="pipe">
      <Word Name="plan">
      <Word Name="precision">
      <Word Name="prepare">
      <Word Name="primary">
      <Word Name="print">
      <Word Name="privileges">
      <Word Name="proc">
      <Word Name="procedure">
      <Word Name="processexit">
      <Word Name="public">
      <Word Name="raiserror">
      <Word Name="read">
      <Word Name="readtext">
      <Word Name="reconfigure">
      <Word Name="references">
      <Word Name="repeatable">
      <Word Name="replication">
      <Word Name="restore">
      <Word Name="restrict">
      <Word Name="return">
      <Word Name="revoke">
      <Word Name="right">
      <Word Name="rollback">
      <Word Name="rowcount">
      <Word Name="rowguidecol">
      <Word Name="rule">
      <Word Name="save">
      <Word Name="schema">
      <Word Name="select">
      <Word Name="serializable">
      <Word Name="session_user">
      <Word Name="set">
      <Word Name="setuser">
      <Word Name="shutdown">
      <Word Name="some">
      <Word Name="statistics">
      <Word Name="sum">
      <Word Name="system_user">
      <Word Name="table">
      <Word Name="tape">
      <Word Name="temp">
      <Word Name="temporary">
      <Word Name="textsize">
      <Word Name="then">
      <Word Name="to">
      <Word Name="top">
      <Word Name="tran">
      <Word Name="transaction">
      <Word Name="trigger">
      <Word Name="truncate">
      <Word Name="tsequal">
      <Word Name="ucommited">
      <Word Name="union">
      <Word Name="unique">
      <Word Name="update">
      <Word Name="updatetext">
      <Word Name="use">
      <Word Name="user">
      <Word Name="values">
      <Word Name="varying">
      <Word Name="view">
      <Word Name="waitfor">
      <Word Name="when">
      <Word Name="where">
      <Word Name="while">
      <Word Name="with">
      <Word Name="work">
      <Word Name="writetext">
   </KeyWords>
   <!-- TSQL functions -->
   <KeyWords MatchCase="False" Color="TSQLfunc">
      <Word Name="abs">
      <Word Name="acos">
      <Word Name="all">
      <Word Name="and">
      <Word Name="any">
      <Word Name="ascii">
      <Word Name="asin">
      <Word Name="atan">
      <Word Name="atn2">
      <Word Name="avg">
      <Word Name="case">
      <Word Name="cast">
      <Word Name="ceiling">
      <Word Name="CHAR">
      <Word Name="CHARINDEX">
      <Word Name="convert">
      <Word Name="cos">
      <Word Name="current_timestamp">
      <Word Name="current_user">
      <Word Name="cursor_status">
      <Word Name="datalenght">
      <Word Name="date">
      <Word Name="dateadd">
      <Word Name="datediff">
      <Word Name="datename">
      <Word Name="datepart">
      <Word Name="decode">
      <Word Name="degrees">
      <Word Name="DIFFERENCE">
      <Word Name="exp">
      <Word Name="floor">
      <Word Name="getdate">
      <Word Name="identity">
      <Word Name="LEFT">
      <Word Name="LEN">
      <Word Name="log">
      <Word Name="log10">
      <Word Name="LOWER">
      <Word Name="LTRIM">
      <Word Name="NCHAR">
      <Word Name="object_id">
      <Word Name="object_name">
      <Word Name="objectproperty">
      <Word Name="odbc">
      <Word Name="openquery">
      <Word Name="openrowset">
      <Word Name="parsename">
      <Word Name="PATINDEX">
      <Word Name="power">
      <Word Name="rand">
      <Word Name="readtext">
      <Word Name="REPLACE">
      <Word Name="QUOTENAME">
      <Word Name="REPLICATE">
      <Word Name="REVERSE">
      <Word Name="RIGHT">
      <Word Name="RTRIM">
      <Word Name="sin">
      <Word Name="SOUNDEX">
      <Word Name="SPACE">
      <Word Name="STR">
      <Word Name="STUFF">
      <Word Name="SUBSTRING">
      <Word Name="UNICODE">
      <Word Name="updatetext">
      <Word Name="UPPER">
      <Word Name="PATINDEX">
      <Word Name="TEXTPTR">
      <Word Name="TEXTVALID">
      <Word Name="writetext">
   </KeyWords>

</Scheme>