Search results for query: *

Hi All, I am building an Access DB to control the running of Essbase loads and recalcs on a number of different cubes. I believe that I can use the shell command to start the dataloads and recalcs. As some of the recalcs take hours and I can't wait until one load/recalc has finished before I...

Hi Everyone, I have a report which shows the view of a fantasy world. The view consists of a number of image controls stacked on each other. The view was created by placing the furthest controls and bringing them to the front, placing the next nearest and bringing them to the front etc etc. I...

Hi, I have a job that processes a file of SQL statements. The latest file was about 16M in size and contained 60K SQL statements. Recently, this job has been failing, seemingly at random (we had zero failures last week) then three this Tuesday, issuing the following message...

Hi all, I have a schema for P14 returns to the inland revenue. I am having a problem with <line> when validating the file. The <line> is part of <xsd:element minOccurs="0" maxOccurs="1" name="Address" type="InternationalAddressStructure"/> and for some reason the XML we have is failing the...

Hi, I have this query which is listed below. The main sort is field E.VTARECLK and I have the report grouping these with page throws etc. I have been asked to provide a number of unique A.SERNUM within each group of E.VTARECLK. I can get the count of records in each group, but I have been...

Hello, I seem to have a problem showing some graphics on a form using my home pc, but the one I use for work seems fine. My home PC is an Athlon 64 3200, 512mb ram, dual 80gb SATA drives in a striped raid running Access 2002 in Wondows XP. My works pc is a laptop with a P3 at 1133mz with 512mb...

Hi, I am wanting to build a view of terrain that a character is looking at within a PBM (Play By Mail) game. The characters could be looking in any direction from any 1 of over 6000 'squares' (Similar to the way that it was done in Lords of Midnight, anyone remember that old gem). The terrain...

Hi, I am wanting to build a view of what someone is looking at for a PBM. (Similar to the way that it was done in Lords of Midnight, anyone remember that old gem. The terrain in the distance is build first, then each terrain type is added using a bigger picture as the view gets nearer the...

Hi everyone, I am running the following code to import multiple files into a table. I am getting an error, which I am expecting, but for some reason the Importerrors table is being locked and therefore the delete portion of the code is not working. The only way I can manually delete the tables...

Hi everyone, I am running the following code to import multiple files into a table. I am getting an error, which I am expecting, but for some reason the Importerrors table is being locked and therefore the delete portion of the code is not working. The only way I can manually delete the tables...

Aplogies if these have already been answered, but as you know the search facility is down at the moment 1. Does a select statement that is populating a recordset run faster when only those fields required are named than when * is coded 2. When you run a select statement where only 1 record is...

I have the following code which is creating records into a table to 7 days in the future. The code gets todays date, checks the latest date on the table and creates the relevant records. I know that the price_history!date_entered field is defined as a short date but the highlighted line does not...

I have a form that has many, many text boxes on it. I intend to populate these text boxes using code. I have a target petrol station and want to show data for the nearest 22 other stations around it. I already have the data in other tables, but rather than have to code form!address_1 =...

Hi, I have the following code that seems to be working properly, except that the caption property is only updated at the end of the procedure, basically telling the users that it is 100% complete. Can anyone show me how I would get the update everytime a record is processed. I am basically...

Does anyone have some example OS/390 JCL to issue a MQGET to retrieve a message and put it into a normal sequential dataset. I know this is a basic question (I might even be missing the point of MQ totally), but until last week, I had never heard of MQseries. Thanks in anticipation. Graham

My ISP hosts my ASP server in the US however any system time variables that I enter are in EST. i.e I submit an entry in the UK at 11am and it's shows that the record has been input 6am. I am using the following variable : DateAdd(&quot;d&quot;, p_length, Now) How do I add 5 hours ? Thanks...

I have the following code populating a dropdown listbox. The list box displays all records from &quot;REG&quot; except what should be the first one (Alphabetical order). When the first record is selected and the data saved, the &quot;ALIAS&quot; saved is the record missing as detailled above...

I am attempting to override the CBLQDA parameter through the JCL to the program. I have used :- //STEP0020 EXEC PGM=PXN2000,PARM='/CBLQDA(OFF)' //STEP0020 EXEC PGM=PXN2000,PARM='/CBLQDA=(OFF)' //STEP0020 EXEC PGM=PXN2000,PARM='/CBLQDA=OFF' //STEP0020 EXEC PGM=PXN2000,PARM='/,CBLQDA=OFF'...