Recent content by woogoo

Hi TonHu, thanks for the reply but it only makes a passing reference to Schematron but the second link looks more promising even thought it appears to have stopped development. -- woogoo

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

Hey RiverGuy, thanks for the reply, it does of course explain everything! 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...

Thanks. bborissov, trying your way I get: Only functions and extended stored procedures can be executed from within a function. And without it I get: Could not find stored procedure 'SELECT @Result = MAX(SettlementDay) FROM Headers_Info WHERE (Type = 'P')'. I think it's back to the drawing...

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>...

Just to say that I now have this fixed, and I can now execute n transactions concurrently, having hived off a select on to another connection. woogoo

Hey, thanks for the reply, but as you'll see from the code listing it is turned off, which is why I can't understand why this doesn't work. I've read and researched and according to what I have read then there is no reason as to why my approach shouldn't work, so this leaves I've not properly...

Does anyone have any insight into this? I suspect that I'm barking up the wrong tree here and SQL Server doesn't really support true parallel transactions. What I mean by 'true' is multiple threads concurrently accessing and using the same stored procedures but executed under uniquely named...

Can I assume from my lack of response that no one has ever had this working? I suspect myself that it doesn't, but as I can't prove otherwise... -- woogoo

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...