Search results for query: *

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

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

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

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

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

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

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

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

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?

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.

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

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

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

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

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

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.

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

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

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

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.