Analitcs

Pesquisar no conteúdo do blog.atlabs.com.br

quinta-feira, 10 de novembro de 2016

Delphi - Firedac - Processando Comandos em diversos bancos de dados diferentes - Preprocessing Command Text (FireDAC)

Reações: 
Retirado de:

http://docwiki.embarcadero.com/RADStudio/Berlin/en/Preprocessing_Command_Text_(FireDAC)


SQL Dialect Abstraction

If the application needs to support multiple DBMSs, it must be aware that their SQL dialects may be different. FireDAC escape sequences allow you to write SQL dialect-independent SQL commands.
For example, the function to convert string to upper case is different in MySQL, Oracle, and Microsoft SQL Server. But the following command works on any DBMS:
SELECT {ucase(Name)} FROM MyTable
Note that with SQLite, you need to add the FireDAC.Stan.ExprFuncs unit to your "uses" clause. In more complex cases, parts of the command or even the full command must be written differently. Then, the FireDAC conditional escape sequence helps:
{IF Oracle} SELECT * FROM OracleTab {fi}
For example:
{iif (Oracle, TO_CHAR, MSSQL, CONVERT)}          -> ‘TO_CHAR’ ON Oracle ANDCONVERTON SQL Server.
{iif (&v1, Me, &v2, You, We)}                   -> ‘Me’ IF &v1 has nonempty VALUE, ‘you’ IF &v2 has nonempty VALUE, otherwise ‘We’.
{IF Oracle} TO_CHAR {fi} {IF MSSQL} CONVERT {fi} -> TO_CHAR ON Oracle AND CONVERT ON SQL Server.
{IF &v1} Me {fi} {IF &v2} You {fi} -> ‘Me’ IF &v1 has nonempty VALUE + ‘you’ IF &v2 has nonempty VALUE.{
IF MSSQL} SELECT * FROM MSSQLTab {fi}

terça-feira, 8 de novembro de 2016

MSSQL(SQL SERVER) - Procedure Refresh Sequence

Reações: 
CREATE PROCEDURE [dbo].[REFRESH_SEQ_ID]     @NM_SEQ_ID VARCHAR(100),  @TBL varchar(128)  
AS  
BEGIN    
 declare @ParmDefinition NVARCHAR(500);
 declare @VLR integer;
 declare @SQLVLR NVARCHAR(500);
 Set @ParmDefinition = N'@VLROUT Int output';
 Set @SQLVLR = 'SELECT @VLROUT = MAX(*) + 1 FROM ' + @TBL;
   EXEC sp_executesql @SQLVLR, @ParmDefinition, @VLROUT = @VLR OUT;
 declare @SQL varchar(1024) = 'ALTER SEQUENCE ' + cast(@NM_SEQ_ID as varchar(100)) + ' RESTART WITH ' + cast(@VLR as varchar(10)); 
 Begin tran T0; 
   Exec(@SQL);
 Commit tran T0;  
END 
Usando a procedure:
execute REFRESH_SEQ_ID @NM_SEQ_ID = 'SEQ_ID_TABELA', @TBL = 'TBLTABELA';

sexta-feira, 4 de novembro de 2016

DELPHI - Nomes atualizados das Units

Reações: 
As vezes me perguntam: aonde está a unit "jpeg"

Abaixo a solução para suas perguntas



Retirado de:
http://docwiki.embarcadero.com/RADStudio/Seattle/en/Unit_Names_Alphabetical_List_with_Unit_Scopes


Unit Names - Alphabetical List with Unit Scopes


Go Up to Unit Scope Names


This topic contains a reference list of the unit names in RAD Studio along with their associated unit scope names. You can search for a particular unit of interest, and immediately see the unit scope to which the unit belongs.
YellowBang.pngCaution: This list is a snapshot of the XE2 release and will never be updated to reflect subsequent releases.

Alphabetical List of Units with Their Unit Scope Names

