Search results for query: *

Im wondering if there is a way of forcing a rollback and error if an SQL statement attempts to insert more than X rows into a table (its not an empty table, but a table used as storage for the results of another query). The value X is a varying value (on a per user basis), so probably cant use a...

I have a query that in certain conditions exhibits unusual behaviour when performing an index range scan. For example, I have 3 tables (simplified below, but note that its just an example to illustrate the problem and not my actual tables). Table RECORDS has 2 columns, ID number(20), STATUS...

I am seeing a strange problem whilst using sqldeveloper that defies explanation :) I have a *really* simple 3 table query that works when written one way and doesnt when written slightly differently e.g. :- select * from table1 T1 inner join table2 T2 on T1.id1 = T2.id1 inner join...

I am looking for a way to "mask" bits using an AND in a select statement, or equivalent. I need to replicate a select statement we have on SQLServer, that strips of the top bits of a number and returns the max value without them e.g. :- select max(cast(entity_id as bigint) & 0x0ffff) from...

At the moment, we have a system for displaying formatted results. As this is just a "picker" list, which displays a set of "user defined" details about a record, and on clicking that row - the full record details are displayed. The list is meant to be *indicative* of the data contained, not...

I am trying to duplicate a query from sqlserver which returns a single row from a one to many join. E.g. (rough example) you have a table of people, this is linked to a table with their phone numbers (of which they may have many). The query needs to return all the people, and just one (doesnt...

I am currently playing with userdrawn list controls, and trying to some simple things such as filling the background with a pattern, and drawing the contents myself etc. So for a part of this I have implemented a OnEraseBackground method, and do *stuff* in there for want of a better phrase...

Hi all, I have a question regarding static methods, I have done some reading up on them but cant quite get my head round them with regard to my situation. I have recently undertaken a huge re-write of our product replacing a mix of old primitive long & object Long id's with a new IDObject. Im...

I have a bunch of complex java objects stored in a blob column in a database - so far so simple :) Lets say these objects contain a primitive long member that holds an numeric ID of some kind, but this ID now needs to change from a long to a String holding some kind of guid (the actual scenario...

I have a couple of batch files that I wish to run as "external build tasks" after my application has built. These batch files are stored in a sub directory under the main project directory (for convenience from a source safe point of view), so I dont wish to specify a full path to them, and...

I am trying to come up with a query similar to an IN (1,2,3) statement, but that MUST match all criteria in a one to many relationship, rather than just some of. I have a working example of what I am looking for, but it just seems wrong to me, and as the queries are built up dynamically (and...

Does anyone know of any software that will run on a win2k box and log accesses (reads and executes) to shared directories? I have a large collection of useful articles and utilities, mostly freeware, but some are shareware - that I make available from my machine. I just want to log who has...

Is it possible to call a stored procedure, and use it's output within a dynamic sql statement. Background :- My requirements group have gone hierarchy crazy. In the Oracle implementation we are using connect by, but as SQLServer has no such thing, I have to use a stored procedure to calculate...

Occasionally - I get bouts of bizarre disk accesses under win2k, and have been unable to locate which process is doing it. Basically the drive keeps chugging away for about 1 second, then pauses for a second then repeats - this can go on for ages, and is usually only stopped by rebooting. It...