Options

ODBC and Database Designer not seeing rows in a table !

scoulibalyscoulibaly
in General Discussion
Hi thre, I've created a new table and inserted one row, so select * from newtable yields 1 row. However, when I use ODBC, or when I start Database Designer, they both tell me the table is empty. Any clue ?

Comments

  • Options
    Ravi_GuptaRavi_Gupta
    have you committed that session?
  • Options
    scoulibalyscoulibaly
    Hmm, committed it. Seems ok now ! Thank you Ravi. I thought autocommit default value was 'on' (since an uncommited CREATE TABLE made the table to appear in the tables catalog).
  • Options
    Ravi_GuptaRavi_Gupta
    If autocommit is ON, then data is not committed automatically until you leave the session. DDLs internally do commit and are immediately visible to all sessions because it is catalog change.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...