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 derfloh 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: *

  • Users: DirtyB
  • Order by date
  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...
  16. DirtyB

    clearing dates in VBA

    Thanks for the reply. If you set it equal to zero, it inputs a date of '12/30/1899'. I found that setting it equal to the keyword 'Empty' is working for me in case anyone else wanted the answer.
  17. DirtyB

    clearing dates in VBA

    I have a loop of code that i'm running where I clear out variables, then set them equal to a value, then update my recordset...pretty standard. When you clear a string variable, I just set it equal to empty string "". How do I clear out a variable of datatype date? I want to set it...
  18. DirtyB

    Null Dates

    just so you guys know...i'm going to post this in the VBA forum...decided that might be a better place...
  19. DirtyB

    Null Dates

    Easy one for everyone, I should know this answer but am having a brainfart. I have a variable called startdate. It gets set in a vba loop. At the beginning of the loop, I clear out my variables from the previous record, and set them again, then update my recordset. If it were a string, I...
  20. DirtyB

    Nested Left Joins in Access

    That doesn't seem to work. I've put the parentheses where you said, and I also tried them before the first two left joins and after the last two on's..that didn't work either.

Part and Inventory Search

Back
Top