Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: stevexff
  • Content: Threads
  • Order by date
  1. stevexff

    Nested subselect in INSERT with static SQL?

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

    Temporary tables in transactional systems

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

    Getting dimensions of dynamic arrays

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

    Access 2002: shared MDB on a network drive

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

    FC6 xorg display offset problem

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

    Sharepoint Excel problem

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

    Suppressing re-draw in Excel

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

    Need to display raw XML in a textarea

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

    Eclipse perl perspective

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

    VAPI-XP question

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

    Problem serving dynamic PDF documents

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

    Web service XML serialisation problem

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

    Is schema metadata available for Access?

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

    Testing timeouts

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

    SQL Server diff tools

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

    How to get the name of current Web Service method

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

    CRLF in Windows

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

    Fedora auto-update

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

Part and Inventory Search

Back
Top