ABAccessibility = Vcl.ABAccessibility
AbnfUtils = Xml.Internal.AbnfUtils
AccCtrl = Winapi.AccCtrl
AclAPI = Winapi.AclAPI
ActiveX = Winapi.ActiveX
ActnColorMaps = Vcl.ActnColorMaps
ActnCtrls = Vcl.ActnCtrls
ActnList = Vcl.ActnList
ActnMan = Vcl.ActnMan
ActnMenus = Vcl.ActnMenus
ActnPopup = Vcl.ActnPopup
ADOConst = Data.Win.ADOConst
ADODB = Data.Win.ADODB
ADOInt = Winapi.ADOInt
AdomCore_4_3 = Xml.Internal.AdomCore_4_3
adomxmldom = Xml.adomxmldom
AnsiStrings = System.AnsiStrings
ApacheApp = Web.ApacheApp
ApacheHTTP = Web.ApacheHTTP
ApacheTwoApp = Web.ApacheTwoApp
ApacheTwoHTTP = Web.ApacheTwoHTTP
AppEvnts = Vcl.AppEvnts
AspTlb = Winapi.AspTlb
AutoDisp = Web.AutoDisp
AxCtrls = Vcl.AxCtrls
BandActn = Vcl.BandActn
Bdeconst = Bde.Bdeconst
BindCompDB = Data.Bind.DBScope
BindCompDBLinks = Data.Bind.DBLinks
BindCompEditors = Data.Bind.Editors
BindCompEngExt = Data.Bind.EngExt
BindCompFMXDBEngExt = Fmx.Bind.DBEngExt
BindCompFMXDBLinks = Fmx.Bind.DBLinks
BindCompFMXEditors = Fmx.Bind.Editors
BindCompFMXHandlers = Fmx.Bind.Handlers
BindCompFMXNavigator = Fmx.Bind.Navigator
BindCompFMXResStrs = Fmx.Bind.Consts
BindComponents = Data.Bind.Components
BindCompResStrs = Data.Bind.Consts
BindCompVCLDBEngExt = Vcl.Bind.DBEngExt
BindCompVCLEditors = Vcl.Bind.Editors
BindCompVCLHandlers = Vcl.Bind.Handlers
BindCompVCLResStrs = Vcl.Bind.Consts
BindHelper = System.Bindings.Helper
BindingCustomScope = System.Bindings.CustomScope
BindingCustomWrapper = System.Bindings.CustomWrapper
BindingEngineResStrs = System.Bindings.Consts
BindingExpression = System.Bindings.Expression
BindingExpressionDefaults = System.Bindings.ExpressionDefaults
BindingFactories = System.Bindings.Factories
BindingGraph = System.Bindings.Graph
BindingManager = System.Bindings.Manager
BindingManagerDefaults = System.Bindings.ManagerDefaults
BindingMethods = System.Bindings.Methods
BindingNotifierContracts = System.Bindings.NotifierContracts
BindingNotifierDefaults = System.Bindings.NotifierDefaults
BindingOutputs = System.Bindings.Outputs
BindingSearch = System.Bindings.Search
BrkrConst = Web.BrkrConst
ButtonGroup = Vcl.ButtonGroup
Buttons = Vcl.Buttons
Calendar = Vcl.Samples.Calendar
CaptionedDockTree = Vcl.CaptionedDockTree
CategoryButtons = Vcl.CategoryButtons
CFUtils = System.Mac.CFUtils
CGIApp = Web.CGIApp
CGIHTTP = Web.CGIHTTP
Character = System.Character
CheckLst = Vcl.CheckLst
Classes = System.Classes
Clipbrd = Vcl.Clipbrd
CmAdmCtl = Vcl.CmAdmCtl
CodecUtilsWin32 = Xml.Internal.CodecUtilsWin32
ColorGrd = Vcl.ColorGrd
COMAdmin = Winapi.COMAdmin
ComConst = System.Win.ComConst
ComCtrls = Vcl.ComCtrls
CommCtrl = Winapi.CommCtrl
CommDlg = Winapi.CommDlg
ComObj = System.Win.ComObj
ComObjWrapper = System.Win.ComObjWrapper
ComServ = System.Win.ComServ
ComStrs = Vcl.ComStrs
ComSvcs = Winapi.ComSvcs
Consts = Vcl.Consts
Contnrs = System.Contnrs
Controls = Vcl.Controls
ConvUtils = System.ConvUtils
CopyPrsr = Web.CopyPrsr
Cor = Winapi.Cor
CorError = Winapi.CorError
CorHdr = Winapi.CorHdr
Cpl = Winapi.Cpl
CustomizeDlg = Vcl.CustomizeDlg
D2D1 = Winapi.D2D1
D3DX8 = Winapi.D3DX8
D3DX9 = Winapi.D3DX9
DataBkr = Datasnap.DataBkr
DateUtils = System.DateUtils
DB = Data.DB
DBActns = Vcl.DBActns
DBBdeWeb = Bde.DBBdeWeb
DBByteBuffer = Data.DBByteBuffer
DBCGrids = Vcl.DBCGrids
DBClient = Datasnap.DBClient
DBClientActns = Vcl.DBClientActns
DBCommon = Data.DBCommon
DBCommonTypes = Data.DBCommonTypes
DBConnAdmin = Data.DBConnAdmin
DBConsts = Data.DBConsts
DBCtrls = Vcl.DBCtrls
DBGrids = Vcl.DBGrids
DBLogDlg = Vcl.DBLogDlg
DBLookup = Vcl.DBLookup
DBOleCtl = Vcl.DBOleCtl
DBPlatform = Data.DBPlatform
DBPWDlg = Vcl.DBPWDlg
DBTables = Bde.DBTables
DBWeb = Web.DBWeb
DBXClassRegistry = Data.DBXClassRegistry
DBXClient = Data.DBXClient
DBXClientResStrs = Data.DBXClientResStrs
DBXCommon = Data.DBXCommon
DBXCommonIndy = Data.DBXCommonIndy
DBXCommonResStrs = Data.DBXCommonResStrs
DBXCommonTable = Data.DBXCommonTable
DbxCompressionFilter = Data.DbxCompressionFilter
DBXDataExpressMetaDataProvider = Data.DBXDataExpressMetaDataProvider
DbxDatasnap = Data.DbxDatasnap
DBXDBReaders = Data.DBXDBReaders
DBXDelegate = Data.DBXDelegate
DBXDynalink = Data.DBXDynalink
DBXDynalinkNative = Data.DBXDynalinkNative
DBXEncryption = Data.DBXEncryption
DBXJSON = Data.DBXJSON
DBXJSONCommon = Data.DBXJSONCommon
DBXJSONReflect = Data.DBXJSONReflect
DBXMemoryRow = Data.DBXMemoryRow
DBXMessageHandlerCommon = Data.DBXMessageHandlerCommon
DBXMessageHandlerJSonClient = Data.DBXMessageHandlerJSonClient
DBXMessageHandlerJSonCommon = Data.DBXMessageHandlerJSonCommon
DBXMessageHandlerJSonServer = Data.DBXMessageHandlerJSonServer
DBXMessageHandlerServer = Data.DBXMessageHandlerServer
DBXMetaDataCommand = Data.DBXMetaDataCommand
DBXMetaDataCommandFactory = Data.DBXMetaDataCommandFactory
DBXMetadataCommon = Data.DBXMetadataCommon
DBXMetaDataError = Data.DBXMetaDataError
DBXMetaDataNames = Data.DBXMetaDataNames
DBXMetaDataProvider = Data.DBXMetaDataProvider
DBXMetaDataReader = Data.DBXMetaDataReader
DBXMetaDataUtil = Data.DBXMetaDataUtil
DBXMetaDataWriter = Data.DBXMetaDataWriter
DBXMetaDataWriterFactory = Data.DBXMetaDataWriterFactory
DBXOpenSSL = Data.DBXOpenSSL
DBXOpenSSLRes = Data.DBXOpenSSLRes
DBXPlatform = Data.DBXPlatform
DBXPool = Data.DBXPool
DBXpressWeb = Web.DBXpressWeb
DBXReaderTableStorage = Data.DBXReaderTableStorage
DBXRSAFilter = Data.DBXRSAFilter
DbxSocketChannelNative = Data.DbxSocketChannelNative
DBXSqlScanner = Data.DBXSqlScanner
DBXStream = Data.DBXStream
DBXStreamer = Data.DBXStreamer
DBXStreamPlatform = Data.DBXStreamPlatform
DBXTableFactory = Data.DBXTableFactory
DBXTrace = Data.DBXTrace
DBXTransport = Data.DBXTransport
DBXTransportFilter = Data.DBXTransportFilter
DBXTypedTableStorage = Data.DBXTypedTableStorage
DdeMan = Vcl.DdeMan
DDEml = Winapi.DDEml
DebugUtils = System.DebugUtils
Diagnostics = System.Diagnostics
Dialogs = Vcl.Dialogs
Direct2D = Vcl.Direct2D
Direct3D = Winapi.Direct3D
Direct3D8 = Winapi.Direct3D8
Direct3D9 = Winapi.Direct3D9
DirectDraw = Winapi.DirectDraw
DirectInput = Winapi.DirectInput
DirectMusic = Winapi.DirectMusic
DirectPlay8 = Winapi.DirectPlay8
DirectSetup = Winapi.DirectSetup
DirectShow9 = Winapi.DirectShow9
DirectSound = Winapi.DirectSound
DirOutln = Vcl.Samples.DirOutln
Dlgs = Winapi.Dlgs
DockTabSet = Vcl.DockTabSet
DrTable = Bde.DrTable
DSClientMetadata = Datasnap.DSClientMetadata
DSClientResStrs = Datasnap.DSClientResStrs
DSClientRest = Datasnap.DSClientRest
DSCommonProxy = Datasnap.DSCommonProxy
DSCommonServer = Datasnap.DSCommonServer
DSCommonTable = Datasnap.DSCommonTable
DSConnect = Datasnap.DSConnect
DSHTTP = Datasnap.DSHTTP
DSHTTPCommon = Datasnap.DSHTTPCommon
DSHTTPLayer = Datasnap.DSHTTPLayer
DSHTTPWebBroker = Datasnap.DSHTTPWebBroker
DSIntf = Datasnap.DSIntf
DSLoginDlg = Datasnap.DSLoginDlg
DSNames = Datasnap.DSNames
DSPlatform = Datasnap.DSPlatform
DSProd = Web.DSProd
DSProxy = Datasnap.DSProxy
DSProxyCpp = Datasnap.DSProxyCpp
DSProxyCppRest = Datasnap.DSProxyCppRest
DSProxyDelphi = Datasnap.DSProxyDelphi
DSProxyDelphiRest = Datasnap.DSProxyDelphiRest
DSProxyJavaScript = Datasnap.DSProxyJavaScript
DSProxyRest = Datasnap.DSProxyRest
DSProxyWriter = Datasnap.DSProxyWriter
DSProxyWriterRegistry = Datasnap.DSProxyWriterRegistry
DSReflect = Datasnap.DSReflect
DSServer = Datasnap.DSServer
DSServerResStrs = Datasnap.DSServerResStrs
DSService = Datasnap.DSService
DSTCPServerTransport = Datasnap.DSTCPServerTransport
DSTransport = Datasnap.DSTransport
DSUtil = Data.DSUtil
DTDSchema = Xml.DTDSchema
DwmApi = Winapi.DwmApi
DX7toDX8 = Winapi.DX7toDX8
DxDiag = Winapi.DxDiag
DXErr8 = Winapi.DXErr8
DXErr9 = Winapi.DXErr9
DXFile = Winapi.DXFile
DxgiFormat = Winapi.DxgiFormat
DXTypes = Winapi.DXTypes
EncdDecd = Soap.EncdDecd
EncodingUtils = Xml.Internal.EncodingUtils
EvalProtocol = System.Bindings.EvalProtocol
EvalSys = System.Bindings.EvalSys
Evaluator = System.Bindings.Evaluator
ExcUtils = System.ExcUtils
ExtActns = Vcl.ExtActns
ExtCtrls = Vcl.ExtCtrls
ExtDlgs = Vcl.ExtDlgs
ExtThemes = Vcl.ExtThemes
FileCtrl = Vcl.FileCtrl
FlatSB = Winapi.FlatSB
FMTBcd = Data.FMTBcd
Forms = Vcl.Forms
Gauges = Vcl.Samples.Gauges
GDIPAPI = Winapi.GDIPAPI
GDIPOBJ = Winapi.GDIPOBJ
GDIPUTIL = Winapi.GDIPUTIL
Generics.Collections = System.Generics.Collections
Generics.Defaults = System.Generics.Defaults
GestureConsts = Vcl.Touch.GestureConsts
GestureCtrls = Vcl.Touch.GestureCtrls
GestureMgr = Vcl.Touch.GestureMgr
Gestures = Vcl.Touch.Gestures
GIFConsts = Vcl.Imaging.GIFConsts
GIFImg = Vcl.Imaging.GIFImg
Graphics = Vcl.Graphics
GraphUtil = Vcl.GraphUtil
Grids = Vcl.Grids
HelpIntfs = System.HelpIntfs
HtmlHelpViewer = Vcl.HtmlHelpViewer
HTTPApp = Web.HTTPApp
HTTPD = Web.HTTPD
HTTPD2 = Web.HTTPD2
HTTPProd = Web.HTTPProd
HTTPSOAPTBind = Soap.HTTPSOAPTBind
HTTPUtil = Soap.HTTPUtil
ImageHlp = Winapi.ImageHlp
ImgList = Vcl.ImgList
Imm = Winapi.Imm
IMouse = Vcl.IMouse
IniFiles = System.IniFiles
inquire_v1 = Soap.inquire_v1
IntfInfo = Soap.IntfInfo
InvConst = Soap.InvConst
Invoker = Soap.Invoker
InvokeRegistry = Soap.InvokeRegistry
IOUtils = System.IOUtils
IpExport = Winapi.IpExport
IpHlpApi = Winapi.IpHlpApi
IpRtrMib = Winapi.IpRtrMib
IpTypes = Winapi.IpTypes
Isapi = Winapi.Isapi
Isapi2 = Winapi.Isapi2
ISAPIApp = Web.Win.ISAPIApp
IsapiHTTP = Web.Win.IsapiHTTP
ISAPIThreadPool = Web.Win.ISAPIThreadPool
JConsts = Vcl.Imaging.JConsts
jpeg = Vcl.Imaging.jpeg
Keyboard = Vcl.Touch.Keyboard
KeyboardTypes = Vcl.Touch.KeyboardTypes
KnownFolders = Winapi.KnownFolders
LangUtils = Xml.Internal.LangUtils
LibHelp = Vcl.LibHelp
ListActns = Vcl.ListActns
LZExpand = Winapi.LZExpand
Manipulations = Winapi.Manipulations
Mapi = Winapi.Mapi
Mask = Vcl.Mask
Masks = System.Masks
MaskUtils = System.MaskUtils
Math = System.Math
MConnect = Datasnap.Win.MConnect
Menus = Vcl.Menus
Messages = Winapi.Messages
Midas = Datasnap.Midas
MidasCon = Datasnap.Win.MidasCon
MidConst = Datasnap.MidConst
MMSystem = Winapi.MMSystem
MPlayer = Vcl.MPlayer
MsInkAut = Winapi.MsInkAut
MsInkAut15 = Winapi.MsInkAut15
msxml = Winapi.msxml
Mtsobj = System.Win.Mtsobj
MtsRdm = Datasnap.Win.MtsRdm
Mtx = Winapi.Mtx
MultiMon = Winapi.MultiMon
Nb30 = Winapi.Nb30
ObjAuto = System.ObjAuto
ObjBrkr = Datasnap.Win.ObjBrkr
ObjComAuto = System.Win.ObjComAuto
ObjectArray = Winapi.ObjectArray
ObjEval = System.Bindings.ObjEval
Ole2 = Winapi.Ole2
oleacc = Winapi.oleacc
OleAuto = Vcl.OleAuto
OleConst = Vcl.OleConst
OleCtl = Winapi.OleCtl
OleCtnrs = Vcl.OleCtnrs
OleCtrls = Vcl.OleCtrls
OleDB = Winapi.OleDB
OleDlg = Winapi.OleDlg
OleServer = Vcl.OleServer
OPConvert = Soap.OPConvert
OpConvertOptions = Soap.OpConvertOptions
OpenGL = Winapi.OpenGL
OPToSOAPDomConv = Soap.OPToSOAPDomConv
OPToSOAPDomCustom = Soap.OPToSOAPDomCustom
Outline = Vcl.Outline
ParserUtilsWin32 = Xml.Internal.ParserUtilsWin32
Penwin = Winapi.Penwin
PenWinapi = Winapi.PenWinapi
PlatformDefaultStyleActnCtrls = Vcl.PlatformDefaultStyleActnCtrls
pngextra = Vcl.Imaging.pngextra
pngimage = Vcl.Imaging.pngimage
pnglang = Vcl.Imaging.pnglang
Printers = Vcl.Printers
PropKey = Winapi.PropKey
PropSys = Winapi.PropSys
Provider = Datasnap.Provider
PsAPI = Winapi.PsAPI
Qos = Winapi.Qos
recerror = Vcl.recerror
Registry = System.Win.Registry
RegStr = Winapi.RegStr
RegularExpressions = System.RegularExpressions
RegularExpressionsAPI = System.RegularExpressionsAPI
RegularExpressionsConsts = System.RegularExpressionsConsts
RegularExpressionsCore = System.RegularExpressionsCore
Ribbon = Vcl.Ribbon
RibbonActnCtrls = Vcl.RibbonActnCtrls
RibbonActnMenus = Vcl.RibbonActnMenus
RibbonConsts = Vcl.RibbonConsts
RibbonGalleryBar = Vcl.RibbonGalleryBar
RibbonLunaStyleActnCtrls = Vcl.RibbonLunaStyleActnCtrls
RibbonObsidianStyleActnCtrls = Vcl.RibbonObsidianStyleActnCtrls
RibbonSilverStyleActnCtrls = Vcl.RibbonSilverStyleActnCtrls
RibbonStyleActnCtrls = Vcl.RibbonStyleActnCtrls
RichEdit = Winapi.RichEdit
Rio = Soap.Rio
RTLConsts = System.RTLConsts
RtsCom = Winapi.RtsCom
Rtti = System.Rtti
ScktComp = System.Win.ScktComp
SConnect = Datasnap.Win.SConnect
ScreenTips = Vcl.ScreenTips
ShadowWnd = Vcl.ShadowWnd
Sharemem = System.Sharemem
ShellAnimations = Vcl.ShellAnimations
ShellAPI = Winapi.ShellAPI
ShellConsts = Vcl.Shell.ShellConsts
ShellCtrls = Vcl.Shell.ShellCtrls
SHFolder = Winapi.SHFolder
ShlObj = Winapi.ShlObj
ShLwApi = Winapi.ShLwApi
SimpleShareMem = System.SimpleShareMem
SMINTF = Bde.SMINTF
SOAInv = Soap.SOAInv
SOAPAttach = Soap.SOAPAttach
SOAPAttachIntf = Soap.SOAPAttachIntf
SOAPConn = Soap.SOAPConn
SOAPConst = Soap.SOAPConst
SOAPDm = Soap.SOAPDm
SOAPDomConv = Soap.SOAPDomConv
SOAPEnv = Soap.SOAPEnv
SOAPHTTInv = Soap.SOAPHTTInv
SOAPHTTPClient = Soap.SOAPHTTPClient
SOAPHTTPDisp = Soap.SOAPHTTPDisp
SOAPHTTPTrans = Soap.SOAPHTTPTrans
SOAPLinked = Soap.SOAPLinked
SOAPMidas = Soap.SOAPMidas
Sockets = System.Win.ScktComp
Spin = Vcl.Samples.Spin
SqlConst = Data.SqlConst
SqlExpr = Data.SqlExpr
SqlTimSt = Data.SqlTimSt
StdActnMenus = Vcl.StdActnMenus
StdActns = Vcl.StdActns
StdConvs = System.StdConvs
StdCtrls = Vcl.StdCtrls
StdStyleActnCtrls = Vcl.StdStyleActnCtrls
StdVCL = System.Win.StdVCL
StructuredQuery = Winapi.StructuredQuery
StructuredQueryCondition = Winapi.StructuredQueryCondition
StrUtils = System.StrUtils
SvcMgr = Vcl.SvcMgr
SyncObjs = System.SyncObjs
SysConst = System.SysConst
SysUtils = System.SysUtils
TabNotBk = Vcl.TabNotBk
Tabs = Vcl.Tabs
TConnect = Datasnap.Win.TConnect
ThemedActnCtrls = Vcl.ThemedActnCtrls
ThemeHooks = Vcl.ThemeHooks
Themes = Vcl.Themes
TimeSpan = System.TimeSpan
TlHelp32 = Winapi.TlHelp32
ToolWin = Vcl.ToolWin
TpcShrd = Winapi.TpcShrd
TreeUtils = Xml.Internal.TreeUtils
Types = System.Types
TypeTrans = Soap.TypeTrans
TypInfo = System.TypInfo
UDDIHelper = Soap.UDDIHelper
UITypes = System.UITypes
UriUtils = Xml.Internal.UriUtils
UrlMon = Winapi.UrlMon
UxTheme = Winapi.UxTheme
ValEdit = Vcl.ValEdit
VarCmplx = System.VarCmplx
VarConv = System.VarConv
Variants = System.Variants
VarUtils = System.VarUtils
VCLCom = System.Win.VCLCom
VDBConsts = Vcl.VDBConsts
WebBroker = Web.WebBroker
WebBrokerSOAP = Soap.WebBrokerSOAP
WebCntxt = Web.WebCntxt
WebConst = Web.WebConst
WebFileDispatcher = Web.WebFileDispatcher
WebNode = Soap.WebNode
WebReq = Web.WebReq
WebServExp = Soap.WebServExp
WideStrings = System.WideStrings
WideStringUtils = Xml.Internal.WideStringUtils
WideStrUtils = System.WideStrUtils
Win.CertHelper = Soap.Win.CertHelper
Win.msxmldom = Xml.Win.msxmldom
Wincodec = Winapi.Wincodec
WinCrtl = Winapi.WinCrtl
Windows = Winapi.Windows
WinHelpViewer = Vcl.WinHelpViewer
WinInet = Winapi.WinInet
Winsafer = Winapi.Winsafer
WinSock = Winapi.WinSock
Winsock2 = Winapi.Winsock2
WinSpool = Winapi.WinSpool
WinSvc = Winapi.WinSvc
WMF9 = Winapi.WMF9
WSDLBind = Soap.WSDLBind
WSDLIntf = Soap.WSDLIntf
WSDLItems = Soap.WSDLItems
WSDLLookup = Soap.WSDLLookup
WSDLNode = Soap.WSDLNode
WSDLPub = Soap.WSDLPub
WSDLSOAP = Soap.WSDLSOAP
WSILIntf = Soap.WSILIntf
XDRSchema = Xml.XDRSchema
XMLConst = Xml.XMLConst
XMLDataToSchema = Xml.XMLDataToSchema
XMLDoc = Xml.XMLDoc
xmldom = Xml.xmldom
XMLIniFile = Xml.XMLIniFile
XMLIntf = Xml.XMLIntf
XmlRulesUtils = Xml.Internal.XmlRulesUtils
XMLSchema = Xml.XMLSchema
XMLSchema99 = Xml.XMLSchema99
XMLSchemaTags = Xml.XMLSchemaTags
XPActnCtrls = Vcl.XPActnCtrls
XPMan = Vcl.XPMan
XPStyleActnCtrls = Vcl.XPStyleActnCtrls
XSBuiltIns = Soap.XSBuiltIns
ZLib = System.ZLib
ZLibConst = System.ZLibConst 

Max Gehringer