I'm trying to created an INSERT statement to insert data from another table as well as explicit data. This is what I've tried:
**this statement gets all the agentid's I need**
INSERT INTO SYS2_CSIO_BROKERINFORMATION
(AGENTID)
SELECT DISTINCT agentID
FROM Sys2_AgentsAndDirectors AD
WHERE...
Is it possible to view messages in Outlook Today. Rather than just seeing the number of unread messages, I'd like to see those messages (Date, From, Subject). Any ideas?
Sounds like something is attempting to authenticate with the wrong credentials. Check the Event logs and see if anything is being logged. This happens to us if a password is changed but a service is left with the old password.
I have a strange problem happening, to which I found a solution, but don't understand the problem.
Print Server - Windows 2003 R1
Workstation - Windows XP Pro SP3
Printers are all HP
We have many print queues setup on our print server. Out of the blue, a few computers starting having...
Before I go any further, I guess I should clarify something. I just went through the Storage Manager again and I mentioned the wrong numbers. The Datafile is still 63GB and there is still only 2GB used but the extent on the Datastore is:
Initial size: 304 KB
Next size: 160 KB
Min size: 0 KB...
So run:
alter tablespace TEMPDATA01 coalesce;
?
I thought SMON took care of this periodically? It should be noted that is a dictionary-managed tablespace.
All I know is it has been working fine up until recently. With auto extend on, does that mean the datastore can grow (to the size of the datafile) or that the datafile can grow based on the specified increments? Or does that even make sense?
This error has started coming up in the last couple days when we run queries that we've run many times in the past. I've googled the error and read many articles about what it means and how to resolve it but I'd like to understand why it's coming up in our particular situation. A quick look at...
I'm very new to vb.net (last used vb6). My situation is that I have a form1 with a combobox (cb1). When a certain item is selected in the combobox, form2 opens.
'initial declaration
Dim FORMNAME
'inside combobox SelectIndexChanged event
FORMNAME = New contractequip
FORMNAME.ShowDialog(Me)...
I've been struggling to learn how to do a PITR in Windows. I can create the archive and I can start and stop the back but when it comes to creating the recovery.conf file, something seems to go wrong. The command I've been doing is:
restore_command = 'copy C:\\archive\\%f "%p"' # Windows...
I have inherited and database (oracle 9i) with a table called "attacheddocuments". In this table is a field called "object" that is of Long Raw type. This field contains files that users have attached (via the front end system). My problem is we are suppose to change to a new system and need...
How would you replace the textboxes with variables?
Me.TextBox1.Text = CType(SubForm.Controls("TextBox1"), TextBox).Text
Me.TextBox2.Text = CType(SubForm.Controls("TextBox2"), TextBox).Text
VariableMainForm = CType(SubForm.Controls("VariableSubForm"), VARIABLE).???
Background:
I have a main form with a combo box. Each item in the combo box opens a subform where the users selects certain info and clicks submit which assigns values to public variables and closes the subform. This works as designed. Since I will have multiple subforms, I want to create a...
I've gone through the article about passing values between forms and ran into a problem.
Here the scenario:
Click a button on FORM1 and open FORM2
FORM2 has a treeview.
Select a node and pass the value back to FORM1 and populate a text box with the value.
It appears to work but once the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.