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!

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

Recent content by DirtyB

  1. DirtyB

    Search for tick mark

    THANK YOU...that was quick too, need a job? :)
  2. DirtyB

    Search for tick mark

    Hi everybody... I have a name field here and want to get rid of the "O'donnels". Can someone tell me the syntax for searching a column for a tick mark? thanks
  3. DirtyB

    saving passwords in TOAD and SQL Nav

    I have Toad and SQL Nav here. We just moved an instance of a database from one server to another. I changed my TNS Names files, however, I cannot connect to the new instance via TOAD or SQL Nav. I can connect with SQL PLUS, which tells me that my TNS Names file is ok and the DB is ok. I...
  4. DirtyB

    VBA vs. VB

    I apologize for asking this question, i'm sure it's already been addressed in here at some point, but a search didn't turn up much. Can someone tell me what the fundamental difference between VBA and VB is? Why didn't Microsoft just embed regular VB into it's apps? Thanks
  5. DirtyB

    client tools

    I have never used DB2 or an AS/400. We have one on our network now and need to do data exports from it, for other systems. Can anyone point me to some sort of client tool to connect, and export data from the DB2 database? thanks
  6. DirtyB

    Blocking Locks

    Thanks for the info. I agree, I was in TOAD watching the "blocking locks" and SEVERAL people were being held up. Now, we've ran the Analyze, and haven't had one locking block all day. The vendor did think that I was refering to a performance problem, in reality it was a locking...
  7. DirtyB

    Blocking Locks

    Hi all... I'm fairly new to Oracle and am experiencing extreme problems with users locking records and blocking out others. Our software vendor has suggested we run the ANALYZE (compute statistics) and this will fix our blocking locks. Does anyone see a correlation here? We have run it, and...
  8. DirtyB

    if statement within select statement

    Thanks everyone....Turkbear...i'll check that out.
  9. DirtyB

    if statement within select statement

    SFVB: Thanks!! I think this is a good solution to solve my current problem. But for future reference, in Oracle can you put an "if" statement within a select statement?
  10. DirtyB

    NEWBIE

    WOW! Thanks everyone. There is a lot of good information in this post and I really appreciate it. Now if I can minimize my learning curve i'll be able to start writing some real code in Delphi and have a better judgement.
  11. DirtyB

    if statement within select statement

    I'm fairly new to Oracle. Can I put an "if" statement within my "select" statement to determine what value i'm returning? for example: select field 1, field 2, field 3, if field 4 in (select field 1 from TABLE 2) (here I want to return string...
  12. DirtyB

    NEWBIE

    WGCS: THANK YOU. I am just trying to convert data types, from string to number, etc... Your response was what I was looking for, sorry if it wasn't clear. Svanels: If I write an app in Delphi, can I only do client/server, desktop apps, or can I write web deliverable applications? Also...
  13. DirtyB

    NEWBIE

    This is my first day using Delphi. I was wondering if anyone knows some good resources for very basic things. What is Delphi? What is it used for? Can it be used over the web? And more specifically, how do I change data types? Thanks
  14. DirtyB

    clearing dates in VBA

    AHHH, more problems..maybe someone can help me with this one too? After this piece of code If Not IsNull(rs!HEPDate2) Then dteHEP2 = rs!HEPDate2 Else dteHEP2 = Empty End If if rs!HEPDATE2 is null, it will now be set to "Empty&quot...
  15. DirtyB

    clearing dates in VBA

    Wow, that's interesting, thanks for the info. Just out of curiousity...I am exporting these tables and importing them into an OracleDB. If I run an export on these dates that are showing as "12/30/1899" will it export that date or a null or a zero to the text file? I'll check it...
See more

Part and Inventory Search

Back
Top