ODBC and Database Designer not seeing rows in a table !
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 ?
have you committed that session?
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).
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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
