Jump to content

kokoroinaka

Member
  • Posts

    2
  • Joined

  • Last visited

  • Donations

    0.00 USD 
  • Country

    Japan

Posts posted by kokoroinaka

  1. hello,

    I am developping a C#. application which uses Oracle 9i,

    I get ORA-00001(unique constraint) Error on executing the sql below;

    I know sql below is little strange( which use unique key in 'SET' statement) .

    but It worked on My Oracle Server. but it didn't on Client's.

    does anybody know why this error occurs or why this error did not occur on my PC,

    thanks,

    [update sql](key is CD and SDATE)

    Update TBL1

    set CD = 'A',

    NAME = '1',

    SDATE=TO_DATE('2008-10-31 00:00', 'YYYY-MM-DD HH24:MI' )

    WHERE

    CD = 'A'

    and SDATE=TO_DATE('2008-10-31 00:00', 'YYYY-MM-DD HH24:MI' )

    [table definition]

    CREATE TABLE TBL1

    (

    CD VARCHAR2(8),

    NAME VARCHAR2(30),

    SDATE DATE,

    DATATEXT VARCHAR2(100)

    )

    [unique constraint]

    CREATE UNIQUE INDEX TBL1_KEY1

    ON TBL1

    (CD, SDATE)

    PCTFREE 10

    INITRANS 2

    MAXTRANS 255

    TABLESPACE INDEX_SPACE

    STORAGE(INITIAL 500K NEXT 500K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

    LOGGING

  2. hello friends,

    I'm developping windows application on C#,

    I put hSclollbar and vScrollbar into Windows.Panel.

    I run the application, and pressed left cursor key upon the panel.

    then hScrollbar gets focus even if it was not focused before(focus was on panel).

    I don't want scrollbar focused on, but the panel;

    does anybody know how to keep focus on Windows.Panel when cursor key pressed?

×
×
  • Create New...