Search results for query: *

Is it considered Oracle best practice to create new datafiles, or expand existing ones as they become full? Cheers, James

As a SQL Server person, I am trying to recover our live Oracle database to a test server just to prove the backups work. We have a weekly full database backup using RMAN, along with the control file and archive logs. I would like to recover the database using the backup, and archive logs onto a...

I am looking at an application which was written in VB6 (I think although it might be VB4). A number of the forms attempt to use the MSGRID.Grid control, which I dont have. When I attempt to load the forms into the designer they show as PictureBox controls, & when they are loaded at runtime...

I am looking at an application which was written in VB6 (I think although it might be VB4). A number of the forms attempt to use the MSGRID.Grid control, which I dont have. When I attempt to load the forms into the designer they show as PictureBox controls, & when they are loaded at runtime...

I have a demand dial VPN which connects from a Win2K server to a remote WinXP Pro machine. The network for our office is 192.168.10.0/24 The network for the remote location is 192.168.12.0/24 I configured the demand dial connection as appropriate. I added a static route onto our broadband...

In the standard web page layout of a header bar along the top, menu bar on the left, content in the middle & footer bar along the bottom what is the preffered method of implementing this? I currently use tables to position objects where I want them, but I am not sure if this is the best...

We currently have to produce a period report which contains mostly text, but with some data from a database of ours. It is currently produced from a Microsoft Word Template, but I dont like the way the user has to manually remember to refresh the linked table data. The report is approximately...

I have a view, qryStorageLocationSelector which I need to use to populate a series of 4 listboxes. The view has the following columns: Level1ID, Level1, Level2ID, Level2, Level3ID, Level3, Level4ID, Level4, LocationID Obviously, there can be multiple occurances of Level1,2,3,4 values etc. I...

At the moment, I am referencing the styles.css value in the html portion (e.g. <H1><asp:label...></h1>) of my control declarations. Is there a way to use the CssClass property of the control itself? James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com

Ok, I had an ASP.NET application which after much trouble worked on a server, SERVER1. I need to move this application to another server, DC2. Both are domain controllers, both are running the same OS, SP etc. The files are stored in C:\NET\App on SERVER1 & D:\NET\App on DC2. I tried...

I have the following query results & I need to calculate the perct column based on the total for a type (e.g. Bramble). Type Priority Count Perct Bramble A 25 62.5 Bramble B 15 37.5 Any suggestions? James Goodman MCSE, MCDBA http://www.j.goodman.dsl.pipex.com

I am having a bit of a moment to myself & canont think how to do this. I have the following results returned in a query: Type: Priority: Count: Perct: Bramble A 25 62.5 Bramble A 15 37.5 I need to calculate the Perct column. Any suggestions? James Goodman MCSE...

I regularly (every week) fly for work. To do this at the moment, I have to manually check the website of the couriers I use (Primarily Easyjet, BA, BMI). This is a repetitive task which takes quite a lot of time, so I was thinking about automating it. Basically, I need to collect the prices...

I am executing some SQL to insert a record into my underlying DB. I have a number of parameters, one of which is a date field. This may or may not be null. If it is null, I want null inserted, rather than the 01/01/1901 default. I am therefore using the following, which I am sure worked a few...

I am using a dropdown within a datagrid to edit existing records in an underlying table. I used the example from 4guysfromrolla.com & modified the GetSelIndex function slightly for my needs. I currently have it on my aspx page. Function GetSelIndex(ByRef TableName As String, ByRef...

I have an sp with paramaters like this: ALTER PROCEDURE dbo.SomeProc ( @SortBy varchar(50) = NULL @ShowComplete bit = 0 @StaffID int = NULL ) AS DECLARE @SQL varchar(2500) SET @SQL = 'SELECT StaffID, Status FROM SomeTable ' IF @StaffID IS NOT NULL SET @SQL = @SQL + ' WHERE StaffID =...

I am writing a PocketPC app, & have a number of forms which load into a single panel control. These forms contain a series of tab-pages. Examples of tabs would be location, data, work etc. The location tab is common for all types of record & every form needs a location tab, containing the same...

I have customized a site based on the IBUYSPY microsoft sample. I need to process credit cards in order to take payments. I presume the easiest way is to use a 3rd party merchant service? This being so, can anybody recommend any card processing companies (preferably UK)? It needs to handle...

The following is related to a Mobile .NET application I am experimenting with. I have a main form, which has the following controls: 2 x Combo boxes. 1 x Command Button 1 x Panel control I then have two (at this stage but it will increase) other forms. I want to load the forms into the panel...

I have written a small ASP.NET application. I developed it on my workstation & it works perfectly. It is basically a small data-entry app which connects to a SQL Server DB. It uses Windows Authentication to Authenticate users. I have set IDENTITY IMPERSONATE="TRUE". Happy with the app, I...