Search results for query: *

I've got a table which has columns customer_id, A, B, seq. Customers can have multiples of A and B, and when this happens the seq gets incremented: customer_id A B seq 1 1 1 1 1 1 1 2 1 2 1 1 1 2 2 1To make this simple, I want to write an INSERT that...

I have a situation where where we filter records based on access groups. Currently (it's an older system) we get a list of groups using any one of a number of reasonably complex queries up front and put them into working storage, and then open a cursor on another query. As we retrieve each row...

I know I can use Ubound and Lbound to find the size of the dimensions of a dynamic array. But is there anything I can use to determine the number of dimensions the array has at run time? I was hoping that Ubound(Array, n) would return something friendly like 0 or -1 if the dimension didn't...

I have five users who want to share an Access 2002 database on a network drive. When they try to open it, it comes up with a couple of prompts. The first is the usual "Some files can harm your computer, open or cancel". If you reply 'Open' it then fails with aMicrosoft Access cannot open this...

I've just installed FC6. My 1680x1050 monitor seems to have been detected OK, and all works fine except that the display seems to be offset down and right by about 4 pixels. I can correct this by using the monitor controls, but as it's a dual boot machine I don't want to fiddle with it every...

I've just been struggling with a macro that works fine in Excel, but not when the same spreadsheet is displayed on a browser through Sharepoint. Errors vary from "subscript out of range" to "Method 'Range' of object '_Global' failed" Turns out that '_Global' is null under Sharepoint, so many of...

I have some code that allows me to selectively hide some columns in a big spreadsheet based on criteria set n a form. It all works fine except that when it runs, I can see it working as it iterates through the columns, which looks a bit clunky. Is there a property that I can set while it runs...

I have a test harness that needs to display the actual XML data returned from a messaging system. Currently the result gets displayed in a <textarea>, but any XML entities such as &amp; get displayed by the browser as the translated value & As I am trying to display the 'real' XML returned by...

I've just discovered the perl plugin for Eclipse, available from http://e-p-i-c.sourceforge.net Assuming you have Eclipse (108MB download), JDK (60ish MB download) already, it's pretty easy to install. Gives you a perl-specific editor perspective, syntax highlighting, code completion...

I am using the VAPI-XP mechanism to invoke a specialised test harness via a web service, process the response, and post the result back into TD. It all works fine, but... My VAPI-XP script gets all the variable information it needs from the three passed TD objects (TestSet, Test, Run). So the...

I'm serving up dynamic PDF documents from ASP.NET. Normally, they render OK, but on certain browser/OS combinations they take 7 minutes to render (simple 1-page document). If I use the same browser/OS to get a PDF document from the Internet, it renders in a few seconds. I'm sure it's something...

I have a web service, accessed from an ASP page. Somewhere between calling the web service, and it being de-serialised at the WS end, any UTF-8 'wide' characters like £ get translated to '??'. These then get saved on the database (NVARCHAR columns, so Unicode should be OK). However, if I store...

I have an Access DB with about 30 tables, that I need to map onto a much larger number of tables on SQL Server as part of a migration exercise. I'm used to being able to get the schema metadata (table names, column names, column type, nullability etc.) from the system catalog by running an SQL...

I had to prove that a developer was handling deadlock timeouts correctly the other day. In order to generate a 'deadlock' The following bit of T/SQL was quite helpful.BEGIN TRANSACTION UPDATE party SET somecolumn = 'something' WAITFOR DELAY '00:01' COMMITAlthough you could argue that...

Does anyone have any experiences or recommendations for a database diff tool (compare two databases, highlight the differences, make a script to synchronise them). There seem to be several on the market (e.g. Adept, Apex, Red Gate) at similar prices. Project timescales mean that I don't have...

This is really a .NET question, but I'm posting it here instead because it's also a design issue. I have an existing application that needs to be enhanced to add auditing. The simplest place to hook this up is in the Web Service classes. These all inherit from a Layer Supertype [Fowler] that...

I'm using ActiveState perl 5.1.8 on a Win2003 server box. I had to parse a tab-delimited file created by Excel. Some of the cells in the spreadsheet contained LF characters. Each record was separated by CRLF. When I read the file with perl, it split the lines on LF, not CRLF as expected. $/ was...

I have a number of PCs at home running Fedora 2 (soon to be Fedora 3). Fedora checks for available updates, and has an update application that will download them and install them for you. Recently they issued an update for OpenOffice, which was absolutley huge (over 100MB with all the...