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

    Using COM object in Excel

    tbl, hi, I am not sure how to answer this thread, however I am very curious to learn something about how do accomplish such a task in excel or other applications you have built. thanks shefea
  2. shefea

    extract a decimal(5,2) time field URGENT!!

    Hi i have a time field in DB2 Database that is storing time as a decimal(5,2) where the max value is 6 for the .XX minute part. How can I go about putting this into a number minutes format or number of hours and minutes format? Someone suggested the folowing but its for Oracle not db2...
  3. shefea

    Access to Word or HTML

    Hi, I have a access application that creates a graph in access. I want to export it to a drive so that others can open the graph in another application such as Powerpoint, or Word or HTML. My problem is when i tried to export using a .txt html template and a recorded macro executed by a .bat...
  4. shefea

    adding another tables column to a left join statement

    Hi I have the following query that is working just fine.. SELECT S.EMPL, S.QUALVDTE, S.CAT, S.CACTIAT, S.CACTIATC, S.CFUNC, S.CSFUNC FROM SUDMP.TCRMQAL S LEFT JOIN SUDMP.TCRMQAL S1...
  5. shefea

    selecting a result based on latest date

    Hi, I could use some help, please. I have a table with Emp_name, Certif_date, work_loc columns. I want to select the emp_name,work_loc and the latest (most recent) certif_date. some emp_names have multiple certif_dates and I want to latest one. I am familian with if begin and case statements a...
  6. shefea

    Oracle 8.1.7 on NT or W2K - what is prefered????

    Hi, let me tell you from experience that 8.1.7 and win2k are a nice match. Administrator features of win2k are great for monitoring I/O, permissions of o/s. and terminal services problem that existed in 8.1.6 is solved. Plus with the proper layout of the database and about 1024k of RAM....you...
  7. shefea

    hazardous dropping of tables

    You would probaby want a trigger on any DDL for the user. that also selects the machine (which they are logged in from V$session), as part of the intsert statment that makes up the trigger, so effectively inserting this information into an table created solely for the use of this trigger. My...
  8. shefea

    Oracle error:Unable to extend temp segment by 140 in tablespace SYSTEM

    You should NOT be running transactions in the SYSTEM tablespace, nor should your SYSTEM tablespace be used to house the TEMPORARY Segments. I sugges you speak with you DBA immediately. If you have no other choice then to use the current tablespace you can resize the datafile if you know the name...
  9. shefea

    Exchange is turning my xml into xml attachments

    Hi, Im having trouble with Exchange, once I send mail(xml form) into exchange it converts the xml into a mail with an xml attachment, and then passes this one to the pop account application that calls for the mail. Has anyone has a similiar problem? Is there a way for me to override this...

Part and Inventory Search

Back
Top