Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. eseabrook2008

    INSERT rows with other table info and explicit data in same statement

    Gah! I knew I was missing something. Thanks Mufasa!
  2. eseabrook2008

    INSERT rows with other table info and explicit data in same statement

    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...
  3. eseabrook2008

    Possitble to view messages in Outlook Today?

    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?
  4. eseabrook2008

    administrator logon strange issue

    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.
  5. eseabrook2008

    Access Denied status of print queues

    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...
  6. eseabrook2008

    Question about understanding ORA-01652 error

    I've been advised that I need to re-create that tablespace. The temp tablespace is set to permanent so I've been advised to recreate it as temporary.
  7. eseabrook2008

    Question about understanding ORA-01652 error

    Also, this is a prod DB. What are the implications of running alter tablespace TEMPDATA01 coalesce; while users are accessing the system?
  8. eseabrook2008

    Question about understanding ORA-01652 error

    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...
  9. eseabrook2008

    Question about understanding ORA-01652 error

    So run: alter tablespace TEMPDATA01 coalesce; ? I thought SMON took care of this periodically? It should be noted that is a dictionary-managed tablespace.
  10. eseabrook2008

    Question about understanding ORA-01652 error

    The result of: show parameter db_block_size is: NAME TYPE VALUE --------------- ------- ------ db_block_size integer 16384
  11. eseabrook2008

    Question about understanding ORA-01652 error

    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?
  12. eseabrook2008

    Question about understanding ORA-01652 error

    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...
  13. eseabrook2008

    Reference object between forms

    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)...
  14. eseabrook2008

    PITR in Windows

    Permission problem on the Postges install directory. Fixed.
  15. eseabrook2008

    PITR in Windows

    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...
  16. eseabrook2008

    extract data from Long Raw field

    By "get those files back", I mean extract the data in that field, "recreate" the file and save it to a new location.
  17. eseabrook2008

    extract data from Long Raw field

    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...
  18. eseabrook2008

    Combine two strings to produce form field name

    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).???
  19. eseabrook2008

    Combine two strings to produce form field name

    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...
  20. eseabrook2008

    Problem with passing value between forms

    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...

Part and Inventory Search

Back
Top