• Delivery system

    hi there, i was wonderinf if you guys have any codes in VB.6 about Delivery system. i'm using using it as a reference for my thesis. any help would be great! thanks! :)

    Playah070 pointsBadges:
  • XML Publisher Issue

    We can't output a concurrent request via XML Publisher... We can create data definitions and link data templates (.rtf files) through the app, when we attach a data.xml preview file, we can preview the output correctly. When we actually attempt to run the concurrent request, the output shows the...

    Dmcdconsult40 pointsBadges:
  • Oracle sql statement log

    Hi, We're currently trying to debug an application that is running queries thru jdbc/oci against our oracle 9.2 DB. While we have no way of finding out what is going on in the application we would like to trace all the sql statements that are run against our database (including 'select'...

    Pingsc0 pointsBadges:
  • Database Tuning Advisor “not permitted” error on SQL Server 2005 DE

    Hi! I've bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I've installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: "Tuning this edition of...

    Volrat0 pointsBadges:
  • Daylight savings – Change in politics

    Greets to all, First off, where I live (WA, Australia) we have had a change in politics. We now have daylight savings starting in 1 week. The problem is as follows. Details * 3 Domains (not linked to each other) * Multiple external sites (not tied back to base) * Multiple DB systems and...

    Nephi10 pointsBadges:
  • How to update a oracle table containing 4 billion records

    I want to update a column on the table containing 4 billion records. The table is partitioned and all partitions are compressed except the current month. I created the following procedure to do the update (I will do the update per month): create or replace procedure update_datetime_cdrdatanew is...

    Ws8oBPSQ15 pointsBadges:
  • How can I update a huge Oracle table containing 4 billion records

    I want to update the table containing 4 billion records. The table is partitioned and all the partitions are compressed except for the current month. I added 1 column to the table and must update the column with a value. I created a procedure that must do the update. Procedure: create or replace...

    Ws8oBPSQ15 pointsBadges:
  • Executing a Function or Procedure from ouside Oracle

    I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

    Moonmullins0 pointsBadges:
  • DB Migration from 8.1.7 to 10gR1

    I want to migrate from 8i(8.1.7) to 10gR1 in a new server. I will shutdown 8i and run with 10gR1 in a new server. If any of my application not working with 10g ,i need to fall back to 8i in old server. Is it possible to take only the delta changes from 10gR1 which has happend for such duration and...

    Ajmalziyad0 pointsBadges:
  • Oracle Parse – Instr

    I'm receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, '|', 1, 1); v_meter2 := instr...

    Dava190 pointsBadges:
  • Table not using index

    Good day, I have a table containing 4 billion records and adding 7 million records per day, working with a date and timestamp. Currently the table is created with a date (charging_date) and a timestamp (named timestamp but with format varchar2(6) - i.e. '065000' for 06H50 AM). I created a new...

    Ws8oBPSQ15 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • Testing how long an SQL script will takfe to run

    Running Oracle 9.2.x. We have to sun a couple of SQL scripts that will make some changes to tables/data. Is there a way of finding out approximately how long these scripts will take without actually running them? Is there some tool I can use to do this? Or some rule of thumb?

    Pingsc0 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • Table Level Triggers – Triggers on Two Fields Within the Same Table

    Hi, I was wondering if some can have a look at the following triggers on a single table but on two different Fields that are referenced in both triggers: CREATE OR REPLACE TRIGGER AAL015_HWT_TRG BEFORE INSERT OR UPDATE ON AAL015 REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN IF INSERTING OR...

    SamAvella30 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • Tools for DDS to DDL migration

    Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

    Newbie4000 pointsBadges:
  • ODBC connections

    We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to...

    Jade057110 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • dynamic visual basic form based on access database table

    I am useing an access database table to populate some lists. I want to dynamicly add picture boxes that I use to seperate the list box as if lined based on how many records I have in the database. Basicly, I just need to know how to add a control by code. I don't want to have to place 100 picture...

    YitoGraft0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following