Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Disappearing records in VB/Oracle
you don't post your code but the obvious place to start is to ask if you are committing in sql*plus?
i.e.
>insert into dept (deptno) values(1);
>1 row inserted
will not appear in VB because the insert has not been committed.
however ODBC autocommits so the same insert statement in vb actually becomes
insert into dept (deptno) values(1);
commit;
regards (and sorry if i'm teaching my proverbial grandparent.
-- Niall Litchfield Oracle DBA Audit Commission UK "Arne Rasmussen" <arr_at_wanadoo.dk> wrote in message news:98qnag$4er$1_at_news.inet.tele.dk...Received on Thu Mar 15 2001 - 10:28:37 CST
> Hello there
> Im about to develop a C/S solution with Oracle 8.1.6 and VB, and i've
> experienced somthing - for me - extremely odd. I created 3 rows with
Oracle
> sql*plus and they are quit visible in a select, then i tried to see them
in
> VB's SQL-Builder with a select ...with no result....then created 2 rows in
> VB's SQL-builder, and these are visible in both Oracle SQL*Plus and in
> VB....but in VB i can only see the rows created with sql-builder not the
> one's created with SQL+.
> The table only consist of 2 fields an ID (number wich is generated by a
> sequense and a trigger before insert), and a char(10)
>
> I'm about to go nuts due to this problem ....somebody please help me
>
> Kind regards
>
> Arne Rasmusssen
>
>
![]() |
![]() |