![]() |
Chilkat • HOME • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi DLL • Go • Java • Node.js • Objective-C • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(SQL Server) SearchAllForContentDemonstrates the SearchAllForContent method.
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) DECLARE @xml int -- Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @xBeginAfter int DECLARE @xFound int DECLARE @success int EXEC sp_OAMethod @xml, 'LoadXmlFile', @success OUT, 'qa_data/xml/pigs.xml' IF @success <> 1 BEGIN EXEC sp_OAGetProperty @xml, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @xml RETURN END EXEC sp_OAMethod @xml, 'GetSelf', @xBeginAfter OUT EXEC sp_OAMethod @xml, 'SearchAllForContent', @xFound OUT, @xBeginAfter, '*pig*' DECLARE @searchForMore int SELECT @searchForMore = 1 WHILE (@searchForMore = 1) BEGIN EXEC sp_OAGetProperty @xFound, 'Tag', @sTmp0 OUT PRINT @sTmp0 EXEC sp_OAGetProperty @xFound, 'Content', @sTmp0 OUT PRINT @sTmp0 PRINT '--' EXEC @hr = sp_OADestroy @xBeginAfter SELECT @xBeginAfter = @xFound EXEC sp_OAMethod @xml, 'SearchAllForContent', @xFound OUT, @xBeginAfter, '*pig*' EXEC sp_OAGetProperty @xml, 'LastMethodSuccess', @searchForMore OUT END EXEC @hr = sp_OADestroy @xBeginAfter EXEC @hr = sp_OADestroy @xml END GO |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.