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!

Search results for query: *

  1. Shatneriffic

    Default Value of SYSDATE in a Date field throws error

    Unfortunately, in this case there are no triggers. Looks like it's time for an SR. Thanks to you and everyone for taking time to look into this for me. At least you validated that I wasn't going crazy.
  2. Shatneriffic

    Default Value of SYSDATE in a Date field throws error

    Correct. The statement you posted will throw an error. It will also throw an error if you decide to leave the sysdate out alltogether, and ignore the input to the ROW_ADD_TMS.
  3. Shatneriffic

    Default Value of SYSDATE in a Date field throws error

    There are no other columns with a DATE datatype. I remove the ROW_ADD_TMS column and the insert works. Weird, huh?
  4. Shatneriffic

    Default Value of SYSDATE in a Date field throws error

    Column Name: ROW_ADD_TMS ID: 12 Pk: Null?: Y Data Type: DATE Default: sysdate Histogram: No
  5. Shatneriffic

    Default Value of SYSDATE in a Date field throws error

    insert into PROD.TBL_PROD_ME (MNTH,HOURS_NOHOURS,NAME,TOTAL_STFD_TIME,COLLECTOR,COMMENT_ADDED_ID,CALLS,CONTACTS,PROM_TO_PAY,KEPT,SUPERVISOR) SELECT MNTH, HOURS_NOHOURS, NAME, sum(case when TOTAL_STFD_TIME is null then 0 else to_number(TOTAL_STFD_TIME) end)...
  6. Shatneriffic

    Default Value of SYSDATE in a Date field throws error

    Hello I am inserting data into a table and have a ROW_ADD_TMS column that is set in the table to default at the sysdate. When I attempt to insert data, this field throws the following error: ORA-01840: input value not long enough for date format When I try take the default value off of the...
  7. Shatneriffic

    SaveCopyAs Path

    Thanks for the idea. However, when I do that, it gives errors after each back slash saying something to the effect that an 'escape' had been found coded multiple times.
  8. Shatneriffic

    SaveCopyAs Path

    Hello I'm trying to use VB.NET to save an open spreadsheet to a network drive and am receiving errors when run the code. Here's the line where the problem exists. excelWorkbook.SaveCopyAs("//wsent01ts/callgrp/reports/Accts 120 ME.xls"); I can save it manually to this path...
  9. Shatneriffic

    Excel Pivot Table Datasource Change

    Hello We have a development and production regions for our oracle environment that support reporting in Excel pivot tables. How do we point our pivot tables in the development schema to the production schema without having to rebuild them from scratch? Thanks!
  10. Shatneriffic

    Automatically Refresh and Publish Spreadsheet

    Hello We have an app that opens, refreshes and publishes a ton of Excel spreadsheets with pivot tables to a web folder. Most of the spreadsheets update fine. However, one just keeps being published with the data from the exact same date everyday. Below is the code. Section 1 is an example of...

Part and Inventory Search

Back
Top