Search results for query: *

Hello. Can anyone tell me how to validate an XML file using an ISO Schematron (.sch) file from within a Java application? I want to be able to validate an XML file (provided by the User) against my .sch file. But to be honest I don't really know where to start, so I would really appreciate your...

Hi, I want to add a check constraint that will allow a column to contain either A, A3, A4 or A5. At present I've written it as Col = 'A' OR Col='A3' ... but I was hoping to use something like Col='A|A[3-5]' but this doesn't appear to work. Any suggestions? woogoo

Hi All, I want to create this Trigger: CREATE TRIGGER [dbo].[TR_Info_Insertion] ON [dbo].[Information] FOR INSERT AS BEGIN CASE Inserted.VarType WHEN 'EB' THEN Inserted.EB = Inserted.Price WHEN 'ES' THEN Inserted.ES = Inserted.Price END END ; But when parsed I get an error: Msg 156...

Given this: CREATE FUNCTION [dbo].[GetCSVExpectedF] ( @Table nvarchar(32), @Type char(1) ) RETURNS datetime AS BEGIN DECLARE @ID bigint ; DECLARE @Ref nvarchar(32) ; DECLARE @Result datetime ; DECLARE @Query nvarchar(1024) ; SELECT @ref = Reference FROM CSV_LookUp WHERE ((FileName =...

Hi All, I have a log file that contains various TraceEvents and I would like to include the appropriate Icon when displayed in the log file viewer (a ListView with a smallImageList). I'm looking for icons such as Stop, Start, Critical, Information etc. But I need to get these icons in the first...

Hi All, I need to find the charindex() of the last occurrance of a character within string, but this is proving awkward to solve can anyone help here? -- woogoo

Hi All, I have been given a file in the following format: <ItemInformation xmlns="http://tempuri.org/ItemInfo.xsd"> <ItemDetails> <Title>This is the item title</Title> <State>This is the item state</State> <ItemCost ... /> <ItemCost ... /> <ReOrder>...

Hi All, Is it (really) possible to implement true parallel transacions using VB.NET (v3.5 and 2008) and SQL Server 2005? I've tried various attempts at this but nothing seems to work. In my code I start up 10 instances of a SQLConnection using this connection string: ... m_Connections.Add(New...

A simple question does SQL Server 2005 support true parallel transactions via a third party application? If it does are there any settings that need to be done in order to implement this, and if so what are they? Thanks. woogoo

Hi, I've created a (SQL Auth) Login and User details for an application I am writing, this application needs access to the INFORMATION_SCHEMA views. But whenever I try to grant SELECT permissions I get told: Cannot find the user 'DSSelector', because it does not exist or you do not have...

Hi, I have an Generic.List(Of MyObjects) these Objects implement IDisposable and as a result I want to clean up on exit. Regardless of how I attack this I get an error when trying this (or similar): Protected Overrides Sub OnStop() ' Service is stopping so clean up. Dim...

Hi, I want to write a trigger that will ensure that values entered or updated into a series of columns are monotonic. But I can't seem to access the current column values! Under SQL Server 2005 I thought the syntax was Inserted., Deleted. etc., but no. Can someone tell me what it is as there...

Mmmm, maybe not the best title for the problem but here is what I've got : SELECT Item, I1, V1, I2, V2, I3, V3, I4, V4, I5, V5 FROM MyTable ; Simple, however I now want to return only One set of Items (I) and one set of Prices (P) from the above result set ordered on P ASC. ROW 1 Item A, 0...

Hi, is it possible using VB / .NET 3.5 to check a disk's level of fragmentation? If so, can someone point me in the right direction. Thanks. woogoo

Hi, Using a single SQLConnection object, 4 SQLCommand objects and 4 BackgroundWorkers I'm trying to execute 4 Parallel Transactions on a SQL Server database. Regardless of how I set the MultipleActiveResultSets property on the Connection object's connection string I always get an error saying...

Hi All, In one of my applications I use a 3rd Party DLL that uses the 'Declare Function' statement for importing the DLLs functions, but my problem lies in the fact that I need to support two versions of the DLL. At present with the exception of the DLL's name the Declare statements are...

Hi, This is what I'm doing: Opening a file and reading it into a byte array. GZipping the byte array to a RW FileStream. Reading the GZipped Stream into a new byte array and 3DES encoding it. Writing this new byte array back to the RW Stream. Having written the file, if you then...

Hi, is it possible to dock a borderless form within a panel, I've had various attempts at this but with no success. Any help would be appreciated. -- woogoo

Hi all, this is a bit off topic but I'm looking for an Icon (.ico) of a PFX (Personal Information Exchange) file. I could extract it from a DLL but I don't know where to find it, can anyone help me out please. -- woogoo

Hi, I'm scratching my head over this (I assume trivial) task. I want to skip outputing a table within my HTML transformation, when a given elements value is "no" (well ideally ignoring case). I've tried several variations from <xsl:if test="ELF = 'Yes'"> to using fn:match(..., ...) but some...