Search results for query: *

Hi does anyone know of a way around linking a db2 table with lots of indexes. I have a particular table that wont link and the error I get says it cannot link because the table has too many indexes Thanks Andy

I am trying to create a fleixble (table driven) aggregation query and would appreciate your assistance. I have a table fo revenue values which I need to be able to simply group and change the groupings (without having to change the underlying SQL) any ideas? e.g I have a table contaning...

see my faq183-2146 hope it helps Andy

I am preparing a continous forms sub-form to present historic revenue data /account (since jan 01) and also to capture revenue estimations going forward to the end of 2003 The format is 12 monthly rows, 3 columns headings i.e. 2001, 2002 and 2003. I want to ensure that no historic record can...

iis5, win2000 server, winnt4 client, ie5.5, form method=post I'm reasonably new to asp so apologies if this is a very obvious request but I have a problem that the values being passed over to request.form are truncated at the end of the first word e.g.country of france is passed fine but...

We have recently upgraded our database from SQL 7 to SQL 2000 and have encountered a problem with respect to the new collation features. A number of our stored procedures create temporary tables, some of these did not now work following the upgrade and the following error is reported Server...

I have a situation where I have a table of data where I have many competitors/deal e.g. Deal Competitor 1 X 1 Y 1 Z 2 X 3 Y 4 Y 4 Z I want to create a query for reporting purposes which concatenates all competitors/deal together e.g. Deal Competitors 1 X,Y,Z 2...

I have a legal document with a message box that pops up when the document opens to remind staff to do various things. The trouble is I only want to show this once. I want a simple method of removing this message box before they send it on to clients etc. I would prefer that they didnt have to...

I want to create a hyperlink to a file on the cd-rom of a users PC. The problem is that different users have the drive mapped to different letters. Does anyone know a way of generically referencing the CDROM within a hyperlink? Thanks Andy

Crystal Reports 8.5. Can anyone help with a problem I have had with a bubble chart. The chart has over 400 points (and can have potentially more in the future) aad has been built to show patterns of information. In order to avoid confusion as to what different colours on the chart may mean I...